dynamically getting the values of parameters in Sequence

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
prashanto_dev
Participant
Posts: 27
Joined: Thu May 22, 2003 4:40 am
Location: California

dynamically getting the values of parameters in Sequence

Post by prashanto_dev »

I have a sequence in which I am using NOTIFICATION ACTIVITY.

I need to get the CURRENT PROJECT NAME and THE SEQUENCE NAME in the subjectline of notification activty stage without harding coding its value.
Pagadrai
Participant
Posts: 111
Joined: Fri Dec 31, 2004 1:16 am
Location: Chennai

Re: dynamically getting the values of parameters in Sequence

Post by Pagadrai »

prashanto_dev wrote:I need to get the CURRENT PROJECT NAME and THE SEQUENCE NAME .
Hi,
You can get the Project name using DSGetProjectInfo (InfoType)
InfoType specifies the information required and can be one of:
DSJ.JOBLIST
DSJ.PROJECTNAME
DSJ.HOSTNAME.

I guess Sequence Name is the job name from where the Notification is called. you can use DSJobName for that.

Use a User Variable stage to get the above values and use them for Notification.
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: dynamically getting the values of parameters in Sequence

Post by gateleys »

prashanto_dev wrote: I need to get the CURRENT PROJECT NAME and THE SEQUENCE NAME
In a User Variable stage, create 2 variables, say ProjName and SeqName. Then, assign the macros DSProjectName and DSJobName for the 2 variables, respectively.
gateleys
prashanto_dev
Participant
Posts: 27
Joined: Thu May 22, 2003 4:40 am
Location: California

Post by prashanto_dev »

Thanks. Its working.
Post Reply