userstatus

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

How exactly are you setting USERSTATUS in the first job? FYI, you don't need that UserVariables stage, the Sequence can pass what you need directly.
-craig

"You can never have too many knives" -- Logan Nine Fingers
India2000
Participant
Posts: 274
Joined: Sun Aug 22, 2010 11:07 am

Post by India2000 »

chulett wrote:How exactly are you setting USERSTATUS in the first job? FYI, you don't need that UserVariables stage, the Sequence can pass what you need directly. ...
Do you mean in expression type userstatus? Its =job1.$userstatus
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No, that's how you pass it from Job1 to Job2 in the Sequence. I want to know what you are doing inside Job1 to set it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
India2000
Participant
Posts: 274
Joined: Sun Aug 22, 2010 11:07 am

Post by India2000 »

chulett wrote:No, that's how you pass it from Job1 to Job2 in the Sequence. I want to know what you are doing inside Job1 to set it. ...
.
Last edited by India2000 on Thu Sep 23, 2010 1:51 pm, edited 1 time in total.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please start a new post when you have new questions or issues.
-craig

"You can never have too many knives" -- Logan Nine Fingers
India2000
Participant
Posts: 274
Joined: Sun Aug 22, 2010 11:07 am

Post by India2000 »

chulett wrote:No, that's how you pass it from Job1 to Job2 in the Sequence. I want to know what you are doing inside Job1 to set it. ...
I have a routine call DSuserstatus( Arg1)
Ans=Arg1 that returns the value of the first job. then I assign that value to the uservariable in the useractivity as Job1.$Userstastus and pass it to the job2 as a job parameter
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

India2000 wrote:I have a routine call DSuserstatus( Arg1)
I doubt it. There's no such routine.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
arunpramanik
Participant
Posts: 63
Joined: Fri Jun 22, 2007 7:27 am
Location: Kolkata

Post by arunpramanik »

India2000 wrote: I have a routine call DSuserstatus( Arg1)
Ans=Arg1 that returns the value of the first job. then I assign that value to the uservariable in the useractivity as Job1.$Userstastus and pass it to the job2 as a job parameter
Is this DSuserstatus( Arg1) a user defined routine? As mention by Ray there is no such in-bulit routine.

The easiest approach is -
Create a user define routine with a name something like "userstatus"
This routine should have Call DSSetUserStatus(Arg1)

Use/call this new user defined routine in the stage variable in the Job1
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

:idea:
Tip: avoid naming your routines with names beginning with "DS".

Let this prefix be used only for out-of-the-box routines.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sohasaid
Premium Member
Premium Member
Posts: 115
Joined: Tue May 20, 2008 3:02 am
Location: Cairo, Egypt

Post by sohasaid »

I think this post might help:

http://dsxchange.com/viewtopic.php?t=13 ... a1d2cf1cd5

Regards.
Post Reply