[
https://issues.apache.org/jira/browse/DERBY-5337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas closed DERBY-5337.
--------------------------------
Resolution: Cannot Reproduce
Closing this issue as "not reproducible". Knut has suggested a likely cause for
this problem, but without more information we can't be sure. The issue can be
re-opened if more information becomes available.
> 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
