LOAD TABLE not allowed on temporary table with ON COMMIT DELETE ROWS

Error constant SQLE_INVALID_TEMP_TABLE_COMMIT_ACTION
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 16
SQLCODE –993
SQLSTATE WL007
Sybase error code 13496
Probable cause

The LOAD TABLE statement automatically commits at completion. If a temporary table being loaded was declared with ON COMMIT DELETE ROWS, the rows are discarded at completion.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0