DSXchange

Merge cannot be run from DOS / Windows command prompt.

You may need to either write a routine or call from OS level API.

You need to code so that the job merges 2 files at a time and does for all the 240 files.

You need to define the funtion using deffun.

That may be because the seq has done the flow it was asked by the design.

There are couple of similar post in this forum. Search for more information.

That does not appear to be a DataStage problem. You need show this to your DBA and ask for info

The restriction will only apply on the resources when you run them in one go.

Make sure that the script return code is zero...unless you wish to raise anything in DataStage.

That is because it is called DSGetJobInfo. Search for that.

How did you 'remove' the write stage? In that case, you will have on transformer hanging in the end.

Second, can you post your job design.

Job Status of 2 implies you run finished with warning.

Search for the forum for more info.

Can you post your job design. In a fairly simple job, the read starts with lead time for fetching rows from source and reference. Hence as ArndW suggested, you will be able to see performance improving gradually till you hit the optimal. If you do not see it, it will imply a gradual pressure on the ...

Perform a check of 'wc -l' via DataStage on the file before you trigger this file.

Mandar_Deshpande,

But what if the source file did have rows. If you then want to clear rows, I assume the requirement can be solved by performing a 'wc -l' on your seq file to determine the flow.

You can wait for some jobs to finish before starting the rest. By this way you can avoid the contention.

You can break the jobs into multiple sequencer for now so to run them in a sequential mode.

This is a duplicate post and has been answered in the other one.