Join is returning a default date
Moderators: chulett, rschirm, roy
Join is returning a default date
DB2 table has a valid date, but the join is returning 1901/01/01.
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Re: Join is returning a default date
More Information is required to analyse this problem.RStone wrote:DB2 table has a valid date, but the join is returning 1901/01/01.
More inputs will results great output.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Re: Join is returning a default date
assuming you have design, like below
db2----|
seq----|join stage----seq file
1. now you have left outer join, with seq file on left and db2 on the right.
2. assuming db2 has two columns, 1st is a key column and 2nd is the date column.
3. now in db2 stage or join stage or o/p seq file stage you didnt define date column as nullable.
4. So after a unsuccessful join, a record is assigned a default date by db2 as your date column is not nullable . I am quite sure that your join is not working, though to you it looks.
db2----|
seq----|join stage----seq file
1. now you have left outer join, with seq file on left and db2 on the right.
2. assuming db2 has two columns, 1st is a key column and 2nd is the date column.
3. now in db2 stage or join stage or o/p seq file stage you didnt define date column as nullable.
4. So after a unsuccessful join, a record is assigned a default date by db2 as your date column is not nullable . I am quite sure that your join is not working, though to you it looks.
Shantanu Choudhary
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Re: Join is returning a default date
talk2shaanc wrote:assuming you have design, like below
db2----|
seq----|join stage----seq file
1. now you have left outer join, with seq file on left and db2 on the right.
2. assuming db2 has two columns, 1st is a key column and 2nd is the date column.
3. now in db2 stage or join stage or o/p seq file stage you didnt define date column as nullable.
4. So after a unsuccessful join, a record is assigned a default date by db2 as your date column is not nullable . I am quite sure that your join is not working, though to you it looks.
Here's a little more history:
It is a left outer with the DB2 stage on the right.
We were running this job(join) in Datastage on another lpar/server, and it worked fine. The date fields were returned properly.
Datastage was installed on another lpar/server, and we tried running the same job. All fields return in the join were ok except the date fields, and they came back as 1901/01/01.
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India