DSXchange

Posted: **Wed Jun 08, 2011 4:39 pm**

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.

Posted: **Thu Jun 16, 2011 6:22 am**

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

Posted: **Thu Jun 16, 2011 6:39 am**

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.

Posted: **Mon Jun 20, 2011 3:11 pm**

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 
;

Posted: **Tue Jun 21, 2011 8:01 am**

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 ..... !!

Posted: **Tue Jun 21, 2011 8:03 am**

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

Posted: **Tue Jun 21, 2011 8:05 am**

You need to LOGTO an actual project, not UV.

Posted: **Tue Jun 21, 2011 4:21 pm**

This information is deliberately not documented by the vendor.

Your best chance is to search DSXchange.

Posted: **Wed Jun 22, 2011 6:16 am**

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.

DSXchange

Universe database