How can I set DSUserStatus in a PX job?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 27
- Joined: Wed May 21, 2008 7:57 am
How can I set DSUserStatus in a PX job?
How can I set the DSUserStatus in a PX job then reference it in a sequence 'Nested Condition' stage?
Robert Stemphowski
Senior DataStage Consultant
Senior DataStage Consultant
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Re: How can I set DSUserStatus in a PX job?
rstemphowski
You should set the User Status inside the job ( Is the same for server and parallel jobs).
You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job
Each time the job is execute the User Status value will be refreshed
You should set the User Status inside the job ( Is the same for server and parallel jobs).
You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job
Each time the job is execute the User Status value will be refreshed
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Re: How can I set DSUserStatus in a PX job?
rstemphowski
You should set the User Status inside the job ( Is the same for server and parallel jobs).
You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job
Each time the job is execute the User Status value will be refreshed
You should set the User Status inside the job ( Is the same for server and parallel jobs).
You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job
Each time the job is execute the User Status value will be refreshed
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There does not appear to be a C-callable function (or a C++ class) equivalent to DSSetUserStatus().
Before-job and after-job subroutines for parallel jobs are still written in DataStage BASIC, so you have the opportuity there to call DSSetUserStatus() directly. If, as I suspect you do, you wish to capture some value from the data flow, you need to store that somewhere (a file perhaps) and access the value from the file, either in an after-job subroutine or in an Execute Command actvity.
A recent DSXchange Learning Center webinar on files and DataStag job sequences dealt, in part, with reading files using job sequence techniques. DSXchange portal is the place to find webinars. If it's not there, contact editor@dsxchange.com to see how you can get a copy.
Before-job and after-job subroutines for parallel jobs are still written in DataStage BASIC, so you have the opportuity there to call DSSetUserStatus() directly. If, as I suspect you do, you wish to capture some value from the data flow, you need to store that somewhere (a file perhaps) and access the value from the file, either in an after-job subroutine or in an Execute Command actvity.
A recent DSXchange Learning Center webinar on files and DataStag job sequences dealt, in part, with reading files using job sequence techniques. DSXchange portal is the place to find webinars. If it's not there, contact editor@dsxchange.com to see how you can get a copy.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.