Universe database

[ray.wurlod]

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.

[XRAY]

export all your jobs into a folder and grep the whole folder for the thing you want.

[chulett]

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.

[DSguru2B]

The sql I am giving you has to be run in uv shell or in the adminstrator.

For category:

Code: Select all

SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE NAME = 'your jobname goes here';

For any string or table name or file name used in jobs, the following query will give you that (thanks kduke for it)

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 
; 

[joycerecacho]

Thanksssss my friend, however, when I tried to execute the second statement, there was a message which says: "Table DS_JOBOBJECTS" does not exist"

Is this name correct?

Thanks for your help ..... !!

[joycerecacho]

ps... I executed this statement directly at the uv prompt (LOGTO UV ).

[chulett]

You need to LOGTO an actual project, not UV.

[ray.wurlod]

This information is deliberately not documented by the vendor.

Your best chance is to search DSXchange.

[joycerecacho]

My colleague told me I can find all the files and commands from universe database by executing:
"SELECT * FROM VOC"

Yeap, it worked.

Tks guys!

Best Regards, have a nice week.