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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Language extension detected in syntax near '%1' on line %2 Next Page

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


Item

Value

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.