DSXchange

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

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.

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

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.

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.

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".

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.

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

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.

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