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.
Date Warning from DB2 Extract,Load to Cobol file (complex)
Moderators: chulett, rschirm, roy
What type is the column defined as in DB2? I wonder where you are doing the Julian date conversion.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I'm not sure if the "field 15" is conted starting at 1 or 0 - are both of those columns dates, and if so could you check the range? I still don't understand how or where the Julian Date figures into this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>