DSXchange

What is the purpose of the osh script that is generated in a DataStage job compile? Can it be used with the osh engine? Or is it just for nostalgic purposes?

My question remains unanswered. Perhaps I am not posing it clearly enough. The code I posted earlier is in a before-routine that retrieves database connection information and sets corresponding parameters in the current job. I am using undocumented datastage variables and constructs to set those par...

What would be most recommended if special constants and variables will not be available in future releases? I am currently using a before routine to get database connection information for a given table. The routine then sets the connection parameters for a DB2 stage. Can I use a job sequence with a...

We also use a scheduler to run DataStage jobs with dsjob. We have a shell wrapper function that calls dsjob with -run -mode RESET prior to calling dsjob with -run -mode NORMAL Hi, How can we compile a project/job from command line on UNIX OS. We are in the process of automating the jobs using schedu...

It's ashame that may not work in the next release. I have another block of code that lets me set parameters for the job in the before routine: Writev ParamValues On DSRTCOM.RTSTATUS.FVAR, StatusId, JOB.PARAM.VALUES On Error Release DSRTCOM.RTSTATUS.FVAR, JobName On Error Null ErrorCode = 5 Call DSLo...

I was accessing the parameter before the READV statement. I had the following lines of code, which was merely returning the default values of DataStage parameters. ParamValues = STAGECOM.JOB.CONFIG<JOB.PARAM.VALUES> env_flag = ParamValues<1,ParamPos> In the following code block, the READV statement ...

How does a before routine process parameters passed in the command line? I can get it to read default values but not what is passed via the command line?