DSXchange

narasimha wrote:Did an exact search found 75 matches for @RECORD.
You can find a nice explaination here

You found the right post. You need to work this post in conjunction with a list of all the parameters within a job. This could take a search for each parameter. Lot of work.

Plus it may/will seize to work in version 8.0. Maybe you need a different approach. Only if you were sitting on a unix box. This would have been much easier.

DSguru2B wrote:Only if you were sitting on a unix box. This would have been much easier.

How exactly?

Everything on DataStage on UNIX is available on DataStage on Windows.

I was indicating more towards the vast parsing capability of shell's and utilities like awk.

You may need to first list of parameters that been used. And you will need to loop through each parameter and find the list of jobs and stages using the query that Kim has used, instead of finding it for PROJDEF.

Hi Gurus,
I can list the no of parameters used by DS PARAMINFO PROJECTNAME JOBNAME from the operating system.
But this is from the operating system, how should i loop this command for each and every parameter.
please help me to proceed further.

cheers;
vijay

-lparam will give you a list of all the parameters. So paraminfo is what you want now? You are seriously confusing.
IF you want to do this at the OS level, create a dos batch job that reads from a list, loops through the dsjob -paraminfo command and passes the parameter read from the list one by one. Or do as Kumar advised above.

Hi Gurus,
what is the command that lists all the parameters in a job from administrator.Is there any administrative command.

cheers;
vijay

viewtopic.php?t=99047 should get you close.