DSXchange

Yes, of course it will accept negative numbers. I must admit, however, your derivation confuses me... you multiple 9 by 0? To what end, just to get a zero? And then set a variable to either an 'N' or a negative number? Kind of an odd way to flip the sign, if you ask me. :? Other than that, why the d...

For newcomers: to Suppress "Commit point reached" log add SILENT=FEEDBACK option like this: APT_ORACLE_LOAD_OPTIONS = OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,SILENT=FEEDBACK) Not that that helps the commit frequency but may save a few seconds. FEEDBACK=SILENT makes more sense though, did you m...

OK... both are the same version of Oracle or are they different? And what Oracle client do you have installed on your DataStage server?

From the Director, Reset the aborted job and let us know if a new log entry shows up labelled: "From previous run...". If so, post the contents.

Not really, not without more information. First though, do an exact search for "Job control process has failed". You'll only get two matches but see if either one helps.

Right - this is a completely different problem unrelated to your posted issue, so please mark this one as Resolved (using the button at the top of the page) and start a new thread.

Read? Sure.

You should check with your official support provider - I seem to recall a patch for this, or at least something very much like this with the OCI stage.

Sure... after the fact.

Custom / user-defined SQL or generated?

This happens when you have users connected to the project, or any connected processes other than yourself, actually. Make sure you are all alone on the server before you run that - if that means you need to shutdown DataStage and then do it right after bringing it back up and before anyone else logs...

You can certainly do that, as long as you don't mind the extra characters in the data and you keep in mind the fact that the moment someone 'fixes' them it will revert back to the date it thinks it is.

Right, that's what it does and there isn't a good way to stop it. Open the attachment in something like Notepad to see the 'real' source data. Change the extension if you want to prevent the file from being automatically associated with Excel.

Excel.

So... no interest in posting the examples as requested?