DSXchange

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

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