Search found 25 matches

by Javieregh
Wed Mar 26, 2008 5:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

Thank for your comments..

I'm continuing my investigation..
by Javieregh
Tue Mar 25, 2008 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

My idea of using UtilityRunJob is evaluate if I can or not to Run the Master Sequence Job. I mean the next step is already a Job Activity. Do you have another idea that I can use?

Thank
Javier
by Javieregh
Tue Mar 25, 2008 8:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

Sorry, my specific problem is: The function UtilityRunJob doesn't understand my parameters, UtilityRunJob("Job", Var1 > 0, 0, DSJS.RUNFAILED) I want to verify the value of Var1 (this value comes from SQL's answer) , if Var1 > 0 I want to run the Job, if not I want to receive an error messa...
by Javieregh
Tue Mar 25, 2008 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

My process is: UserVariablesActivity--->NestedCondition---->JobActivity In UserVariables I have an SQL ( select A1 from A). The final result I move a (Var1) In NestedConditon I make one question: UtilityRunJob("Job", Var1> 0, 0, DSJS.RUNFAILED) In JobActivity (Master Execute Job/ Control J...
by Javieregh
Tue Mar 25, 2008 3:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

Re: UtilityRunJob

Thansk for your response But I read the document and continue my problem, this is the sentence: If usrEnvVariablesDataforMeasure.ValuePAT > 0 then UtilityRunJob UtilityRunJob('UT00003jControlJob.ControlJobFactAPORILearnerPAT','parameterjobhost=' :'Server':'|parameterjobUser=':'User':'|parameterjobpa...
by Javieregh
Tue Mar 25, 2008 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityRunJob
Replies: 10
Views: 6579

UtilityRunJob

Where I can to found information about the syntaxis for: UtilityRunJob?

Thanks a lot
Javier
by Javieregh
Sat Mar 15, 2008 6:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Activity Problem
Replies: 7
Views: 2098

Hi Craig I apply your sugestion and it work!!! Thank you so much 8) Javier Then you want one loop, not two. And since (AFAIK) you can't iterate through linked lists of variables, you'll need to build your single list with both pieces. For example, the List Loop: Monday|01,Tuesday|02 Then use the Fie...
by Javieregh
Sat Mar 15, 2008 11:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Activity Problem
Replies: 7
Views: 2098

Loop Activity Problem in more detail

Hello again, here is the structure that I want to do. A: Monday B: Monday 01 Activity Exit from B A: Tuesday B: Tuesday 02 Activity Exit from B I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once. Then execute Tuesday in A and go inside the ...
by Javieregh
Sat Mar 15, 2008 11:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Activity Problem
Replies: 7
Views: 2098

Loop Activity Problem in more detail

Hello again, here is the structure that I want to do. A: Monday B: Monday 01 Activity Exit from B A: Tuesday B: Tuesday 02 Activity Exit from B I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once. Then execute Tuesday in A and go inside the ...
by Javieregh
Sat Mar 15, 2008 2:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Activity Problem
Replies: 7
Views: 2098

Loop Activity Problem

I'm having trouble in looping with in the sequencer: My job design is StartLoopA---->JobActivityA----->StartLoopB----->JobActivityB---->EndloopB---->EndloopA My first loop (StarLoopA) contains Monday and Tuesday (list loop) and my second loop (StarLoopB) containing 01 and 02 (list loop), I need that...