Get Job Category
Moderators: chulett, rschirm, roy
Get Job Category
Is there any DSMacro or System Variable to get the Job Category?
For getting the JobName we have DSJobName, iam looking for a similar thing for getting the Job Category.
Thanks in Advance.
For getting the JobName we have DSJobName, iam looking for a similar thing for getting the Job Category.
Thanks in Advance.
You can get job category by running following command either on DataStage Administrator GUI or UV command:
LIST DS_JOBS WITH NAME <Your job name>
This command will display Job name, Job Number and Job Category. If Category is NULL it would mean job is available at under /Jobs folder
I don't think DataStage has a Macro or system variable for display category of a job.
Hope it helps........
LIST DS_JOBS WITH NAME <Your job name>
This command will display Job name, Job Number and Job Category. If Category is NULL it would mean job is available at under /Jobs folder
I don't think DataStage has a Macro or system variable for display category of a job.
Hope it helps........
Assume everything I say or do is positive
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Trans("DS_JOBS", DSJobName, 3, "X")
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
Note: This function (Trans()) is available in job sequence expression derivations, not in parallel job expressions. The OP specified job sequence.
The function is documented in the DataStage BASIC manual. It does the same job as UtilityHashLookup() but far more efficiently.
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.
Ray,ray.wurlod wrote::!:
Note: This function (Trans()) is available in job sequence expression derivations, not in parallel job expressions. The OP specified job sequence.
The function is documented in the DataStage BASIC manual. It does the same job as UtilityHashLookup() but far more efficiently.
I tried to use this in a Job Sequence and i am getting a copilation error,
Variable 'Trans' not defined.
Thanks in Advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: