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?
DB2 to Oracle Timestamp conversions
Moderators: chulett, rschirm, roy
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.]
[Oconv() does not work with timestamps even in server edition.]
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,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.] ...
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: