Setting up Account Name in Hash File 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
ririr
Participant
Posts: 84
Joined: Sun Apr 04, 2004 8:59 pm

Setting up Account Name in Hash File Stage

Post by ririr »

Hello -

I wanted to modify the hash file stages in some of our jobs to use the account name instead of directory path. What information do I need in order to handle the above situation.

Any help is appreciated!!

Thanks
Last edited by ririr on Mon Oct 18, 2004 12:24 pm, edited 1 time in total.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Leaving the field blank will default the job to creating/looking for the hash file in the project. By explicitly naming the account (project), you "lock" the hash file to that named project. Better to use a job parameter in this field. However, leaving it blank works the best since it doesn't care which project it is in.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Ken

I think they want to know an automated way to change all the jobs from path to account. Is that correct?
Mamu Kim
ririr
Participant
Posts: 84
Joined: Sun Apr 04, 2004 8:59 pm

Re: Setting up Account Name in Hash File Stage

Post by ririr »

ririr wrote:Hello -

I wanted to modify the hash file stages in some of our jobs to use the account name instead of directory path. What information do I need in order to handle the above situation.

Any help is appreciated!!

Thanks
You are correct kim.. This is a followup to my previous post

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The obvious method is to use the Designer client, and modify your jobs properly.

You will retort that you don't want to do that, you prefer automatic to manual.

In this case your only possibility is carefully to hack an export file.

In either case, as suggested, if you want to use an explicit account name, make it a job parameter. This insulates you against different account names existing in development, UAT and production environments.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

You could also hack the DS_JOBOBJECTS file. Of course this may violate your license agreement but how do you think we learned it.
Mamu Kim
Post Reply