"Local temporary table, %2, must be committed in order to create an index. %1"
Item |
Description |
SQLCode
|
-1000106L
|
Constant
|
EMSG_CAT_CANNOT_CREATEIDX_ONLTT
|
SQLState
|
QDB06
|
ODBC 2 State
|
ERROR
|
ODBC 3 State
|
ERROR
|
Sybase Error Code
|
20766
|
Severity Code
|
14
|
Parameter 1
|
location of the exception.
|
Parameter 2
|
Tablename
|
Probable cause
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.