DSXchange

We will be using DS 7.5 on unix for a conversion project. The total number of jobs developed could run into 800-1000.
The entire conversion process is categorized into subject areas, and each subject area contains a number of tables which are to be populated based on a loading sequence.
we are still in the initial phase of the project(Still to receive the DS 7.5 license , that is how much the initial stage means), but the requirement is that the dependencies for table loading might change. These changes need to be incorporated without changing much of the design.
the design that we thought of was : create jobs in PX to perform the ETL on tables, then write code in BASIC for sequencers to handle the sequencers.
would it be possible to go according to the approach mentioned above?, or is there a better way of doing?
Thanks.

You can indeed do what you desire.

But it may be more fruitful, if you're not a confident DataStage BASIC programmer, to realise that a Job Activity can start a Job Sequence as easily as it can start a parallel or server job. That is, you can build a hierarchy of Job Sequences, with condition testing at any level to determine what to do next.

Hi,

DataStage has incorporated a very improved and flexible stages to handle job sequencing activities in 7.5 including Restart logic. You should use this. After all, Basic routines are not parallel.

Regards
Amitava