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
  NULL
  SQLCODE=-195, ODBC 3 State="23000"

/sap/repro/repro.sql:1
  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