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

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

 

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.