SAP Knowledge Base Article - Preview

2479754 - Load table failed due to 'Cannot be NULL' error.

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

SAP Sybase IQ 15.4

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.