Page 1 of 3

Regarding DSUtility

Posted: Thu Jan 11, 2007 6:22 pm
by vijaykumar
Hi Gurus,

As this is concerned with different utility iam starting new post, kindly help me.

As my parameters are used by different stages.

How can i know which stage uses particular parameter.i want this to know from my operating system, i mean is there any DSutility which helps me.

kindly can Gurus post that.

cheers;
vijay

Posted: Thu Jan 11, 2007 6:28 pm
by kumar_s
No. But you can get these information from the Report generated from GUI.

Posted: Thu Jan 11, 2007 6:39 pm
by DSguru2B
Nothing out of the box. You have to code it.

Posted: Thu Jan 11, 2007 6:49 pm
by vijaykumar
Hi Gurus,
Plz gurus help me out with the code.
Can anyone post the code which retrives the information which stage uses particular parameter.

plz Gurus help me out.

cheers;
vijay

Posted: Thu Jan 11, 2007 6:59 pm
by us1aslam1us
Why do you want to do that using utility, you can just generate report from the designer which will give you a detail report about each stage.The option will be available on the designer toolbar (Internet explorer symbol).

Posted: Thu Jan 11, 2007 7:07 pm
by vijaykumar
Hi Gurus,
This is my requirement, my teamlead wants t o know information from the operating system.

plz help me with this.

cheers;
vijay

Posted: Thu Jan 11, 2007 7:36 pm
by narasimha
vijaykumar wrote:This is my requirement, my teamlead wants t o know information from the operating system.
You have a tough Team Lead :!:

Posted: Thu Jan 11, 2007 7:40 pm
by vijaykumar
Hi Gurus,
please help me out .

cheers;
vijay

Posted: Thu Jan 11, 2007 7:45 pm
by us1aslam1us
narasimha wrote: You have a tough Team Lead :!:
:lol:

Posted: Thu Jan 11, 2007 7:51 pm
by DSguru2B
Why exactly do you want this, or your team lead wants this.

Posted: Thu Jan 11, 2007 8:46 pm
by ray.wurlod
:x I have already given you this solution.

Use dsjob to read the first event from the job run from the job log. This contains all of the parameter values with which the job was started.

Posted: Fri Jan 12, 2007 12:28 am
by vijaykumar
Hi Gurus,
I got all the parameter values with which the job started.

For ex: I have defined 5 parameters in my job.
But iam making use of 3 parameters in Source stage while the transformer stage uses 1 and the target uses 3 parameters.
i want to list the parameters used by particular stage rather than to list the parameters in the entire job.

plz help me.
cheers;
vijay

Posted: Fri Jan 12, 2007 12:36 am
by narasimha
You don't get such specific information w.r.t different stages in the job log.

Posted: Fri Jan 12, 2007 2:17 am
by ray.wurlod
Now you DO have to write some code. You can write DataStage BASIC code, or you can write C code. The latter is harder to write but easier to call from the command line. The DataStage C API is documented in the Server Job Developer's Guide

Posted: Fri Jan 12, 2007 6:59 am
by kduke
I posted some code which would search @RECORD for any value. I think it would be easy to modify this code to get what you want. It does return the link name. It had either upcase or downcase in the code. If you cannot find it let me know.