SAP Knowledge Base Article - Preview

2421953 - Load table command failed to load the column with NULL value when the CONVERSION_ERROR is off

Symptom

  • When the option CONVERSION_ERROR is set to 'OFF', a load table command failed to set the column value to NULL.
  • The row with conversion error was not loaded in IQ server.
  • The load table command has IGNORE CONSTRAINT DATA VALUE to 0, Row Log, Message Log and "Only Log All" defined.
    Example:

Load table table_name(...) from '/data/sample.txt'
FORMAT ASCII
ESCAPES OFF
QUOTES OFF
DELIMITED BY '\x09'
IGNORE CONSTRAINT DATA VALUE 0
Message Log '/data/Message.log'
Row Log '/data/Row.log'
Only Log All
Log Delimited by '\x09'


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CONVERSION_ERROR IGNORE CONSTRAINT DATA VALUE   , 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 ONE Support launchpad (Login required).

Search for additional results

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