I am trying to populate date and time into DB2 table using DB2 load utility script.
The date coming from source is in the format of YYYY-MM-DD and the time in the form of hh:mm:ss
i am using the following utility script to perform the operation:
Expand|Select|Wrap|Line Numbers
- db2 LOAD CLIENT FROM <source filename> OF ASC modified by identitymissing dateformat="YYYY-MM-DD" timeformat="HH:MM:SS"
- striptblanks reclen=32 method L (1 12,13 13,14 24,24 32) messages <error msg filename>INSERT INTO Table Name(Col1,Col2,Col3,Col4,Col5)
SQL3192N In the filetmod a user specified format "DATEFORMAT" beginning with
the string "." is not valid.
Could you help me out with this.
Regards,
Shilpa Bhat