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?
Adding 1 day to date < 1970-01-01
Moderators: chulett, rschirm, roy
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.