SAP Knowledge Base Article - Preview

3359604 - INSERT..SELECT inserts illegal NULL into column - SAP IQ


INSERT..SELECT statement attempts to insert a null into a column that does not allow nulls and causes an error.
NULL is not included in the SELECT result.

Could not execute statement.
  Column 'Col_A' in table 'repro_table' cannot be
  SQLCODE=-195, ODBC 3 State="23000"

  INSERT INTO repro_table

For example, when extracting only the SELECT statement, NULL is not included in the result.
This problem only occurs with INSERT..SELECT statements.



  • SAP IQ 16.1


KBA , BC-SYB-IQ , Sybase IQ , Problem

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.