DSXchange

The test you made for Dataset to sequential file, dose it have the same input and output directories of you normal jobs has?
As Arnd suggested, maintain 'Same' partiton on all the stages as possilbe (neglect the warning for the case study).

Bala,
Run the JobSequence once manually. Now you can follow the Kim's method to get the Order of the jobs that been executed.

You can find userid that been used for the job run from the log. If you double click on any of the event, it will show you the user.

I guess sdfasih is refering Windows as share drive (T:\).

As far as I understant you need, once the data been extracted, concatinate ':' in datastage.

There are chances for the files to be created and not cleared by the jobs when the jobs aborted for that run.

It is in alphebetical order.

Are all the three in different stage?
Try to check, if your commit interval =1.

Or check if you are using different user id to run and a different one to Schedule.

Writing the list and order of the jobs in a file and reading it back wont be required option. As mentioned, you can get the list of jobs thats been/will be called by a JobSequence. But not the order. If two jobs triggred parallely at the same time, it depends on the volume of data and other factor, ...

As per Chin, there is patch for Windows environment. You too can approach your support reg this.

Would you mind sharing the solution obtained.

Do you mean to say 14000? But dont get carried away with the post "Ray on 14000!". It was created a month back and still alive. Ray is not even 15000. now.

Provided the actual value is A,B,C,D...

Hard code the column name next to each column using a transformer.
In PIVOT stage, mark A and B as key, and pass all hard coded column name into COL_NAME and the column value to COL_VAL.