Timestamp Null Issue in Migration

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sarathchandrakt
Participant
Posts: 50
Joined: Fri Aug 29, 2014 1:32 pm
Location: Mumbai

Timestamp Null Issue in Migration

Post by sarathchandrakt »

I am Migrating Data from DB2 to Oracle.

I am stuck on the timestamp column. If the colum values are null it is being transformed to '*******************' !! I have tried IsNull in the transformation but it does not work. I MUST accept a null value (not a hypothetical date such as 01-01-0001). If I accept the hypothetical value it works but that will break logics in many application where we check for null.

Please let me know what should be done.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the column nullable in Oracle, and is it marked everywhere in your job as Nullable = Yes ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sarathchandrakt
Participant
Posts: 50
Joined: Fri Aug 29, 2014 1:32 pm
Location: Mumbai

Post by sarathchandrakt »

Yes... I did...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Why don't you share with us the details of your job design specific to this field - stages, datatypes, transformations, etc - then perhaps we can spot where things are going wrong.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sarathchandrakt
Participant
Posts: 50
Joined: Fri Aug 29, 2014 1:32 pm
Location: Mumbai

Post by sarathchandrakt »

Looks like issue was with Data. This is resolved now. Thank you anyways.
Post Reply