DSGetLinkInfo

[Sainath.Srinivasan]

You can use DSSetUserStatus routine within your Basic function

[chulett]

I've done something similar by passing in the Job Name, Stage Name and Link Name as parameters to the routine and then passing the row count out as the Answer.

You would need to attach to the job, use that handle to get the link information and then detach from the job. This lets you use it in a Routine Activity stage in the Sequencer and then use $ReturnValue for the downstream parameter value.

[SonShe]

You can use DSSetUserStatus routine within your Basic function

Thanks for the help. It worked.

[SonShe]

You can use DSSetUserStatus routine within your Basic function

Hi Craig,

Thanks for the help. I used DSSetUserStatus and it worked. But I would like to know your approach as well. In a server routine I don't know how to return the rowcount as ans. I believe I have to write a transform routine to be able to do that. Please help me in my understanding. I have just started writing routines and learning a lot of stuffs with help from the DSXchange forum. Secondly, in the RoutineActivity stage how the returnvalue captures the rowcount value.

Thanks.

[chulett]

You can create a routine of the Transform Function type and then run it outside of your DataStage jobs via a Sequencer and the Routine Activity stage. It's a little more generic of a routine, would allow multiple input arguments and would look something like this:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

rJobHandle = DSAttachJob(JobName, DSJ.ERRNONE)

If NOT(rJobHandle) Then
   Ans = -99
End Else
   Ans = DSGetLinkInfo(rJobHandle, StageName, LinkName, DSJ.LINKROWCOUNT)
End

DetachResult = DSDetachJob(rJobHandle)

Bare bones, but it should give you the idea of what I'm talking about. JobName, StageName and LinkName are the three arguments and the row count is passed out as the answer. Negative answers indicate a problem and can be picked up by a custom trigger.

Drop a Routine Activity stage between your two Job Activity stages. Then the value of the row count parameter in the second job can be set to:

Code: Select all

RoutineStageName.$ReturnValue

Replace the 'RoutineStageName' part with whatever you actually call the stage in the job. Pass in the information from the upstream job as arguments to the routine and (if everything is ok) your row count gets passed to the second job.

[SonShe]

Thank you Craig. It is very clear to me now.

[ray.wurlod]

In a server routine I don't know how to return the rowcount as ans .

Be careful with casing. The name of the return variable is Ans, it is not ans.

Apart from assigning a value to Ans you do not need to do anything more; look at the bottom of the Routine editing page, and you will see that DataStage automatically includes RETURN(Ans) for you.

The value that you assign to Ans becomes the value returned by the function. It is vital that there is no code path through your Routine in which Ans is left in an unassigned state.