hash errors

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
kool_cons
Participant
Posts: 68
Joined: Thu Jul 07, 2005 3:41 pm

hash errors

Post by kool_cons »

Hai guys,
when i tried to look up with hash stage,i was getting some warnings like "Hashed_File_33.DSLink27: ds_uvput() - Write failed for record id '<Missing or NULL>'" though it ran. i dont know what could be the problem for this one. Can you help me guys.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

The messages are from when you were writing to the hash file. They mean you wrote a row with a null primary key, which appropriately is rejected. To suppress this problem, use a constraint on that link to only write if the primary column value is not null. If null data shouldn't be happening, then fix the problem elsewhere.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply