DSXchange

FYI, if anyone is using 7.1r2 and is stuck like I was, a colleague figured it out:

Send the Oracle reject link to a Modify stage which has the specification "SQLCODE=SQLCODE". Then include a column named "SQLCODE" in the output from the Modify stage.

Hi ArndW, thanks for the quick response. Using the Transform stage is one of the many approaches I have tried. The problem I encountered with that approach is that the job would not actually abort until it completed. That's bad because if millions of records are rejecting it will take a long time to...

Using EE 7.1r2, Oracle Enterprise Stage... This seems simple, but I cannot find an answer anywhere: During an Upsert, when records are Rejected, there appears to be no built in options to abort the job. I'd like to abort it as soon as a Reject is encountered. So I created a Reject link from the Orac...

Hi děkuji, Thanks very much for you help. Unfortunately, a "sqlcode:Integer" column is not automatically being added to our Ora Ent stages when they are configured as you describe. I wonder if we're using different versions. We have 7.1r2, and I'm using the Oracle Enterprise Stage, apparen...

I am using a reject link from an Oracle Enterprise stage to capture rejects from an Upsert as you describe. I am particulary interested in the Oracle SQLCODE, but it does not seem to be "automatically" included in the reject link. Can you tell me exactly how you built your reject link? Tha...

We are receiving a compilation error that appears to be due to having outdated or incorrect libraries loaded. We are running EE 7.1r2 on SunOS 5.8. Does anyone know which may be the proper install disk to be sure we have the correct C++ libraries for 7.1r2? Or better yet, perhaps someone has encount...