DSXchange

Is this consistent across all users or is this something specific to you?

Ah... ok, thanks for the clarification. I guess I just went off on a tangent with the two responses I linked to above, especially the first one where it seemed like just doing work in the Administrator could have resolved the problem. The last paragraph seemed to imply that as well... the Administra...

A couple of recent posts by Ray, like this one and another one about Lance's ghost project have bot me thinking... and I'm wondering what exactly is (and is not) stored in the XMETA repository. :? For whatever reason, I've been under the impression that it was an extra crispy RDBMS model of the comp...

hey chulett sorry i have pasted the view data error in earlier post. when i am running the job here is the error get generated APT_CombinedOperatorController,0: Failure during execution of operator logic. APT_CombinedOperatorController,0: Fatal Error: Fatal: This SQL statement did not contain the s...

Yup, from your linked post it sounds like it is indeed an (gasp!) Oracle bug. At least there's a patch for it. Good luck.

And now it shows your status as a Premium Member... can you see everything?

So, what's wrong with using the auto-generated sql?

Yes. Search the forums for DEFFUN for the syntax.

Mark, you might want to double-check on your Premium Membership status as it doesn't show you as one - there's an indicator by your name on every post that should show that and it's missing from yours.

Jeez, help yourself ASAP - search the forums here for that message. It's not like you're the first one to ask this particular question.

Have you involved your official support provider yet? Asked them?

I would make sure it matches exactly. If you have problems, you could use a stable 9i client like 9.2.0.6 or 9.2.0.8 instead to access 10g. I have without issue.

Kind of sounds like your 'patch level' means you have no patches. Plus there's an 8.1.1. First thing I would do is double-check with your official support provider and see if you need any.

Then triple check the exact version of the Oracle client installed on the DataStage server in both environments.

Use the name of the column or table the sequence is for in the call: KeyMgtGetNextValue(cust_id, KeyMgtGetNextValue(merchant_id), etc. Or if needed, use "table.column" so that it a unique key and doesn't mix with any other table's value.