Can we replace hashed files using the UniVerse DB Stage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
Can we replace hashed files using the UniVerse DB Stage?
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?
Integrity is what you do when no one is watching
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.
There are lots of posts on this so search for them. Might give you some ideas.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.