User status in parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Wed Jun 20, 2007 1:13 am
User status in parallel
Hi,
I'm converting a server job into parallel.
In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence. should i create a output routine
I'm converting a server job into parallel.
In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence. should i create a output routine
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Participant
- Posts: 33
- Joined: Wed Jun 20, 2007 1:13 am
In server edition, I designed a sequence to run two of the server jobs.
Ex:
Job1 and Job2
i'm getting the count of input records in job1 and using this
count in job2 through user status
In job2, i'm using the job parameter count,
count ==Job1.UserStatus
(in sequence we have the option Job1.UserStatus)
Ex:
Job1 and Job2
i'm getting the count of input records in job1 and using this
count in job2 through user status
In job2, i'm using the job parameter count,
count ==Job1.UserStatus
(in sequence we have the option Job1.UserStatus)
Re: User status in parallel
There is no parallel job sequence. Its same for both Server and Parallel Editions. You can call both server and parallel jobs from a Job sequence.saraswathi wrote:Hi,
I'm converting a server job into parallel.
In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence. should i create a output routine
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Hi Saraswati,
You need to pass the no.of records of a file into the job as a parameter.
So, in sequence use the Execute Command activity to count the no.of records in a file. And in the job activity of other job specify Execute Command activity. command_output to count parameter of that job.
Regards,
-- sudhakar
You need to pass the no.of records of a file into the job as a parameter.
So, in sequence use the Execute Command activity to count the no.of records in a file. And in the job activity of other job specify Execute Command activity. command_output to count parameter of that job.
Regards,
-- sudhakar
i need to know datastage
Re: User status in parallel
U can use User variable to capture the user status.saraswathi wrote:Hi,
I'm converting a server job into parallel.
In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence. should i create a output routine
Mahantesh Shivanagi
Basel-Developement team
Standard Chartered
Basel-Developement team
Standard Chartered
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't need to use a user variable. (Neither does U.)
The user status is available to any downstream activity in the job sequence as an activity variable from the (server) Job activity that set the value in the user status area.
The user status is available to any downstream activity in the job sequence as an activity variable from the (server) Job activity that set the value in the user status area.
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.