DSXchange

In my datastage project the parameter called ErrorNumber is common across all Jobs. This parameter carries a defualt value for each job. Is there a way of querying the DataStage repository to list all Jobs with corresponding deafult value for this parameter ?? Please let me know how and what query t...

I have got around 800 DataSTage jobs in my project. In those Jobs are many DB2 stages. In those DB2 stages somewhere in the Input SQL or in the table name property the table 'DI_DIMENSION' is specified. Is there a way to list all the Jobs that contain the table. There is no table definition defined ...

Can someone please suggest how to extract all Job Names and its corresponding short description into a text file using a DataStage Job. Probably by querying the repository. What Stage to use and whats the SQL ??. What privilige is required to do such a task ?? What connection parameters need to be u...

I have a windows 2000 server with more than one processor. Now turning inter-processsor row buffering on can there be true utilisation of multi-processors ie. multiple processes running parallely ??

I have done this.. D/S has a built in routine called DSSendMail. You can call this from the Derivation or constraints inside the transformer. Eg From Derivation If @OUTROWNUM > 5 Then DSSendMail(StageVar) Else InputLink.MappingCol StageVar is /n seperated parameters consisting of your exchange serve...

Guys Many of our jobs were originally written in DataStage 5.2. Now we have moved to DataStage 7.1r2. Whenever a Job sequencer fails, we have to go through the tedious process of running the remaining jobs manually or have written a script which reads from a file as to what remaining jobs to run. In...