time to integer issue

vinsashi · Post by **vinsashi** » Mon Jun 27, 2011 2:24 am

Hi,
my db2 source contains one filed UPDATE_Z the datatype is 'time'
and reference data is teradata and on filed UPDATE_Z datatype is "integer ' but format is "99:99:99".we are doing lookup but job getting abort. and target is teradata and datatype is integer with fomrat "99:99:99.

Adance Thanks
v..........

samyamkrishna · Post by **samyamkrishna** » Mon Jun 27, 2011 2:40 am

Hi ,

What is the error message you are getting.

vinsashi · Post by **vinsashi** » Mon Jun 27, 2011 2:59 am

unable convert time to int32 error getting....

samyamkrishna · Post by **samyamkrishna** » Mon Jun 27, 2011 3:04 am

at the source do a time to string and at the target do the opposite(string to time).
It should work.

I had faced the same issue
Doing this has solved the issue.

Also can you post the table structure of the target table here.( the time columns )

chulett · Post by **chulett** » Mon Jun 27, 2011 7:23 am

Sorry but there's no such thing as an integer with a format. Once you add any kind of external format (like "99:99:99") then it becomes a string. As noted, compare them as such or remove the formatting and compare the integers.

DSXchange

time to integer issue

time to integer issue

Re: time to integer issue