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 , 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.