DSXchange

Too many assumptions here at the moment. What stage exactly - Oracle Enterprise? And are you doing an Upsert or a Load or ??? Details, please.

Get rid of the TIME interval, that tells it to issue a commit every two seconds.

No. The routine reads a single file.

Of course you can, that's what the "-wait" is documented as doing. Your issue at first was the fact that the Sequence job always finished ok - now that it aborts, if what you want is the standard "0 else non-zero" rather than knowing exactly what happened then you just need to sw...

Nothing you've listed are "bad characters". How about some details? Tell us what stage and options there you are using and post the actual warnings / errors from your log.

I'm confused as to how this can be so confusing. :? It's way too late to be worrying about a "data type" as you have (allegedly) already defined the parameter in the job you are running, have you not? And there's no need to define it again in the Sequence job as you are not passing it into...

OK, good - now the Sequence is aborting as well and will return an exit status of "3" when using the -jobstatus option. If that's not what is happening, make sure you are using it by itself and not in conjunction with the -wait option - it's one or the other.

Didn't quite answer the question. Does the Sequence job itself abort? That's the crux of the issue and something the Terminator should be doing for you.

Exactly, hence my question.

Use it in the Job Activity stage as the value passed to the parameter you've defined in the job for this purpose.

Either of the "Developer's Guide" pdfs.

Clarify what is aborting here - the Sequence job itself, job(s) it is running or both? If the Sequence job aborts and you are using -jobstatus you will get a 3 rather than a 1.

karry450 wrote:

chulett wrote:Again, what exactly are you putting in the stage that it won't accept? ...

Im putting paramfile value expression as file it shows in red and the job doesnt compile

Argh! Don't just repeat what you've already said, that doesn't help at all. I want to know the value you are putting there.

Of course, but they're not trying to open "/".

Then make it clearer... over there.