SAP Knowledge Base Article - Preview

2352148 - Error -111. Index name not unique - SAP IQ

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.