How to list the Job names under the category?
Moderators: chulett, rschirm, roy
How to list the Job names under the category?
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,
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,
Thanks with regards,
videsh.
videsh.
Most brain dead way:
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.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'YourCategory';
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT NAME FROM DS_JOBS WHERE CATEGORY = '<<Category name>>' AND NAME NOT LIKE '\\%';
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.
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Where does one execute this command? Thanks....ray.wurlod wrote:Code: Select all
SELECT NAME FROM DS_JOBS WHERE CATEGORY = '<<Category name>>' AND NAME NOT LIKE '\\%';
Attitude is everything....
It seemed to me worked. Yes also if you have filter like ray mentioned -
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?
Code: Select all
NAME NOT LIKE '\\%'
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?
Thanks with regards,
videsh.
videsh.
What do you mean by that? Do you mean the column name, thats just first two lines, you can delete the first two lines.videsh77 wrote:But I have seen the column information is getting wrapped. How to avoid this wrapping of column info?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA