search variable
Moderators: chulett, rschirm, roy
search variable
Hi,
any way to search a DataStage project to find all the jobs where a project variable is being used?
any way to search a DataStage project to find all the jobs where a project variable is being used?
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
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
;
Thanks for info.Where do I execute this?
DS_SUPPORT wrote:Kim Duke has posted this query very long backCode: 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 ;
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.
Or you can skip the LOGTO if you launch the session from the Project in question:
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.
Code: Select all
cd $DSHOME
. ./dsenv
./bin/dssh
LOGTO <YourProject>
Code: Select all
cd $DSHOME
. ./dsenv
cd <YourProject>
$DSHOME/bin/dssh
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote: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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
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.