DSXchange

The wonderful folks who support this web site have saved my bacon many times (even the old info gleaned in a search is very useful), provided that teensy bit of insight I needed to get me on the right track, and otherwise provided an extremely useful and practical source of all kinds of knowledge. A...

Hello peppinodicapri, I have also come across a situation where I ran a DataStage job one time that called a stored procedure one time via an ODBC connection, and the DataStage job logs show one execution, but tracing on the SQL server shows the stored procedure executed multiple times. And the same...

Thanks for the help, Ray! Seems there is always a way to do what you want in DataStage, or even more than one way.

I'll give it a try tomorrow after I've had a little beauty sleep.

Lynda

I'm working on a JobSequencer that calls a server job inside a loop. It's possible to use the Start_Loop_Activity stage to pass delimited parameter values to a server job inside a loop, one for each trip through the loop. But I want to get the parameters from a text file. I've tried to do this in th...

The IBM iSeries Access for Windows (previously called Client Access) software must be installed on the iSeries and on the DataStage Server. There is a package for each and the versions need to agree. Your local iSeries support team should be able to help with that. Once the IBM iSeries Access for Wi...

Does this technique have any impact on the ability of MetaStage to detect the table meta data to construct "lineage" meta data?

Thanks,
Lynda

Hello, I am using two types of automated monitoring, and they involve using a combination of the tools in DataStage. Not sure if they will help you but they might. First, I put together groups of individual jobs using the Batch Job Control code which end with a status code based on results of the in...