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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.