[DERBY-5337] Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 10.8.1.2
• Component/s: SQL
• Labels: derby_triage10_9
• Environment: 3GB RAM, Windows XP SP3, Core i-5
• Urgency: Normal
• Bug behavior facts: Seen in production
• Assignee: Unassigned
• Reporter: Ranjit Aneesh
• Created: 15/Jul/11 12:10
• Updated: 07/May/12 14:29
• Resolved: 07/May/12 14:29

Description

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

Issue Links

• relates to: DERBY-3296 Importing to table in default schema fails when another table with the same name exists in a different schema