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.