How to specify project in uvsh ?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
XRAY
Participant
Posts: 33
Joined: Mon Apr 03, 2006 12:09 am

How to specify project in uvsh ?

Post by XRAY »

I can specify the category of job with DS_JOBS.CATEGORY in uvsh. But how about project ? Is there any field that i can used to specify which project to select ?
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Re: How to specify project in uvsh ?

Post by samyamkrishna »

after uvsh do LOGTO PROJ_NAME
Then you can run the DS_JOBS.CATEGORY.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is a separate DS_JOBS table in each project. You can get the name of the project through the @ACCOUNT system variable. In an SQL statement you would need to encase this system variable in an EVAL expression.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply