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 for Me (Login required).

Search for additional results

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