DSXchange

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.

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........

Thanks csrazdan.

I am familiar with querying the Administrator for the Job Category.
But I would like to display the Job Category in a Sequence EMail Notification message, rather than querying from Administrator.

No, there is no macro for that - you would need to query the repository. I've done that inline in a job using a UV stage lookup, it's not that difficult to setup.

Here DSJobName is a macro.

Really?

Huh... gonna have to look that puppy up.

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.

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.

Ray,

I tried to use this in a Job Sequence and i am getting a copilation error,
Variable 'Trans' not defined.

Thanks in Advance.

There must not be a space between the function name (Trans) and the following left parenthesis.