SAP Knowledge Base Article - Preview

1893573 - Error 'db_sqlins.cxx:3501' : Cannot insert or update Column seq: set option 'identity_insert' to the specific table name containing the identity column to be modified.SAP IQ

Symptom

If a table contains an identity column, an error happens below when trying to insert values or update an identity column.

Exception Thrown from db_sqlins.cxx:3501, Err# 236, tid 6 origtid 6
O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1000293, SQLState: 'QDC75', Severity: 14
Cannot insert or update Column seq: set option 'identity_insert' to the specific table name containing the identity column to be modified.


Read more...

Environment

  • SAP SYBASE IQ15.2
  • SAP IQ15.4
  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

identity, identity_insert, db_sqlins, ErrID: 4098, SQLCode: -1000293, , KBA , BC-SYB-IQ , Sybase IQ , How To

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.