DSXchange

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...

Looks like a key column into the Hashed file that should be not null is getting a NULL value.

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

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?