Error 1000106

Message text

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

Probable cause

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.