DSXchange

Thanks for the reply Phil and DSGuru. I had also suggested my client about the Server job but client did not accepted it as the source data is 1.6Billion records. So I am planning to do it in Shell script. Thanks for the suggestion.

Hi, I have one source file ( dataset) and I need to create many output files from this source file based on different conditions. There are around 1000 conditions and I need to create 1 output file for each condition. I am thinking of creating 30 jobs and each job will create 30 or 40 outpufiles. Is...

Hi Criag,

We have not installed 390 edition of DS.

Hello All, Iam new in handling mainframe datasets.For extracting data from mainframe datsets from mainframes environment we are using ZOS file stage with CFF stage sample job design is as below Zos Stage -->CFF Stage -->> then processing logic --> final target(Sequential or dataset or tables) We hav...

Hi,

Is there any function available in DS equivalent to Oracle IN or NOTIN functions?

I need to implement below logic in my job.
If the column PRODUCT value is IN ('AA','BB','CC','DD','EE','FF'), then the output is 1 else 0.can you please suggest any ideas?

Thanks & Regards,
Veera.

If your source is Sequential file then..In properties tab-->Filter option...try to use sort -u #FileNamePath#....Which will select only unique records from sequential file stage

Use Parameter sets in job....Parameters of paramter sets can be updated using Datastage job ....For every parameter set there will be a file which will have paramter name and Parameter value(Which will be default)..If your job can update this file then we can pass that parametr to next job run time

For any change in shared container execpt addtion of parameters...we have to compile all the jobs which are using that shared container to get that change

If ( trim(nulltoempty(monitoring_flag)) ='Y' or trim(nulltoempty(monitoring_flag)) = 'N')
Then monitoring_flag else setnull()

Hi Mike, If all jobs in the sequence are parallel,then add a output link for each the jobs in sequence and join all those link using sequencer and then ouput of the sequencer to a terminator stage. In each of the job activity stage apply trigger condition select failed conditional and in the sequenc...

Hi Mike, In the job activity stage->Trigger tab...You can set the condtion by which next stage will be or not execute.... in our project we generally select Custom conditon option in drop down and include condition JOB_NAME.$JobStatus= DSJS.RUNOK OR JOB_NAME.$JobStatus= DSJS.RUNWARN which indicates ...