DSXchange

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.

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.

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,

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

Thanks to all,
It is working fine now.