access hashed file through unix

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
mystuff
Premium Member
Premium Member
Posts: 200
Joined: Wed Apr 11, 2007 2:06 pm

access hashed file through unix

Post by mystuff »

Hi,
a) can we access (read field) from hashed file through unix
b) how do we do that.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

In general no. A hashed file is a database table. Your question is analogous to "can we access (read field) from Oracle table?".

You can invoke dssh to execute an appropriate query in that environment.

There is an operating system level command for reading the entirety of a single record from a hashed file, the name of the command is UVread. It displays the record in raw format, for example with dates in internal format, one field per line on stdout.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sammilan
Participant
Posts: 13
Joined: Fri Dec 29, 2006 12:13 am
Location: India

Post by sammilan »

If it is an absolute necessity, why dont you write the hash file to a sequential file and then try to read it using unix (vi editor) ?
Post Reply