DSXchange

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..........

Hi ,

What is the error message you are getting.

unable convert time to int32 error getting....

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 )

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.