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: JDBC
Affects Versions: 10.8.1.2
Environment: 3GB RAM, Windows XP SP3, Core i-5
Reporter: Ranjit Aneesh
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
