In this blog post, you’ll learn more about the Sybase Error LOAD TABLE not allowed on temporary table with ON COMMIT DELETE ROWS and the reason for receiving this error
Sybase SQL Error Message
LOAD TABLE not allowed on temporary table with ON COMMIT DELETE ROWS
Reason for this Error
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.