Hi I want to know the use of DSSetUserStatus function. Is it talking abt the status of job like -> abort, running, success or is it something else.
In my job it is used as a Transform, that means we are calling it for every record in the table. How does it reads the status of records??
SETUSERSTATUS(lnk_SDN_PRGM_CNTRL.FILTER_CLAUSE)
Call DSSetUserStatus(Arg1)
Ans = @NULL
RETURN (ANS)
Plz explain
DSSetUserStatus function use??
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're completely on the wrong track.
Each job has a "user status area" into which the DSSetUserStatus() function can put a value.
That value can subsequently retrieved, even after the job has finished, either through a Job activity's $UserStatus activity variable, or by calling the DSGetJobInfo() function from the DataStage API.
The user status area is completely unrelated to the execution status of jobs, stages or links.
Each job has a "user status area" into which the DSSetUserStatus() function can put a value.
That value can subsequently retrieved, even after the job has finished, either through a Job activity's $UserStatus activity variable, or by calling the DSGetJobInfo() function from the DataStage API.
The user status area is completely unrelated to the execution status of jobs, stages or links.
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.