Hi,
I want to move(stright move) Sybase data to Db2. Do i need to write SQL at Sybase stage (since sybase support 23 lenth of timestamp where as DB2 26) or shall i move directly, is datastage take care of padding with 0.
Thanks
Suri
move sybase timestamp data to db2
Moderators: chulett, rschirm, roy
Hi Suri,
Give it a shot - move it directly. If you get any problems then use the conversion functions TimestamptoString to convert it to String, pad the remaing characters with 0, convert it back to timestamp using StringtoTimeStamp and load the data.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
Give it a shot - move it directly. If you get any problems then use the conversion functions TimestamptoString to convert it to String, pad the remaing characters with 0, convert it back to timestamp using StringtoTimeStamp and load the data.
HTH
--Rich
Pride comes before a fall
Humility comes before honour