DSXchange

Hi all ,
Is there any functionIn Datastage to encrypt a value in the server routine

Is it like you are processing some kind of where class to another database or a script file or something? After concatenation, check for IsNull(), and assign the required default value. yes what you said was exactly right. I have used IsNull() condition but i observed is that once there are records...

I have three columns in one row which are concatenated and there are 5 records which are concatenated with or. Iwas able to concatenate. the soure is an an OCI stage The problem is when i don't have any input any records A NULL STRING IS BEING PROCESSED instead OF THE NULL STRING i want to pass a va...

hi all,
i have requirement to concatenate all the input records and then only pass it as a single record in to the sequential file.How can i do this?

Even if i give that it is not working

ArndW wrote:Is this a server/parallel job or a TX job?
If the former, you can use DSGetStageInfo() using the DSJ.STAGECPU key to get CPU time used in a stage. There is still a bug in this value, it ...

this is a server job. Is it not possible to get from the xml file

I was asked not to use the job parameter. instead get it from the enviromental varibale.i saw the few discussions from those For this part i have this the syntax like this Call DSExecute("UNIX","echo $DSLOG_DIR",UnixOutput,SystemReturnCode) var = UnixOutput but still i get an err...

Hi all,
I have generated an xml fileof the attached job in a routine.
the xml file contains the full information of the job.

Now i want to get job's process id and stage pid and cpu time from the xml ile generated .

Is there any way todo that.
Please help me

Hi all, I have to write to an xml file about the job in to a directory. what does the t.fvar mean . what does it do? does write ReportText to t.fvar, v_JobreportFileName else sufficient to write the full information please help me on this Openpath v_logFolder to t.fvar then write ReportText to t.fva...

Hi all,

what is DSJ.JOBWAVENO?

What is the use and what info we get from this

I am testing using after subroutine now.I want to see the output of the routine can iuse it in a transformer stage and see the outut what i get in the variable

Hi all, I have my code like this in the routine $INCLUDE DSINCLUDE JOBCONTROL.H v_jobHandle = DSJ.ME v_logFolder = DSGetParamInf(v_jobHandle,DSLOG_DIR,DSJ.PARAMVALUE) Ans =v_logFolder I have wriiten this in a routine. If i want to get the paramvalue from the job should i attach the routine in after ...

use the DSGetParamInfo() function to retrieve its value.

This worked out well. thanks

ArndW wrote:When you refer to DataStage internal variables and routines in your own job, you need to add the following line to your code:

Code: Select all

   $INCLUDE DSINCLUDE JOBCONTROL.H

...

Thanks ..
By adding the above piece of code it works fine

Hi all, I have set one parameter dirloc in the administrator. The same parameter in the job is assigned a $projdef. that is the parameer gets a environmental variable. Can i assign an environmental variable to varible in routine. If so can anbody tell me the function and the syntax to be used