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"
Create index , DDL, Rollback, Commit, implicit, if exists, duplicate, not unique, '-111', 42S11 , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.