Local temporary table, %2, must be committed in order to create an index. %1
Item |
Value |
|---|---|
SQLCode |
-1000106 |
Constant |
EMSG_CAT_CANNOT_CREATEIDX_ONLTT |
SQLState |
QDB06 |
ODBC State |
ERROR |
parameter 1 |
Origin of the exception |
Parameter 2 |
table name |
Using the CREATE INDEX command on a local temporary table containing uncommitted data may cause the server to fail and generate this error message. Be sure to commit the data in the local temporary table before creating an index.