DSXchange

Where is the "frustrated" emoticon when I need it? I have a parallel job consisting of two stages. The first stage is a custom wrapped stage. On the Wrapped\Output tab of the stage properties in Manager I have declared one output link, attached to the standard output stream. The wrapped co...

Figued this one out. Well, sort of. There are fields on the "Environment" tab that allow you to specify how different return codes are handled. It appears that the return code must be of integer type. However, I still can't figure out how to differentiate behavior for various error codes -...

Hello, Can anyone please tell me if it is possible to get a return code back from a wrapped UNIX command? Consider the example stage from the Parallel Job Advanced Developer's Guide . This stage is a wrapper around the sort command. Sort returns either 0, 1, or a larger positive value (indicating an...

After many hours of tribulation, I have finally managed to successfully call an external routine from PX! :D It appears that the following requirements must be observed: 1. You may not use an underscore ('_') in the name of the library or object file that contains your routine. 2. You must modify th...

I am trying to use the new Stored Procedure stage (NOT an ODBC stage) to call a DB2 stored procedure. This procedure accepts a single input and returns a cursor to a result set. The result set contains a number of numeric and character fields. My question centers around how to map the result set to ...

DB2 is supported, at least in the version I'm using - 7.5.1. From the stage documentation included with the product: With this release, the options are DB2 , Oracle , and Sybase . If I could include a screen shot, I would. That being said, the problem appears to be specific to the issue that I raise...

I'm trying to call a DB2 Stored Procedure via the Stored Procedure stage in version 7.5. I've set the stage up as a "Transform" type, and I'm using the following syntax to call the procedure: CALL D1K.SPKF100_XRF_TYPE(?, ?, ?, ?, ?, ?, ?, ?, ?); The data types for the parameters are varcha...

Another option is to use your 3rd party scheduler to schedule the job regularly. Daily or hourly. To control from your end you can have a file . IF the file is present the job will not start. Once you remove the file, the job will run regularly. I am assuming you are starting you sequencer using a ...

Oh,

We have a good 3rd party scheduler. It's just that my group doesn't "own" it and we have to go through someone else to *do anything* with it.

Thanks,

tpb
DataStage newbie

Update: I recompiled everything exactly as specified in the examples from the Ascential installation disk. I also rebuilt the routine definition and jobs from scratch. Still getting the same error. :x There is nothing unusual about our installation as far as I know. Our administrator has been lookin...

I was unaware of the "Sleep HH:MM" format - how did you find out about it?

It is not in the documentation that is displayed when the menu bar Help option is selected from within DataStage. At least, that's not the case with my installation.

tpb
DataStage newbie

Hello, Has anyone had any experience running DSEE/PX jobs or sequences over longer periods of time (several days)? If so, have you had any bad experiences with the jobs hanging, memory overflows, etc.? In my specific case, I'm not intending to do anything complicated during most of the run - but I d...

Excellent!

So, now I've learned two things today (at least), the most important of which is:

You can use server routines to control a parallel job sequence!

Thanks for your assistance!

tpb - DataStage newbie

:? Well, it looks as if I was a bit premature in my celebration. At least I learned something new today (IConv). Sleep cannot be used in expressions, which is where I was planning to use it (as the condition for a trigger to the next stage.) So I am back to step one - how can I force a processing de...

Great idea - just what I needed.

Thanks for your help!