Symptom
Rollback does not work for create index.
When re-executing the SQL script, the following error message is fired, indicating that an index of that name already exists.
Index name 'xxxx' not unique
SQLCODE=-111, ODBC 3 State="42S11"
Read more...
Environment
Sybase IQ
Product
SAP IQ 16.0
Keywords
Create index , DDL, Rollback, Commit, implicit, if exists, duplicate, not unique, '-111', 42S11 , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.