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

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.