SAP Knowledge Base Article - Preview

1889341 - ROW LOG option of LOAD TABLE statement of SAP Sybase IQ does not work if IGNORE CONSTRAINT option is not used -- SAP IQ

Symptom

ROW LOG option of LOAD TABLE statement in SAP Sybase IQ does not work if IGNORE CONSTRAINT option is not used. The row runs into particular violations isn't logged into the file specified by ROW LOG option.
Here is the list of violations where ROW LOG does not log the corresponding row:

  • UNIQUE constraint violation (fixed in SAP Sybase IQ 15.4 ESD#2 and higher)
  • NULL constraint violation (fixed SAP Sybase IQ 16.0 and higher)
  • FOREIGN KEY constraint violation


Read more...

Environment

SAP Sybase IQ 15.2
SAP Sybase IQ 15.4
SAP Sybase IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

IQ, ROW LOG, NULL, UNIQUE, FOREIGN KEY, Constraint CR, 667221, 743408 , 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.