Symptom
When executing a load table command, it failed due to an error below.
The flat file to be loaded contains zero-length string for a specific column and the column 'c2' below has NOT NULL property.
I. 05/26 13:47:47. 0000000013 TxnVer 4952538 4952539
I. 05/26 13:47:47. 0000000013 Exception Thrown from dflib/dfo_CheckConstraintFilter.cxx:495, Err# 322, tid 15 origtid 15
I. 05/26 13:47:47. 0000000013 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -195, SQLState: '23502', Severity: 16
I. 05/26 13:47:47. 0000000013 [2126]: Column 'c2' in table 'jerry' cannot be NULL
Read more...
Environment
SAP IQ 15.x
SAP IQ 16.0
Product
Keywords
SAP IQ, IQ, load table, non_ansi_null_varchar, dflib/dfo_CheckConstraintFilter , 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.