updating hash file

vinodhraj · Post by **vinodhraj** » Sun Oct 02, 2005 2:46 am

hi,

how to update a hash file?

thanks

vinod

ArndW · Post by **ArndW** » Sun Oct 02, 2005 3:50 am

Vinodhj,

in DataStage jobs when you output to a hashed file it is always done as an 'update'.

chulett · Post by **chulett** » Sun Oct 02, 2005 7:53 am

In other words - just write to it.

Hashed files are "destructive overwrite", meaning that when multiple records are written with the same key into the hashed file, each completely replaces the previous version. Therefore, last one in wins.

That should also lead you to understand that there is no way to update individual fields - you must replace the entire record.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 02, 2005 4:52 pm

Unless, of course, you use a UniVerse stage!

chulett · Post by **chulett** » Sun Oct 02, 2005 7:43 pm

Well... of course!