Regarding DSUtility

vijaykumar · Post by **vijaykumar** » Thu Jan 11, 2007 6:22 pm

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

kumar_s · Post by **kumar_s** » Thu Jan 11, 2007 6:28 pm

No. But you can get these information from the Report generated from GUI.

DSguru2B · Post by **DSguru2B** » Thu Jan 11, 2007 6:39 pm

Nothing out of the box. You have to code it.

vijaykumar · Post by **vijaykumar** » Thu Jan 11, 2007 6:49 pm

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

us1aslam1us · Post by **us1aslam1us** » Thu Jan 11, 2007 6:59 pm

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

vijaykumar · Post by **vijaykumar** » Thu Jan 11, 2007 7:07 pm

Hi Gurus,
This is my requirement, my teamlead wants t o know information from the operating system.

plz help me with this.

cheers;
vijay

narasimha · Post by **narasimha** » Thu Jan 11, 2007 7:36 pm

vijaykumar wrote:This is my requirement, my teamlead wants t o know information from the operating system.

You have a tough Team Lead

vijaykumar · Post by **vijaykumar** » Thu Jan 11, 2007 7:40 pm

Hi Gurus,
please help me out .

cheers;
vijay

us1aslam1us · Post by **us1aslam1us** » Thu Jan 11, 2007 7:45 pm

narasimha wrote: You have a tough Team Lead

DSguru2B · Post by **DSguru2B** » Thu Jan 11, 2007 7:51 pm

Why exactly do you want this, or your team lead wants this.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 11, 2007 8:46 pm

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.

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 12:28 am

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

narasimha · Post by **narasimha** » Fri Jan 12, 2007 12:36 am

You don't get such specific information w.r.t different stages in the job log.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 12, 2007 2:17 am

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

kduke · Post by **kduke** » Fri Jan 12, 2007 6:59 am

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.