DSXchange

Hi !
When a job writes record in a Hash File Stage.
What appends when a record has the same key than a record already stored in the hash file :
- is the old record replaced by the new one ?
- or is the first record which was already in the hash fiel kept and the new one ignored ?
Thanks for your reply.

Last one in wins. [:)]

-craig

Depends how you access it.

If you write via a hashed file stage, the entire record is replaced.
If you write via a UV stage, you can choose the update strategy (the usual techniques; insert, update, insert before update, update before insert, and so on).
If you use the DataStage BASIC Write statement the record is over-written, but you may in your routine have pre-read the record and only modified certain fields.


Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Good to know, thanks for the clarification!

-craig