DSXchange

My suggestion? Post it again in the correct forum.

"see the log file for the Oracle specific message"

It's a database error, how can they have nothing to say on the subject?

Sorry but I have no powers here.

What did your DBA say?

So... you'd either need some sort of 'pre-process' to replace the delimiter string with something more normal and single character or perhaps read the record as a single long field and then parse it in the job? :? I'm guessing one could whip up a BASIC routine using Index() and substringing out the ...

I think you're on the right track with Index() and Field(), however not sure you can do all that if logic along with it in one derivation. Can you post the syntax you've tried and the result(s) so far?

I'm not sure anyone here could actually answer that unless they've ask this same question of IBM. Unless someone else pipes up, I'd suggest you ask your official support provider about that, see if there are any known issues with the connector in your flavor/version. Then let us know what you find o...

[modified subject to be less... excited]

Woo-hoo! KBA Job Control Utilities! :D

I don't see anything that would require a constraint and it sounds like you just need one output link with one field set to whatever field is the first one you find with a 'Y' when you do the nested if-then-else that Ray mentioned in the output field's derivation.

Have you asked your DBA for help? Checked to see what the state of the Oracle process is? Grep'd for the processes in UNIX? You need to determine which bits, if any, are actually still running.

Red herring, eh? I hate herring.

The biggest question you need to answer regards concurreny - will your load run in isolation or could others be loading into the target as well? That will drive your available strategies.

Did you try an exact search for Could not find type: "subrec" ? There are two other posts that mention that, see if anything there helps.