SAP Knowledge Base Article - Preview

2248918 - Null value inserted in NOT NULL column on partitioned table - SAP IQ


  • 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



  • SAP IQ 15.4
  • SAP Sybase IQ 15.2


SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


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.