DSXchange

Define what you mean by 'compressed data'.

I developed a job with an Oraociblk target. This had about the same performance as the ordinary OCI stage. That must be because you are using the dreaded 'Automatic Mode'. Yuck. Switch it to Manual and use the stage to just generate the files you need. Then script a plain old sqlldr direct path bul...

Actually, I meant dump the stored proc/function and replace it with a 'normal' OCI stage. It's just doing an insert after all... why make it more complicated than it needs to be?

Why not just replace it with a simple OCI stage?

So, do you have it figured out? OraOciBlk is the one you want, probably in Manual mode. We're using it with both 9i and 10g databases.

Ok, that's a start. Suggest you post more specifics about the job design - what stages it uses, how it is laid out, data volumes, if the job has ever run before, etc... and then see if anyone can help. Other than changing those parameters, I'm not sure what else to try. Hopefully, someone experience...

Well, did you try searching?

With so little information? I don't think so. All I can suggest is you Search for 'CreateFileMapping' and see what turns up.

I've marked this day with a white stone.

'Job Control' code, typically written by hand. Director: Tools / Batch / New... if we are talking DataStage 'batches', that is.

What are you using to send mail from Windows? It may want spaces between addresses, commas, semi-colons - who knows. UNIX just wants whitespace. And the "best" way I've found to handle this is to use a group for the Notification Activity, not individual email addresses. That way the recipients can b...

No, all I meant was exactly what I said - it all happens as a single unit of work. All the rest is under your control via the link ordering, array size and lastly transaction handling - the number of rows per transaction - that you setup in your job and the Oracle stage.

Umbix62 wrote:But the question is. An Oracle Stage used to insert some rows from two input links includes the two insert operation in the same transaction or not?

Yes, same transaction as long as we're talking about a single OCI stage.

Ken has already given you the solution. In spite of your desire to not used hashed files for some reason, you will need to in this case to separate the 'good' updates from the 'bad' updates. Good updates will get a hit on the existing keys hashed file and are sent to the database stage for 'updation...

Another option similar to the second one offered by ogmios. Assuming a stable input source such that 5001 is always the same row when rerunning, a job parameter used in the output link constraint. Set it to default to zero and your constraint to say '@INROWNUM > JobParameterName'. When it's time to ...