DSXchange

It's all Oracle. After you play the tkprof games, another suggestion (again) would be to replace the OCI stage with the bulker loader. It really should have been your first choice.

Very nice Uncle Ray.

You forgot the 'regarding'.

No, nobody mentioned the 'b' word - just a 'works' versus 'not works' discussion. Geez back at ya.

We're way past any AMD v. Intel 'incompatibility' days, if that's what you mean Ray.

So what u mean to say is that, the Otherwise link shud go into a Sequencer which further has no more links and the Conditional link can directly go into the Job2 ? Yes. The Sequence stops means the Sequence will end with Status Finish[Ok] and not Stopped ???? Yes - 'stop' as in 'end' as in 'Finish ...

Don't send your Otherwise link through the Sequencer to Job2, that defeats the whole purpose of it. Send it to another Sequencer, that will 'dead end' the link and the Sequence job will stop. Remove the Sequencer from the Job2 link, you don't need it after that change.

Yes. Please search the forums for 'setuserstatus' (yes, all one word) and you'll find a bazillion conversations on that very subject. Take your pick.

That means you can explain it for us non-cricket-following heathens.

'Maintenance'... if I had to guess.

np. Glad you found it quickly.

I guess I should have a thicker skin than this, but how in the heck does my simple request for you to 'post your syntax' deserve a rating of '0: Off-topic / Superfluous'? Look where we are now, you posting exactly that after someone else requested it. And it would have reveal that you were manually ...

At least you've got a row number, sometimes you don't even have that.

You get to do this the old fashioned way - all on your own. Check each data element and compare it to the max size in your target table.

As noted in your other thread on this issue, you need to reset the aborted job and let us know if anything labelled 'From previous run...' shows up.

Look at that, mention his name and up he pops.