DSXchange

Yup, typically corrupted from a full disk or you've blown through the 2GB Barrier. Issue a CLEAR.FILE RT_LOG43 from the Administrator or a TCL prompt.

Short answer is 'yes'... you can mix Parallel, Server and Sequence jobs to your heart's content.

And I, yours.

LONG? Unless your Oracle version is very old and you have no other choice, steer well clear of them. Use a CLOB instead.

What are the native data types on each end? Note that neither TEXT nor CLOB fields are officially supported...

As requested.

First thought would be to double-check the procedure. What exactly does it do? What is your job design? We'd need much more information to be able to help in any kind of meaningful way.

Yes. You set all that when the Lookup Fileset is created, not when it is used. See the Parallel Job Developer Guide for details.

First off, it's EBCDIC and secondly, which in all that is the COMP-3 column? Can you post the complete definition from the FD?

I'm sure that's all documented, but that's not something I have access to. Let's wait for our resident expert to arrive, shall we? You could always dig out the docs in the interim.

Nicely done, Sir. Forgot that you don't even need to check, just slap some on and hack away.

You funny.

It shouldn't be asking you directly as you do not run these from the Director. All that should be automatic when you deploy the service and it is enabled, an invocation id will be generated for you appropriate to the number of invocations and what has previously run (it is basically a generated numb...

You should take the right-most 5 characters and then pad on any additional leading zeroes if the original length was less than 5. Are you certain that your 10 digit source will always fit in 5 digits without loss of significant digits?

Have you tried searching here? It's been discussed here about a bazillion times but could be hard to find I suppose if you didn't know exactly what to search for. So... since this practically always comes up in said discussions, start with an exact search for ETLStats - dig through those and then le...