Coversion warnings

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
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

Coversion warnings

Post by Hope »

I have a date column in source.The data type is for this source date column is date.when I write it sequential target file whose datatype is also date.I get the following warning
APT_CombinedOperatorController: Conversion error calling conversion routine date_from_string data may have been lost
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Check the format of the source data as sometimes the time part will cause this problem. Also do check for null values too.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

How can you be so sure that the source is a Date field? If its from a text file then chances are its a string. Try doing a StringToDate() conversion on the field.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply