DSXchange

It's been discussed and posted here many times. Once more, for the record:

OCI uses native drivers, period. As does the DRS stage when explicitly set to Oracle. Nothing to doubt there. If you have other doubts, you'll need to enumerate them as I'm not about to try and guess what they are.

OK... that answer assumes they are still being stored in the "Universe" repository, which may or may not be the case depending on your exact 8.x version and certain settings.

CLEAR.FILE RT_LOGnnn where 'nnn' is the internal job number of the job in question. You'll then need to re-establish your auto-purge settings as they will be gone as well.

Two thoughts - 1) Ditch the Sequential File stage. 2) Read this.

I never go by the forum any more, God Knows where posts end up nowadays.

I agree with Shane, your intermediate calculations go well over your scale of 10.

There are environment variables for handling decimal data: APT_DECIMAL_INTERM_ROUND_MODE, descrption is it specifies the default rounding mode for any decimal intermediate variables required in calculations. The default is round_inf. APT_DECIMAL_INTERM_SCALE Specifies the default scale value for an...

As noted, no - you could use those from a routine and call that after job. For a script you need to stick with either dsjob options or things you can query from the repository.

Are you reading from or writing to the sequential file when you have this problem?

You need to be more clear when you repost this in the proper forum. This isn't it.

Command, not command line.

There's no "better". And of course mine are well documented on the canvas with annotations clearing explaining both what it does and the fact that all of the code is on the Job Control tab. Plus I also get full control over when it gets compiled.

Ah, so not a typo after all?

This one might help:

viewtopic.php?t=127088