job Category

[Lotus26]

Hi

May be a dumb question . But can anybody help me like Is there any way I can find the Category of a Datastage Job from Command line .

Thanks in advance.

[DSguru2B]

After logging into UV account or from your datastage adminstrator, you can run the following command, (change ABC to your job name)

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME = 'ABC';

[Lotus26]

Hi DSguru,

I appreciate your response . But I have one moew question like as a Administrator only I can get the Job Category name or is there any other way around??

Thank you.

[chulett]

Sorry, not really sure what you are asking.

[kumar_s]

You can run the same query in TCl prompt and get the result as well.

[ray.wurlod]

The query given by DSGuru2B can be run from the Administrator client Command window. Note that all the identifiers are upper case and the terminating ";" character is required. Job name is case sensitive.

[Lotus26]

Hi

I did used the query from the command line to know the category

/dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME,CATEGORY FROM DS_JOBS WHERE NAME='Coverage';"

in my unix script .But I am not getting any results . Will the results get stored somewhere else or am I missing something ?

I would appreciate your help.

[kcbland]

Please post the screen output

[Lotus26]

Hi

It is not resulting any output onto the Screen . When I issue the command it simply executing with out giving any error message and simply stops .


I would appreciate any help on this .

[kcbland]

Code: Select all

cd `cat /.dshome`
. ./dsenv
bin/dssh

The above lines gets you into the command line of the DS Engine. You then need to change to a project:

Code: Select all

LOGTO yourproject

Now you can type in your SQL command:

Code: Select all

SELECT NAME,CATEGORY FROM DS_JOBS WHERE NAME='Coverage';

Your existing unix command doesn't work because you have to be inside the physical project directory when invoking the $DSHOME/bin/dssh command.

[Lotus26]

Thanks Kenneth. I really appreciate your guidence and this one works .

Thanks again.

[ray.wurlod]

That suggests that you were not attached to the project directory when you executed the command that failed.