Date Warning from DB2 Extract,Load to Cobol file (complex)
Posted: Sun Mar 16, 2008 9:18 am
I have a db2 table of around 400+ columns and it has around 9 million rows. Extracting from this table doing some transformation and loading to a .cob file. After loading few million rows it gave me the following error and then job was aborted because i have routine that aborts if warning comes up.
Then i did query on Field 15 but there is no Date value that is later than 9999-12-31 or earlier than 0001-01-03 in the table.
Following is warning msg:
Warning:
db2Mytable,0: Invalid date value in setOutputFieldAsDate() for field '15' in output dataset '0'.
Date cannot be later than 9999-12-31 or earlier than 0001-01-03.
Julian days value = 1721424.
Then i did query on Field 15 but there is no Date value that is later than 9999-12-31 or earlier than 0001-01-03 in the table.
Following is warning msg:
Warning:
db2Mytable,0: Invalid date value in setOutputFieldAsDate() for field '15' in output dataset '0'.
Date cannot be later than 9999-12-31 or earlier than 0001-01-03.
Julian days value = 1721424.