DSXchange

Don't see why not as long as there are DB2 drivers... but I see you are having issues trying to do so. I don't have access to any DB2 instances so can't really help there.

Welcome! :D Performance is a relative term and many things can affect it. Sure, doing multiple somethings is more expensive than doing one of those somethings. However, if you mean will it behave differently when using multiple links to a single stage rather than using multiple stages with single li...

Besides, you'd be better off comparing 6.0 to the 7.5 version... and there are pages of differences between the two versions.

Was going to spell it with a Texican accent, but wasn't sure it would be understood.

'Complete batch'? I'm guessing from your 'usually it just send the last row of a batch of rows' comment that you want a lookup to return a 'multi-row result set'. If that's the case, there are pleny of conversations here on the subject that a search would turn up. And one of the first things you'll...

So if any of the Child JobSequence aborts, the main Job sequence does not getting aborted. That's true - because nothing went wrong in the main Sequence job. You need to detect the problem in the 'child' Sequence job, propogate it up the foodchain by logging something in the child Sequence job and ...

Also explain me where to find abt the 'Last' in Aggregator Actions. What does this action do? It does exactly what it sounds like it would do. It is part of a related series of actions that don't technically do any 'aggregation': First Last Max Min Each one works within each 'group' you are aggrega...

In other words, it ain't there right now and no idea if it will resurface at some point in the future.

Nope, not until you upgrade and have access to the SP stage.

My Admin Team informed that all are with in Limits. If that was true, you wouldn't be here posting about a -14 error. Yes, they are hard to diagnose sometimes. Keep in mind it is all load on the server, not just the 'ETL load'. It attempted to start a job and did not hear back within the timeout pe...

No, not parameters passed. You have to keep in mind the fact that your 'Output' from DSExecute is not a simple string, it's a dynamic array of values. That syntax just means take the first entry from it, which is all you really wanted in this case. If your output was multiple 'records', each would b...

Are you getting an error? Or it just "doesn't work"?

Try passing Output<1> to the parameter value rather than just Output.

So, for every row in the flat file, I need to create new file. I can do this by using JobControl, but is there any other way? No. At least not if you really need to create a new separate file for each record ... Well... maybe using the XML Output stage. Its output could look very 'flat' if there's ...

Not really... which is why you got the 'use the Aggregator' response. Most people aren't going to burn alot of brain cells trying to puzzle out what the heck you mean, so throw us a bone here. Post examples.

Your issue is a little... hard to follow. How about some examples? Post some samples of input data and what you want to come out the other end.