Missing record from hash lookup

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
coolkhan08
Participant
Posts: 25
Joined: Wed Oct 13, 2004 1:11 am

Missing record from hash lookup

Post by coolkhan08 »

Hi,
I created a hash file and later look it up on a sequential file. I have a missing record. Its just missing 1 record in the lookup. What would be the reason. Any guesses???
Thanks
Sam
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

You failed to write it to the hash file because of a key definition violation.

Or

You wrote it to the hash file but your primary key definition allowed another row to overwrite it.

Or

You read it from a sequential file into the hash, and had First Row is Column Names checked, but the first row is actually your missing row.
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