DSXchange

Ah... [facepalm] I was wondering why you felt the need to post the image. Nice catch, Mr Ray.

No such thing.

OK, that's good. Now when you say you are "using it" what exactly does that mean? Is this via an ODBC stage in a job or elsewhere? If elsewhere, have you established whether you can or cannot connect using it in an ODBC stage in a job? The more details you provide about what you are doing,...

What do you mean by 'manage them from the client side'? Connection pools are transparent to applications, DataStage would have no clue if it was using pooled connections or not.

What are the compiler options you have set in the Administrator?

Projects / Properties / General / Environment / Parallel / Compiler

I have no clue what they should be for Windows but it sure seems like posting them could help.

You may have two host names for the load balancing but you still have only a single tnsnames entry and that's all you need at any given time. Have you been able to use this tnsnames entry outside of DataStage? Meaning, can you make a sqlplus connection to it to the RAC database?

Nothing magical about RAC, your 'samples' are in the .odbc.ini file in $DSHOME like normal. Meaning, treat it as any other ODBC Oracle data source.

Sure, the normal syntax for executing multiple commands applies. You might want to use "&&" rather than ";" as the former is conditional, an error stops anything after that running.

It's certainly *a* right process and how you would do it 'after job' as part of the job in question. Another option would be to use a Sequence job to first run the job and then use an Execute Command stage to run the script as a separate action after the job completes.

You installed what C++ compiler?

Since "dsxcutter" didn't turn it up:

viewtopic.php?t=113429

What 7.x version? Does it support attachments? Is it ok to email both people in the 'To' line or do you literally need to 'CC' the second person?

I would suggest you look into the XML Output stage along with use of the Trigger column option in it.

The answer totally depends on how your 'job control wrapper' is coded. By default, all a job will use are the default values coded in the job at design time. However, from what you posted it sounds like your wrapper is coded to check to see what parameters the job uses (-lparams) and then I assume i...

If you use the client software your version supports, you should be able to connect to higher versioned databases. From what I recall, 7.1 supports 8i and you'll get 9i and 10g officially supported in the 7.5.x world. I'm not positive if 11g is officially supported yet or not, I can check later. To ...