search variable

[lak4u]

Hi,

any way to search a DataStage project to find all the jobs where a project variable is being used?

[chulett]

Export it and then search the .dsx file.

[DS_SUPPORT]

Kim Duke has posted this query very long back

Code: Select all

SELECT 
   DS_JOBS.NAME AS JOB_NAME, 
   DS_JOBS.CATEGORY, 
   DS_JOBOBJECTS.NAME AS OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR SEARCH STRING',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
;

[lak4u]

Export it and then search the .dsx file.

Thank you Chulett

[lak4u]

Thanks for info.Where do I execute this?

Kim Duke has posted this query very long back

Code: Select all

SELECT 
   DS_JOBS.NAME AS JOB_NAME, 
   DS_JOBS.CATEGORY, 
   DS_JOBOBJECTS.NAME AS OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR SEARCH STRING',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
;

[chulett]

From the Administrator's command window or at a TCL prompt, making sure you are connected to the proper project. Use LOGTO if you are unsure.

Code: Select all

cd $DSHOME
. ./dsenv 
./bin/dssh
LOGTO <YourProject>

Or you can skip the LOGTO if you launch the session from the Project in question:

Code: Select all

cd $DSHOME
. ./dsenv 
cd <YourProject>
$DSHOME/bin/dssh

ps. If you ever start a session and it tells you the directory is 'not set up' for DataStage and asks if you want to do that - say NO. It means you are launching from the wrong place, it needs to be done from $DSHOME or a Project directory.

[lak4u]

From the Administrator's command window or at a TCL prompt, making sure you are connected to the proper project. Use LOGTO if you are unsure.

Code: Select all

cd $DSHOME
. ./dsenv 
./bin/dssh
LOGTO <You ...[/quote]

Thank you Chulett.Now I am able to do it from DS Admin Commend

[ray.wurlod]

The Administrator client Command window does not permit execution of a LOGTO command.

A number of other commands, such as HELP, are also blocked, perhaps because they require terminal handling characteristics, perhaps because they are dangerous (for example QUIT).