In this blog post, you’ll learn more about the Sybase Error Local temporary table, %2, must be committed in order to create an index. %1 and the reason for receiving this error
Sybase SQL Error Message
Local temporary table, %2, must be committed in order to create an index. %1
Reason for this Error
To be able to create an index for a local temporary table, the table must be in a committed state. If this message occurs, the user has tried to execute a CREATE INDEX on a local temporary table that has had data inserted, deleted, or updated that has not yet been committed.