SAP Knowledge Base Article - Preview

2713748 - Invalid use of set option 'identity insert' - SAP IQ

Symptom

When setting the IDENTITY_INSERT option, you get the following error:

Invalid use of set option 'identity insert'. Table mytable does not have an
Identity/Autoincrement Column.
-- (dblib/db_Identity.cxx 172)
SQLCODE=-1000292, ODBC 3 State="HY000"
Line 1, column 1

Read more...

Environment

  • SAP IQ 16
  • SAP IQ 16.1 

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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.