DSXchange

Hi All,

How to control the execution order of different stages in a single job.

Thanks in advance.

You can only control the order by the way you design the job as DataStage will try to execute everything concurrently. If stages have dependancies then those will determine the execution order, i.e. if you create a dataset and use that as a lookup then that branch will have to complete before the first data row is processed in the lookup.

ArndW wrote:You can only control the order by the way you design the job as DataStage will try to execute everything concurrently. If stages have dependancies then those will determine the execution order, i.e. if you create a dataset and use that as a lookup then that branch will have to complete before the first data row is processed in the lookup.

Thanks for the reply, its not like that all the stages are trigerred at the same time, Dataset creation and the same time it is being used in the lookup leading to the failure of the look up.

If I am creating a file in the job in one flow and at the same time in the other flow if the file is used, then how this is going to work because when a job starts it triggers all the processes at the same time.

You MUST design that as two jobs.

The operating system will not permit reading from a file that is being written to.

Thanks for the reply, even my understanding was that only.