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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1