I am getting data in CSV File and the date format is mm/dd/yyyy,
in Sequential file i can't view the data
so i made the datatype as Varchar and now i can view the data ,and my output format must be like this YYYY-MM-DD
but when i run the job the job is getting Aborted.
The error message is
In Transformer i made asDB2Driver Embedded SQL message: SQL0180N The syntax of the string representation of a datetime value is
incorrect. SQLSTATE=22007
Code: Select all
StringToDate(DateToString(LkInto_TRNS_SeqGen.Date,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")