UDB plug-in : DS doesnt know 24:00:00
Posted: Wed Jul 25, 2001 3:14 pm
Hi,
I use DataStage 4.1 and UDB V7.
When I use a UDB plug-in to read my data, I get the following warning:
TESTADSInitDetVehHistExtr.OSDS_DetHist: At row 2, link "Out_T_DetHist", while processing column "EVNT_ACTVY_ACTUAL_TM" Attempt to convert Long value "86400" to Time type unsuccessful
The value of the EVNT_ACTVY_ACTUAL_TM field (time field) in UDB is 24:00:00 . Ive run this job with 2,500,000 rows and only the rows with EVNT_ACTVY_ACTUAL_TM field = 24:00:00 gave this problem.
If I write the output to a file, the value of the rows with the previous mentioned warning, is the value of this field of the previous row!!!
It seems like the UDB plugin cant recognize midnight as 24:00:00.
How can I solve this? The time field should be correct, because its important for our processing.
Many thanks! Regards,
An
I use DataStage 4.1 and UDB V7.
When I use a UDB plug-in to read my data, I get the following warning:
TESTADSInitDetVehHistExtr.OSDS_DetHist: At row 2, link "Out_T_DetHist", while processing column "EVNT_ACTVY_ACTUAL_TM" Attempt to convert Long value "86400" to Time type unsuccessful
The value of the EVNT_ACTVY_ACTUAL_TM field (time field) in UDB is 24:00:00 . Ive run this job with 2,500,000 rows and only the rows with EVNT_ACTVY_ACTUAL_TM field = 24:00:00 gave this problem.
If I write the output to a file, the value of the rows with the previous mentioned warning, is the value of this field of the previous row!!!
It seems like the UDB plugin cant recognize midnight as 24:00:00.
How can I solve this? The time field should be correct, because its important for our processing.
Many thanks! Regards,
An