Hi
While reading BIRTH_DATE field of format Date(4) "YYYY-MM-DD" from DB2 database table through DB2 enterprise stage in datastage , is showing a constant default value "1901-01-01" for all the rows at datastage level in spite of different correct date values seen at database level.
I tried increasing the length of field at stage level till 10 but then it was showing the same value.
Is the problem arising due to length or is this a different issue?
Reading Date from DB2 Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: