"LOAD TABLE not allowed on temporary table with ON COMMIT DELETE ROWS"
| Item |
Description |
|
SQLCode
|
-993L
|
|
Constant
|
INVALID_TEMP_TABLE_COMMIT_ACTION
|
|
SQLState
|
WL007
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2660
|
|
Severity Code
|
16
|
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.