DSXchange

Hi

Enterprise doesn't seem to use Oconv etc for Timestamp conversions. Would be grateful if anyone can give me any ideas regarding converting timestamps from DB2 source to Oracle Target. I can't get the transformer to compile at all if I try doing just a straight -through copy. Error says "Error in output column derivation expression for column RETURN_DT in link toOracleUpdates. Invalid conversion requested from a date to a timestamp."

Any suggestions?

First search the PX forum for Oconv, there is something that could help you.

You cant use OCONV in Parallel jobs.one way to do this is to do TimestampToString and then StringToTimestamp functions to migrate DB2 timestamp to Oracle Timestamp.

StringToTimestamp(TimestampToString(inputdate,%yyyy-%mm-%dd %hh:%nn:%ss),%yyyy-%mm-%dd %hh:%nn:%ss)

Check the format of timestamp in Both DB2 and oracle

If it's a timestamp, it should be able to copy straight through (perhaps with an adjustment to the fractional seconds).

[Oconv() does not work with timestamps even in server edition.]

ray.wurlod wrote:If it's a timestamp, it should be able to copy straight through (perhaps with an adjustment to the fractional seconds).

[Oconv() does not work with timestamps even in server edition.] ...

Hi Ray,

Thanks for this. It's able to copy straight through if I change the Target datatypes in the transformer to 'Date' instead of 'TimeStamp'. I am using DRS Stage as Source (DB2) and Oracle Stage as Target. Not sure what the issue is.

Thanks Again.

Hema

Oracle also doesn't have a specific TimeStamp data type. All Date data types are stored with time component.