Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

LOAD TABLE not allowed on temporary table which has foreign key references from another table

Error constant SQLE_INVALID_LOAD_TABLE_WITH_FOREIGN_KEY
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 16
SQLCODE –1146
SQLSTATE WL009
Sybase error code 13366
Probable cause

The LOAD TABLE statement removes all rows in a temporary table upon failure. If a temporary table being loaded caused an error then the foreign rows would be orphaned.