Can we replace hashed files using the UniVerse DB Stage?

[vinodlakshmanan]

This might sound silly, but I got the idea whether we can use the UniVerse of DataStage to replace hash files with UV tables that are stored in the UniVerse repository of DataStage. If yes, would there be any advantage of doing so?

[kduke]

Yes. Hash files can be built with hash file stages and then accessed with UV stages. The difference is UV stages use SQL to select and update where hash file stages read and write in a more native method. Hash file stages should be faster. You can do things like multiple row lookups only with UV stages and only if the hash file keys are setup properly.

There are lots of posts on this so search for them. Might give you some ideas.

[ray.wurlod]

UV tables are hashed files. The only difference is that, if you create them as UV tables, then entries are written into the system tables (SQL Catalog), and they can't be deleted with DELETE.FILE (you must use DROP TABLE).