project name as parameter

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
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

project name as parameter

Post by ketfos »

How do I pass the name of the project as parameter?

I ahve before job routine where I am calling a Unix script.

e.g /ddata/wstestproj/a.sql

wstestproj is the name of the project.
I do not want to use absolute name, else script will fail when I promote to another project.

Thanks
Ketfos
ketfos
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I believe there is a DS Macro for project, but I've had trouble getting macros to work before. What I've done in the past is to create a Project parameter/environment variable in Administrator in every DataStage project as part of standard project setup. You can set it one time per project and be done with it. Then you can pass it from master sequence jobs to all called jobs and from there pass it to scripts, etc.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply