DSXchange

Noted. How about the other "O" word - ODBC driver? Might the "2 rows affected" message have been generated by an ODBC driver?

What's the limit when you run from Designer? That's what this thread is about.

I guess the question is why running from Designer doesn't pick up the defaults specified in Director. Have you asked this over on ADN, or of your support provider?

DELETE is a transaction. If the database is logging transactions, then all DELETE transactions will be logged, along with all others. The whole point is the ability to roll forward to a given clean point. TRUNCATE is not a transaction; it's an operation on the table, so is not logged. You lose the a...

Transformer stage with N output links ought to do it.

It occured to me that the IPC stages are not required in my second design, which will make maintenance even easier. I've editied it to eliminate them.

Read the help on how to signal to the ODBC stage that you want multiple rows returned (it's actually a check box in the Transformer stage). You can not do it at all with a DB2 stage - it returns all three but only ever uses the last one in the result set - and generates the warning you mentioned.

Arnd, I thought you were on vacation! Didn't want to risk the slopes on Friday the thirteenth, eh?

If this is the DB2/UDB Enterprise stage then you're talking about a parallel job. Is it a parallel job? Techniques are different in parallel and server jobs; you have posted in the server forum, yet mentioned the DB2/UDB Enterprise stage.

You may lack write privilege to the job configuration file (RT_CONFIGnn) in the test environment.

And enable auto-start of the deadlock daemon (the dsdlockd.config file is in the DataStage engine directory on the server). The deadlock daemon has a secondary task of freeing up locks and shared memory held by defunct processes each time it wakes.

Ah, one of those clients! OK, request the manual, maybe it will scare them off. That said, if you have the skills, writing your own plug-in can be useful for functionality that DataStage lacks. For example, Hitachi (in Japan) created plug-in stages that allowed their database (HiRDB) to be accessed ...

Sorry to hear of your tribulations. I guess all mine have been well-disciplined projects from the start, then.

In on-line Help from Designer or Manager, the topic you need is Input and Output Link Variables . The constants are selected from the expression editor drop-down menu. I guess, by not documenting them, "they" can add to the list as and when they choose. You will find an EQUATE declaration for each l...

TIMLogErrorMsg should be a transform function in the Routines branch of your Repository. This error will occur if it does not exist or if it has not been compiled successfully. Make sure, when you compile it, that you get a "compilation successful" message.