Universe database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's a huge topic, one that could not easily be answered in a single reply. Why not Search DSXchange for examples? For instance, a search on CATEGORY will turn up answers to your second question.
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.
I've used Chuck Smith's tools for this in the past, modifying some to store their output in a database table so it can be checked with simply queries.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The sql I am giving you has to be run in uv shell or in the adminstrator.
For category:
For any string or table name or file name used in jobs, the following query will give you that (thanks kduke for it)
For category:
Code: Select all
SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE NAME = 'your jobname goes here';
Code: Select all
SELECT
DISTINCT DS_JOBS.NAME AS JOB_NAME FMT '100L',
DS_JOBS.CATEGORY FMT '100L',
DS_JOBOBJECTS.NAME AS OBJECT_NAME FMT '100L',
DS_JOBOBJECTS.OLETYPE FMT '100L',
EVAL DS_JOBOBJECTS."if index((@RECORD),'your string goes here',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM
DS_JOBS,
DS_JOBOBJECTS
WHERE
DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
and FOUND = 'FOUND'
GROUP BY
JOB_NAME,
DS_JOBS.CATEGORY,
OBJECT_NAME,
DS_JOBOBJECTS.OLETYPE,
FOUND
;
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm