how to exit the loop in between 12 runs

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
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

how to exit the loop in between 12 runs

Post by pavankatra »

Hi,
i am taking count from the table,if count is '0' then i need to stop my process for 2hrs.But for every ten minits i have to check count=0 or greater than zero. i have created sequencer like this
job---->ec---->nc---->startloop---->wff----->job---->ec---->nc----->endloop

i have set the loop to run for 12 times.(1,1,12)


If count is 1 after ten minits then i want toexit from loop.
i don't know how to exit the loop in between 12 runs
please suggest me how to achieve this
Thanks in advance
Last edited by pavankatra on Wed May 04, 2011 4:27 pm, edited 1 time in total.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

At least two approaches suggest themselves.

1. Have another stream that bypasses the EndLoop activity. (This probably throws a warning "entered loop but did not exit".)

2. Set a flag that allows the in-loop activities to be bypassed if set.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

Post by pavankatra »

ray.wurlod wrote:At least two approaches suggest themselves.

1. Have another stream that bypasses the EndLoop activity. (This probably throws a warning "entered loop but did not exit".)

2. Set a flag that all ...
thanks ray.

i was tried with first one,but sequencer was aborted.
i am unable to see u r second solution,because i am not a premium member.
if u don't mind please let me know the second solution
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I have no idea whether U (one of our posters) minds or not.

Why not get yourself a premium membership? It's not expensive, at less than 30c (Rs12) per day, and definitely worth it. It also helps to keep DSXchange alive and running.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

Post by pavankatra »

ray.wurlod wrote:I have no idea whether U (one of our posters) minds or not.

Why not get yourself a premium membership? It's not expensive, at less than 30c (Rs12) per day, and definitely worth it. It also helps to keep DSXchange alive and running.
thanks ray

12 rs means i will join.please let me know the process
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

See information here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply