DSXchange

Really? Another person on the same team tagged onto the stream with a completely different xml problem after it appeared they solved the first one. My answers may seem to be 'way off the mark' in the context of the first problem, however that was not the issue I was responding to. For the record.

Just for sanity's sake, which suggestions are 'way off the mark'?

You did notice there were two different problems being discussed here, what with the thread being 'hijacked' part way through and all.

Use code tags so that any formatting of your xml is preserved. Post both what you are getting now and what you want it to look like instead - two examples, clearly labelled which is which. Please.

If the Sequence job aborts, you are done. Why did it abort?

I said Oracle client runs fine on datastage server from any account. This shows that we dont have problem with oracle environmental variables. Problem is only with Plug-ins in Dstage. Then what you have in your dsenv is incorrect. Post the latest version. Since all you need is $ORACLE_HOME and $LD_...

Simultaneous.

The online Help explains this. You need to explicitly handle the 'error', or at least appear to, so the Sequence job doesn't try to do it for you. That could mean a pair of triggers - a Failed (Conditional) and an Otherwise trigger, for example - would do it. You could use that and make the Failed t...

fk4u wrote:I can connect to database from dsadm user which is owner of datastage installation.

So... it works when you use dsadm but not under another userid?

Add all that other stuff if you need to 'Automatically handle activities that fail'. From what I've seen that is only possible when you have output triggers on the stage, so link them all to a single Sequencer object with 'OK' triggers, the job will do the rest.

Besides the fact that you really can't directly compare a dsenv file from an AIX box with a Linux box, seeing as how they are different operating systems and all, let's start with something simple. Do you have an Oracle client installed on this Linux server? Are you certain that the Oracle informati...

Most of these questions aren't DataStage questions, per se - they relate directly to Oracle. You should be able to take them to your friendly neighborhood DBA man and put them to him. Or her.

For a Sequence job design, you don't necessarily need anything other than the 10 Job Activity stages. Simply don't link them together on the canvas and they'll all run 'in parallel'.

The short answer is 'no'... not directly in a job, anyway. Typically, people seem to be building a consolidated file and then splitting that output file into the separate files you really wanted post job. Perhaps with a script, awk, perl, c program - whatever your weapon of choice is for those kind ...

Did you miss the smiley, Uncle Ray?

Excellent, glad it all worked out. Seems like all of the database stages - with the exception of the ODBC stage for some reason - want to have all of the columns mentioned in the stage bound into the sql. And as you've found, it doesn't matter if it is generated or user-defined sql, bondage is requi...