Paramètre entre job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

While various translation programs could probably do a (somewhat) decent job of it, best to stick with English here. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Post by FranklinE »

My French is sufficient to understand your request, but not to reply to you in French.

The simplest approach is to select the date into a user variable stage at the beginning of the job sequence. That variable then becomes available to every stage after.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
cdp
Premium Member
Premium Member
Posts: 113
Joined: Tue Dec 15, 2009 9:28 pm
Location: New Zealand

Post by cdp »

Salut Franck,

Where do you store the date you've retrieved from job 1 ?

Try the following (there are other approaches, but I find this one to be the easiest to get right)


- In job 1, write your date into a flat file, eg. param.txt

Now your Job sequence should look like this:
Job 1 ---> Execute Command Stage --> UserVariables Activity Stage--> Job 2 --> ... -->Job n
In the Execute Command Stage, if you are on Unix:

Code: Select all

cat [your_directory_path]/param.txt
In the UserVariables Activity Stage, go to 'User Variables' tab and:
- create and name your User Variable, for eg. UvMyDate
- In 'expression', click on the "..." button and select "Activity Variable"
- Then click on "$CommandOutput of your 'Execute Command Stage'

Once this is done, for the date parameter of your Job 2, ... , Job n, click on "..." and select "Activity Variable" ... And select the user variable you've created, eg. uVMyDate

Amuses toi bien :)
Post Reply