Can i write to a hashed file from multiple links

dhiraj · Post by **dhiraj** » Fri Apr 16, 2004 2:15 am

Hi,

Can i write to same hashed file from more then one stage in a job.I want to recreate the file for each run.

I tried doing this and this worked.

But i wanted to know if it is safe doing this.

thanks
dhiraj

ray.wurlod · Post by **ray.wurlod** » Fri Apr 16, 2004 3:16 am

ALL writes to a hashed file are destructive overwrites, whether from one source or many. If the key being written already exists on the hashed file, then that row is replaced entirely with the columns of the new row.

If this is what you want to happen then, yes, it is "safe".

A hashed file behaves like a table, but only with record-level locking (table-level locking is available, but not through the Hashed File stage).

Indeed, if you desire some other behaviour, you may prefer to access the hashed file using a UV stage, where all of the characteristics of SQL (DML) are at your disposal.