How to list the Job names under the category?

[videsh77]

Hi

For a given a category name I want to list the job names under that particular category. How we can achieve this task using universe shell?

regards,

[chulett]

Most brain dead way:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'YourCategory';

You'll get one extra record for the category itself, can't remember the magical syntax to exlude that from the list. I'm sure it will be along shortly.

[ray.wurlod]

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = '<<Category name>>' AND NAME NOT LIKE '\\%';

[chulett]

Doh! And here I thought you needed some of that goofy 'matches' syntax for this. That was too simple.

[just4geeks]

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = '<<Category name>>' AND NAME NOT LIKE '\\%';

Where does one execute this command? Thanks....

[DSguru2B]

In datastage administrator or from unix by going into uv command prompt and logging onto your project.

[videsh77]

Yes the command provided listing the jobs under any particular category. But if any other categories are under this category, it is not able to list the jobs under them.

How can we list the jobs recursively under categories for a provided category.

[videsh77]

We can get those by

select NAME from DS_JOBS where CATEGORY like '<Category Name>%'

[gateleys]

We can get those by

select NAME from DS_JOBS where CATEGORY like '<Category Name>%'

I don't think so.

[videsh77]

It seemed to me worked. Yes also if you have filter like ray mentioned -

Code: Select all

NAME NOT LIKE '\\%'

have it in query then, it eliminates some unwanted rows.

Now once I get this listing I am redirecting this to a file. But I have seen the column information is getting wrapped. How to avoid this wrapping of column info?

[DSguru2B]

But I have seen the column information is getting wrapped. How to avoid this wrapping of column info?

What do you mean by that? Do you mean the column name, thats just first two lines, you can delete the first two lines.

[DeepakCorning]

Even better -

Log on to the Datastage Manager .

Navigate to the category.

Select all the jobs underneath it.

DO Usage Analysis (its under tools).

When the window opens up , say View HTML.

:D

[us1aslam1us]

Will that display the job in the sub categories too.

[DeepakCorning]

Nope the datastage Manager one will not..it will show only the ones which u selected.

[us1aslam1us]

Neither does the other one.