DSXchange

I'm not really seeing a problem, at least not from what I remember the behaviour back in the 7.x world was. Generated SQL for an Oracle DATE column defined as "Date" in your job would automatically get wrapped in a TO_CHAR() so that you end up with an external date format of DD-MON-YY. In ...

Or just use the Pivot stage.

On a UNIX system, I'd seriously consider writing a script to read your source file and send the appropriate emails and then perhaps use a Sequence job to execute it. From a complete DataStage solution, a looping Sequence job would seem to be in order, along with the custom mail sending routine that ...

An exact search here for "scientific notation" might prove helpful.

... usually a parameter error, in spite of the feeling that the correct ones are being passed in by the Sequence job.

Doesn't seem like anyone has any inputs and I for one have no clue. Have you asked your official support provider if this is possible?

... or add that path to your $PATH or fully path the executable. You have to help it find it, that's a pretty basic command line rule of play.

My bad... you may need to check the DSSendMailTester version, it shows all of the bits needed and how it puts them all together for the InputArg. That or simply write your own "interlude" to your email client of choice on the ETL server.

You'll need to write your own routine for that. Start with a copy of the DSSendMail routine and tweak it to bcc people, then call it using the Routine Activity stage rather than the Email Notification.

Run it on a single node.

Or perhaps do the import at a "less busy" time if you have a plethora of jobs running against that source right now.

Or just use the pivot stage. Now that the example has been corrected, it is a perfectly simple horizontal pivot. And if you are unclear how to do this, read the documentation for the stage, it will walk you thru it.

Your example makes absolulely no sense. Please explain to us the rules you have that would allow one to get from your source to your target output samples, then maybe someone could help.

If you reset the aborted job, is there a "From previous run..." message added to the log? If so, please post the contents.

Well, to be fair the original post (which was resurrected) is from 2011. October 2011, so only eight months ago but still...