DSXchange

If you invoke the Djinn by name, he charges!

So, not interesting in answering my questions?

I never make use of the "Next Key" methodology, not liking hash files in my projects. I also minimize the use of Oracle Sequences, if possible. We store surrogate key values in an Oracle table and have built Shared Containers to access and update them in a standard fashion. The key is pulled at the ...

What are you choosing for the Import? Make sure you pick "Plugin Metadata" and then picking "OCI8". Is that what is generating this error? If so, at which step does this error occur?

I'm still really curious why someone would "need" to do this.

peternolan9 wrote:INFA invokation of SPs is easier and you have more control over them than in DS....

Probably true... until 7.5. Check out the Stored Procedure stage. Only good for Oracle right now, but other databases are coming 'real soon now'.

Exactly. Even starts counting from 1.

It's hard to say. A couple of things would help: Posting a summary of what the routine is supposed to be doing. Editing your post and added 'code' tags so the code it is more readable and maintains your indent levels. That being said, I believe that message usually means you are manipulating the arg...

No, all you can see are how many sets of key fields (ie, 'rows') were sent to the stage. Since the granularity of those deletes are totally up to you and transparent to the stage, I don't believe you can really know - unless there is a one-to-one correspondence. If your key fields uniquely identify ...

You need to use User Defined SQL.

Not sure how much help this is going to be, but grepping through my install shows this status code in the $DSHOME/gcidir/include/api_public.h header file: #define IE_SR_SLAVE_EXEC_FAIL 39204 /* The slave failed to start correctly */ I'd suggest contacting Support. One question - how are you actually...

Ahh... but you can start a job with a Transformer for the purpose of generating data. This is what the OP is doing.

Did you install NLS when you installed your DataStage server? If that optional step was not selected (and you probably had no reason to install it at the time) you won't have access to change that in DataStage. I'd double-check with Ascential Support, but my assumption is that you'd have to re-insta...

Probably better to post something like this over on ADN where Ascential folks will have a better chance of seeing it. And I agree - it would be nice to make the Aggregator just a wee bit easier to use. When you have a large number of columns, it can be quite the PITA to setup.

Interesting... I just checked my new (test) install of 7.5 Server and there's no trace of Intelligent anything out there. There is a teeny mention in the Designer's online help, an index entry for 'Intelligent Assistants'. Selecting it gives you three sub-choices: creating a job from a template crea...

As far as I know, the "Intelligent Assistants" (like for SCD jobs) are only for PX. Like with other things, Ascential likes to tease us and install bits we can't use in lowly Server jobs.

I completely forget to check my docs for you... hope to get some time soon.