Hi ,
I am getting 24:00:00 from a time field on DB2 ,and i have to insert the same value into a time field on DB2.
I am getting following error when trying to insert this value into DB2 table.
"TABLE1_Insert,0: Warning: At row 2, link "toxfmDefault", while processing column "TIME_UPDATE"
Attempt to convert Long value "86400" to Time type unsuccessful"
Insert 24:00:00 value into time field on DB2
Moderators: chulett, rschirm, roy
Re: Insert 24:00:00 value into time field on DB2
Please check your meta data at source whether the field meta data is time or not. if it is time at source then try to use convert functions.
Cheers
Ravi K
Ravi K
I think we've talked about this before... ah, here it is... it does seem to be a valid DB2 value but DataStage (and others) don't agree so you'll need to explicitly test for it and convert it to "00:00:00".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks Chulett,
I have gone thru the post what you have mentioned, there they have converted 24:0:00 to next day, but in may case as i am migrating a C# code where it is inserting 24:00:00,Client wants to do the same they dont want to convert it to next day.
Any idea of how to insert the same value...
I have gone thru the post what you have mentioned, there they have converted 24:0:00 to next day, but in may case as i am migrating a C# code where it is inserting 24:00:00,Client wants to do the same they dont want to convert it to next day.
Any idea of how to insert the same value...