TimeStamp Null handling

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
highpoint
Premium Member
Premium Member
Posts: 123
Joined: Sat Jun 19, 2010 12:01 am
Location: Chicago

TimeStamp Null handling

Post by highpoint »

I have source column as "TimeStamp". I was getting warning
as :

APT_CombinedOperatorController(1),0: Field 'Col1' from input dataset '0' is NULL. Record dropped.


by going through forumn tried using NullToEmpty and StringtoTimestamp function,

Now getting following Warning:

Conversion error calling conversion routine timestamp_from_string data may have been lost.


Appreciate help in resolving this.
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

StringtoTimestamp expects a timestamp string and not an empty string. Use NullToValue or if you want nulls to be passed then dont use StringtoTimestamp on Nulls
You are the creator of your destiny - Swami Vivekananda
Post Reply