Passing User Status back to parent seq'er for restartability

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
moose2079
Premium Member
Premium Member
Posts: 48
Joined: Tue Mar 07, 2006 4:52 pm
Location: Australia

Passing User Status back to parent seq'er for restartability

Post by moose2079 »

Hi there,
My team has setup restartability thru seq'ers running jobs but have hit a problem ... the initial job in the master control seq'er creates the Batch_id for subsequent seq'ers - we passed down the batch_id as the user status from the create batch job - we had problems with create batch as it was a job within the master control seq'er and therefore was not restartable if it failed - we were then forced to set the created bactch_id as complete so it would create a new Batch_ID .... to make it truely restartable we have set the create batch_id job to be run by a seq'er which in turn is run by tghe master control seq'er .... all to achieve restartablity ... but how do we pass the user status from the create batch_id job back up thru the parent seq'er to the master control seq'er

Please advise

:-)
YUM
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Wow... confusing and basically one long sentence. And I'm pretty much lost in your maze of "seq'er"s. There's no "r" in "Sequence".

UserStatus can be passed downstream but not upstream. Sounds like you'll need to find another mechanism, perhaps by writing the batch id to a flat file and then using a Routine Activity stage to pick it up? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply