Hi EveryBody
Please help me fast.
My job is taking input from 30 hash files and output to 7sequential files and 2 hash files .these 2 hash files give output to 2 db2 stages.
My job is generating warnings while it loads into one of the last two files and the warning message is
ds_uvput() - Write failed for record id '<Missing or NULL>'
i don't understand what this is...
ds_uvput() - Write failed for record id '<Missing or NULL
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
ds_uvput() - Write failed for record id '<Missing or NULL
SURESH NARASIMHA
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Hey Thanks Very Much !!
Hey Thanks Very Much !!
Ur correct .The problem was with the NULL field .
I gave Not IsNull to eliminate that.
Anyhow thanks for ur response.
Suresh N
Ur correct .The problem was with the NULL field .
I gave Not IsNull to eliminate that.
Anyhow thanks for ur response.
Suresh N
SURESH NARASIMHA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A hashed file (note hashed, not hash) is a database table. Primary key values can not be null. Somehow your design seems to be trying to write a null key to a hashed file.
Why do you think you need hashed files between the rest of your design and the DB2 stages?
Why do you think you need hashed files between the rest of your design and the DB2 stages?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.