ds_uvput() - Write failed for record id '<Missing or NULL

suresh.narasimha · Post by **suresh.narasimha** » Wed Jan 18, 2006 3:00 am

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

loveojha2 · Post by **loveojha2** » Wed Jan 18, 2006 3:19 am

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

suresh.narasimha · Post by **suresh.narasimha** » Wed Jan 18, 2006 3:39 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 3:40 am

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?