Hi,
I need to load seq files in DB2 tables. My inserts work well except when i have Date and Timestamp formats. I receive a SQL error, saying it does not recognize the datetime format. It is surprising because I do not have trouble loading these formats normally. Do I need a special formatting for DataStage to recognize a Date and a Timestamp?
My formatting:
Date : yyyy-mm-dd
Timestamp : yyyy-mm-dd.hh.mm.ss.nnnnnn
The documentation for the plugin stage you are using to write to the DB2 database should specify the Timestamp format it is expecting. For example, OCI wants "YYYY-MM-DD HH24:MI:SS".