Selecting records from hash file that is stored in Directory

[Ravindar]

Hi all,

I am going to create a server routine of type "Transform Function" which is going to fetch records from a hash file which is stored in a Directory.

So,
I want to know,
What is the query to be issued in order to get records from a hash file(say X) which is stored in a directory(say D:\ravin\).

or

Any other method of doing this.

please comment on the possibility of such routine.

Note,
I know this can be done easily through Hash file stage in a server job.

[chucksmith]

You can create your hash file in a remote directory, but then, create a VOC pointer to the file. Having a VOC pointer, you can in subsequent jobs access the file as if it was created in the project. Now the selection tab is enabled in subsequent jobs.

[roy]

Hi,
the VOC entry is a must in order to invoke TCL/univers commands.
read OPENPATH and relevant commands in the basic.pdf file in your docs in the client installation directory.

IHTH,

[sumitgulati]

The command to create an entry in VOC file.

SETFILE <pathname_of_hashed_file> <hashed_file_name> OVERWRITE

Example:

SETFILE /usr/CUST CUST OVERWRITING

Hope this helps.

Regards
-Sumit

[Ravindar]

Thanks to all,
It is working fine now.