db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5337) Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Fri, 24 Feb 2012 21:59:48 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Mamta A. Satoor updated DERBY-5337:
-----------------------------------

         Component/s:     (was: JDBC)
                      SQL
            Priority: Minor  (was: Major)
    Issue & fix info:   (was: High Value Fix)
             Urgency: Normal  (was: Urgent)
              Labels: derby_triage10_9  (was: )
    
> Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
> -----------------------------------------------------------------------------------
>
>                 Key: DERBY-5337
>                 URL: https://issues.apache.org/jira/browse/DERBY-5337
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.8.1.2
>         Environment: 3GB RAM, Windows XP SP3, Core i-5
>            Reporter: Ranjit Aneesh
>            Priority: Minor
>              Labels: derby_triage10_9
>
> I am encountering the following issue when trying to call CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE.
> I am passing the schema name as has been pointed out as a possible cause conflicting
with multiple tables with the same name.
> The actual error is :
> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('DBA', 'TEST', 'C:/temp/unload/704.dat', ',', '"',
'UTF-8',0)
> The exception 'java.sql.SQLException: Column 'COLUMN2' is either not in any table in
the FROM list or appears within a join specification and is outside the scope of the join
specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a
CREATE or ALTER TABLE  statement then 'COLUMN2' is not a column in the target table.' was
thrown while evaluating an expression.
> This issue I am encountering in the 10.8.1.2 version of derby. I am using embedded driver

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message