Select on hash file with UV stage

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
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Select on hash file with UV stage

Post by snassimr »

Hi !

I need help . I try to connect to hash file with UV stage And dont succeed

Wich stage exactly I need use (Universe ,Unidata,Unidata 6)

why i see connection name if i need to connect to file ?

May be there is some posting ? I need somthing for details steps
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Try to connect to a hash file using ODBC and use "localuv" with no user-id or password.
Sunshine2323
Charter Member
Charter Member
Posts: 130
Joined: Mon Sep 06, 2004 3:05 am
Location: Dubai,UAE

Post by Sunshine2323 »

Hi snassimr,

You can use the Universe Stage for viewing the Hash File
On the Stage Tab for the Datasource name fill localuv (which you will get by default) leave the username and password blank
In Table Names fill in the name of the Hash File

The Hash file needs to be created under the account or if created in the directory then you need to create a VOC pointer for the same.

Load in the metadata for the hash file in the columns tab and you will be able to view the data.

Hope this helps :)
Warm Regards,
Amruta Bandekar

<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Search the forum for SETFILE to learn how to set a VOC pointer to a hashed file created in a directory, or you can use one of Chuck's tools from his website.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply