"LOAD TABLE not allowed on temporary table which has foreign key references from another table"
| Item |
Description |
|
SQLCode
|
-1146L
|
|
Constant
|
INVALID_LOAD_TABLE_WITH_FOREIGN_KEY
|
|
SQLState
|
WL009
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2820
|
|
Severity Code
|
16
|
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.