2464249 - LOAD TABLE statement ignores conversion error - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2464249 - LOAD TABLE statement ignores conversion error - SAP IQ

Symptom

SAP IQ ignores conversion error when adding only the "IGNORE CONSTRAINT UNIQUE" constraint violation to the LOAD TABLE statement.
As a result, invalid data (NULL) may be inserted in the table.

For example, when inserting the following data using the LOAD TABLE statement, SAP IQ inserts invalid data into a numeric column.

1,AA,
A,BB,

(DBA)> LOAD TABLE repro_tab (col1, col2) USING FILE 'load.dat' DELIMITED BY ',' ROW DELIMITED BY 0x0a QUOTES ON ESCAPES OFF IGNORE CONSTRAINT UNIQUE 0;
2 row(s) affected
Execution time: 0.01 seconds

(DBA)> select * from repro_tab
       col1 col2
----------------------
          1 AA
     (NULL) BB

(2 rows)


Read more...

Environment

  • SAP IQ 16.0 SP 08 PL23 and later

Product

SAP IQ 16.0

Keywords

LOAD TABLE. DATA VALUE, ignore constraint, CONVERSION ERROR, UNIQUE, NULL , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.