Hello,
Based on UtilityHashLookup I build a routine, but when I test the routine it fails to open the hashfile. I think I did not state the name and path of the hashfile correctly, but I do not know what I am doing wrong.
I know that the pathname of the hashfile that I need is "c:\hash" and the name of the hashfile is "TestHash". I passed the parameter as "c:\hash\TestHash" with the result I mentioned above.
When I look with windows explorer in that path I find a folder with the same name as the hashfile containing 3 .30-files. I do not know if that is the hashfile, but the hashfile seems to be in that place.
Can someone tell me how I state the name and path of the hashfile correctly in this routine?
Thanks in advance.
Hashfile-name
Moderators: chulett, rschirm, roy
Hashfile-name
Kind regards,
Johannes Drost
Johannes Drost
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You basically have two choices.
One is to use OPENPATH to open the pathname. This sounds like what you need.
The other is to use SETFILE (a command, not a DataStage BASIC statement) to create a VOC pointer to the hashed file, then use OPEN to open it.
One is to use OPENPATH to open the pathname. This sounds like what you need.
The other is to use SETFILE (a command, not a DataStage BASIC statement) to create a VOC pointer to the hashed file, then use OPEN to open it.
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.