Symptom
- Insert into a NOT NULL column with no default value assigned to the column into a range partition table, IQ will insert NULL into the column.
- In a non-partitioned table or IQ 16 partitioned table you will get an error to the effect that a NULL value cannot be inserted into a NOT NULL column. Datatype of column does not matter.
- For examle:
Could not execute statement.
NOT NULL column 'b' was not included in this insert. Data is needed at row 1.
-- (db_insrt.cxx 2525)
SQLCODE=-1000151, ODBC 3 State="HY000"
Line 1, column 1
Read more...
Environment
- SAP IQ 15.4
- SAP Sybase IQ 15.2
Product
SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
Sybase IQ ; incorrect data ; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.
SAP Knowledge Base Article - Preview