Regarding Hashed file

vijaykumar · Post by **vijaykumar** » Sun Jan 28, 2007 11:01 pm

Hi,
In hashed file stage properties, there are two options, either by specifying the account name or by specifying directory path.
I was using directory path, instead of account name.what is meant by account name.I have seen my friend specifying UV account name.
I want to know what is meant by accountname.Inorder to specify account name is there any requirements .
plz Gurus help me.

cheers;
vijay

chulett · Post by **chulett** » Sun Jan 28, 2007 11:10 pm

Regarding that, I'm curious - you keep mentioning this 'friend' who does all these strange things, why not ask them?

Serious question, btw.

At it's most easy to digest level, account = project.

narasimha · Post by **narasimha** » Sun Jan 28, 2007 11:12 pm

If you select Account Name, don't enter anything, the hashed file gets created in the Project directory.

chulett · Post by **chulett** » Sun Jan 28, 2007 11:16 pm

Specifically, the current project the job is running under. Which means it follows along as you 'uplift' the job from dev to test, etc. Or specify a project to restrict it to that project regardless.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 29, 2007 12:43 am

Even more pedantically, the account name that you give must exist as an entry in a system table called UV.ACCOUNT.

This is a hangover from the days when DataStage was a UniVerse application; the UniVerse name for schema is "account". (That's a simplification, but will serve to explain the overlap in terminologies.)

Best practice, however, is to create hashed files for DataStage in one or more dedicated directories, and thereby to avoid cluttering up the account.

DSguru2B · Post by **DSguru2B** » Mon Jan 29, 2007 8:24 am

ray.wurlod wrote: Best practice, however, is to create hashed files for DataStage in one or more dedicated directories, and thereby to avoid cluttering up the account.

Very good piece of advice from Ray. Vijaykumar, you can pass the word onto your "friends".

mint_ag · Post by **mint_ag** » Wed Jan 31, 2007 12:05 am

I am putting Project name. Jon is getting complied successfully but while executing it says unable to open hash-file. Though I have saved the file in the project. Please advice.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 31, 2007 12:17 am

Have you ever CREATED the hashed file? Your job is quite clearly NOT completing successfully if you are getting this error.

narasimha · Post by **narasimha** » Wed Jan 31, 2007 12:22 am

If you read above, it says the best practice is to create hashed files for DataStage in one or more dedicated directories, to avoid cluttering up the account.

Also, you need to do a new post for your questions, this is called post hijacking.

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 8:17 am

I think Ray nipped the evil in the bed. The hashed file should be created prior to its read.