DSXchange

Craig - This routine works till 29 char. If the input is 30 chars it does not work. I know what you've said before, simply saying it again doesn't help. My question was about row buffering, something you didn't answer. And the routine works fine for me - I just build a quick test job passing it str...

Then it seems like your solution is to not overload the startup process but pause for a few seconds between invocations.

rkdatastage wrote:Datastage server and Client are both in same Machine and OS is Windows XP.

One word - unsupported.

I personally would assume a typo in the FAQ posting.

Why do you feel the need to load all 25 tables in one job? Just because they are 'related' doesn't mean they all need to be loaded simultaneously. Most people would approach this in a more modular manner, using separate jobs, loading tables in RI order and tracking problems as you work your way down...

Typically using manual 'aggregation' with stage variable concatenation in a Transformer. Search for 'vertical pivot' for discussions on the subject.

Also, the 'criteria' is spelled out in the docs. Basically - Oracle client installed and dsenv edited to support Oracle.

Allegedly 'yes' in version 8.x but otherwise - no.

If there is a restriction, it's certainly not less than 30 characters. You aren't using Row Buffering, are you? That is contraindicated when using routines with COMMON storage, which this relies on.

Usually one would write a script with the multiple steps and then execute the script using the stage. Or you could stack the commands up with '&&' between them, I prefer that to ';' as it only proceeds to the next command if the previous command succeeds, but either could be used.

Custom sql? The number of parameter markers in the SQL don't match the number of columns defined in the stage.

Again, 'transaction rollback' can only happen under the following circumstances: 1) You have not yet committed the records, so 'Transaction Size' is important. Typically, that would mean using a setting of zero. 2) The job aborts. Period. It must abort in order to rollback all uncommitted work. The ...

Your output field needs to be a string and I'll wager it ain't.

ArndW wrote:Please rephrase your question and narrow down what you are looking for (in another thread) and I promise you won't have any of us making silly comments on the thread or making you lookup Thiotimoline

Yes, please... let's try this again.

The dang job is so fast, it finishes before it starts!