using hashfile

avi21st · Post by **avi21st** » Tue Dec 19, 2006 2:38 pm

hi gurus,
how can i use hashfile.
i want to join 2 tables from my database.
i used odbc and hash file, when i edit hashfile it promptly asks for universe account name and directory, but my source data is in oracle.
how can i connect my hashfile to oracle.
can't we use hashfile directly to connect to oracle and retrieve data.

plz help me , how can i use my hashfile in joining 2 tables from oracle.
plz help me.

cheers;
abhi

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 2:55 pm

There is no such thing as a hashfile.

A hashed file is a database table in its own right.

A Hashed File stage can connect to a hashed file. It can not connect to anything else.

You connect an Oracle OCI stage or an ODBC stage to Oracle. If you need to populate a hashed file from Oracle, create a DataStage job to do so.

avi21st · Post by **avi21st** » Tue Dec 19, 2006 3:03 pm

hi gurus,
thanks very much.
how can i populate my table from odbc into hashfile.
what should i specify in odbc stage inorder to populate my data into hashfile, and then use hashedfile stage to access that data.
plz help me.

cheer;
abhi

I_Server_Whale · Post by **I_Server_Whale** » Tue Dec 19, 2006 3:24 pm

ray.wurlod wrote:There is no such thing as a hashfile.

As Ray said, it is called a hashed file.

Code: Select all



ODBC Stage------>HashedFile Stage

Usually, hashed files are created in a 'Directory path'. So choose the path where you want the hashed file to be. Declare the name of the hashed file.

There is no specific info to be specified in the ODBC stage inorder to load a hashed file from it. The regular DSN, Username, password and the right meta-data should be it.

Build your job and then get back if you have any more questions/errors.

Whale.

avi21st · Post by **avi21st** » Tue Dec 19, 2006 4:56 pm

hi gurus,
thanks very much.
odbc--->hashfilestage.
when i browse the hashedfile stage,iam specifying a path where to create the hashfile.
iam giving create file.
in update action iam giving- clear file before create.
but iam getting warning. due to which the data is not dumped from odbc to hashed file.plz help me.
hashfilecreation..Hashed_File_1.DSLink4: DSD.UVOpen mkdbfile: cannot create file C:\Ascential\DataStage\hashfile2\DSLink4

plz help me why am i getting this warning.

cheers;
abhi

kumar_s · Post by **kumar_s** » Tue Dec 19, 2006 5:04 pm

Check the permission for the directory C:\Ascential\DataStage\hashfile2, it can be readonly. Else give some other directory with proper file name.

narasimha · Post by **narasimha** » Tue Dec 19, 2006 5:11 pm

May be the hashed file is corrupted.
In the options while creating the hashed file, check on "delete file before create".

Or it could be a permission issue.

Get back if you these dont help

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 5:28 pm

The pathname that you give must be the pathname of an existing directory (folder). You must have permission to write into this directory.

In particular, you do not give the pathname of the hashed file on the Stage tab, only that of the parent directory in which the hashed file is to be created.

The name of the hashed file is given as a property on the Inputs tab.

avi21st · Post by **avi21st** » Tue Dec 19, 2006 5:41 pm

hi gurus,
tried various ways, but still getting warning.
This is what i specified the location of directory in my stage.
C:\HashFiles\Hash_File2

iam getting warning as
hashfilecreation..Hashed_File_1.DSLink4: DSD.UVOpen mkdbfile: cannot create file C:\HashFiles\hash\DSLink4.
plz help me.

cheers;
abhi

I_Server_Whale · Post by **I_Server_Whale** » Tue Dec 19, 2006 5:51 pm

avi21st wrote:DSD.UVOpen mkdbfile: cannot create file C:\HashFiles\hash\DSLink4.
plz help me.

cheers;
abhi

Do you have the

Code: Select all


C:\HashFiles\hash\

directory structure present on the DataStage Server Box?

For testing purposes, Try giving the directory path as

Code: Select all


C:\Temp

and name of the hashed file as

Code: Select all


My_First_Hashed_File

instead of DSLink4.

Whale.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 5:53 pm

LOOK at the error message!

What you say is not what you did, or the error message is not being generated from the Hashed File stage you have been tampering with.

You claim to have specified C:\HashFiles\Hash_File2 as the directory pathname.

Why, then is DataStage trying to create a hashed file called DSLink4 in a directory called C:\HashedFiles\hash ?

Please don't allow hashed file names to default to link names. It makes life so much more difficult for the poor sod who has to maintain your sloppy work.