Hashfile Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
martin
Participant
Posts: 67
Joined: Fri Jul 30, 2004 7:19 am
Location: NewJersy

Hashfile Error

Post by martin »

Hi,

I have a simple job creating Lookup file. I was able to create and run sucessfully but for some reason its giving error

LdSampleDimPTLnPML..Ha_SampleDim.lk_SampleDim: ds_uvput() - Write failed for record id '<Missing or NULL>'

Any Clue what does this means.

Thanks
Martin
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Pretty much what it says - a NULL value in the key field.
-craig

"You can never have too many knives" -- Logan Nine Fingers
martin
Participant
Posts: 67
Joined: Fri Jul 30, 2004 7:19 am
Location: NewJersy

Post by martin »

Thanks........Chulett, you are correct, I was under ipmression we dont have NULL values.

Now its fine with Not(IsNull(lkSmpDescs.smpid))

Martin
Post Reply