SAP Knowledge Base Article - Preview

2129705 - Dependig on Data format, loading DATE() & DATEFORMAT() column followed by FILLER() makes next column to be NULL

Symptom

In loading when using 'Date' or 'Dateformat' option for a column, It needs to use fixed data format for 'Date' or 'Dateformat' column.
Based on data file format, following load command may insert NULL on column b.  Could you see 'Reproducing the issue' ?

    Load TABLE load_tb1 (  
      a DATETIME('YYYYMMDDhhnnss') NULL(blanks),
      filler(1),
      b ',')
    From '/home/ykim/tmp/dat1_variable'


Read more...

Environment

SAP IQ15.4 & IQ16 

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

DATEFORMAT, Change Format , KBA , BC-SYB-IQ , Sybase IQ , How To

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.