DSXchange

Hi Gurus, Hi Gurus, From the administrator, iam giving the command 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), 'PROJDEF' , 1)>0 THEN 'FOUND' ELSE ' ' '' AS FOUND FMT '5L' FROM DS_JOBS,DS...

Hi Gurus,
Sorry, indeed you are helping me a lot.

cheers;
vijay

Hi Gurus,

Can anyone post the code from datastage administrator or from the operating system that gives the list of parameters used by particular stage.
plz help me Gurus.

cheers;
vijay

Hi Gurus,
I didn't find any code, i tried to search with keyword @RECORD , i didn't get the link. Can Gurus help me with the link.

Please help me Gurus.

cheers;
vijay

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

Hi Gurus,
please help me out .

cheers;
vijay

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

plz help me with this.

cheers;
vijay

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

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

Hi Gurus,

Thanks very much.

The command works, but iam getting error

i used c:\ascential\datastage\projects\salma10 dsjob -lparams salma10 job1.

Iam getting error.
Failed to open job.
status code= -1004.

please help me Gurus.

cheers;
vijay

Hi Gurus, I went to the path where these projects are found. In the command path i went to c:\ascential\datastage\projects\salma10. and i gave the command dsjob -1params salma10 job1 iam getting error. INVALID/UNKNOWN PRIMARY COMMAND SWITCH. dsjob [-file <file> <server> | [-server <server>][-user <u...

Hi Gurus, I don't know the operating system to get the job id. I used the command DSJOB -1params [useid] salma10 job1 Iam getting error status code=-9999 DSJE_DSJOB_ERROR. why am i getting this error, its because i didn't use the jobid. My operating system is windows, how to get jobid. please help m...

Hi Gurus,
can u please post the dscommand used to retrieve.

plz Gurus help me.

cheers;
vijay

Hi Gurus, I want to retrieve the actual value of the parameter using Operating system command utility. please help me , Because my team lead wants to find a way retrieve the actual environmental variable value which we specify in the administrator using operating system utility. plz Gurus help me ch...

Hi Gurus,
Thanks very much.

cheers;
vijay