DSXchange

RIP

I suggest you to review the subjects described on the following links: http://www-03.ibm.com/certify/tests/objC2090-424.shtml Then you can try to pass the assessment down below: http://www-03.ibm.com/certify/tests/samC2090-424.shtml It will show you which subjects you still have to review before the...

1 -> Maybe you can put all the parameters you have to process as last parameters of the UNIX script calling the DataStage job. ex : 1st param : job name 2nd param : user 3rd param : psw All the other params are parameters to pass to the job You can get the number of parameters passed to your script ...

To my knowledge, if you have to run DataStage jobs from another application, you will have to use the "dsjob" command, either the client or the server version of it. The IBM documentation below https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.direct.doc/topic...

Are you sure the lines are not written to your output file? Sometimes DataStage removes some useless stages while running.
Because the link is believed useless the performance stats are not written under it, but they are actually drag to the output.

According to my knowledge, you can't control 3 independent data flows in a single parallel job.
The only way is to split your job in 3 sub-Jobs and call them with a Sequence Job.

That's a lot of jobs.

There is a forum dedicated to DataStage Server >Here<.
Perhaps you will have more answers there.

Edit : Damn, craig is fast !

You can also use the DataStage functions, ex :

First we need to know what do you want your job to do with these 25 files ? Then what kind of metadata do you have on these files (string, decimal, ...) ? Do you always have the same number of fields on each file ? As you said in the title, a solution is to use a schema file for each CSV file with t...

You can also use a Modify with the "KEEP" keyword.

To see if DataStage sort your data before processing the join operation, just set the APT_DUMP_SCORE to 1 and run it. In the log you will see the 'Score', if there is a 'tsort operator' for your join, then DataStage sort your data. By default, when DataStage sort data he use 20MB per partition as an...

You can also use the Modify stage to do the conversion operation and use the NOWARN specification since the string to decimal conversion seems to be handled by DataStage : https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/c_deeadvrf_Default_an...

You can do that transformation using a looping transformer : Create 6 stages variables as below SvRecord : If @ITERATION = 0 Then Ln_Input.InputCol Else SvRecord SvCol1 : If @ITERATION = 1 Then Ln_Input.InputCol Else SvCol1 Etc... Then loop while @ITERATION < 6, create 6 fields ( Record,col1,col2,co...

If QualityStage is installed you can view his components from the "Data Quality" section on the palette when a job is open.

Did you try to use a transformer (or a filter) to validate the rows on the output link of the pivot stage? Otherwise you can pivot the data using a looping transformer with only 2 input fields (concatenate all the "src_col" fields) and use the field() function to process the columns one by...