Adding 1 day to date < 1970-01-01

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
tiozzo
Charter Member
Charter Member
Posts: 38
Joined: Fri Sep 01, 2006 3:07 pm

Adding 1 day to date < 1970-01-01

Post by tiozzo »

Hi all, i have encountered a problem where i'm extracting a birthdate from the db2 mainframe to UDB and datastage is adding 1 day to the date

I also wrote directly from aminframe db2 to a PEEK stage with the same result

I know the Unix start date is 1970-01-01. has anyone else run into this problem?
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

How are you connection to DB2 mainframe? Or you are getting a flat file from the mainframe? If you are going directly to mainframe, try specifying a TO_CHAR for the date in the sql select and read it as varchar instead of date.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”