Page 1 of 1

project name as parameter

Posted: Tue Nov 22, 2011 6:30 pm
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

Posted: Tue Nov 22, 2011 7:04 pm
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.