How to access a Hashed file using UniVerse 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
MOHAMMAD.ISSAQ
Participant
Posts: 78
Joined: Fri Mar 02, 2007 4:54 am
Location: CHENNAI

How to access a Hashed file using UniVerse stage

Post by MOHAMMAD.ISSAQ »

I created a hashed file now i want it to access the hashed file using UniVerse stage.
I've used database name as "localuv" and the table name i've given as the Hashed file name.

But the error it throwing as "Table or View doen't exist"

Please provide some pointers to this...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you created the hashed file in a directory you will need to create a pointer to it, using the SETFILE command. Search the forum for details.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
baglasumit21
Participant
Posts: 132
Joined: Wed Mar 01, 2006 11:12 pm
Location: Pune

Re: How to access a Hashed file using UniVerse stage

Post by baglasumit21 »

MOHAMMAD.ISSAQ wrote:I created a hashed file now i want it to access the hashed file using UniVerse stage.
I've used database name as "localuv" and the table name i've given as the Hashed file name.

But the error it throwing as "Table or View doen't exist"

Please provide some pointers to this...
Hi MOHAMMAD,
The most basic thing but most of the time people forget it. Have you checked the box "Universal Stage Compatibility' while creating the hash file.
SMB
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That is rarely necessary. It only governs how dates and times are handled.
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