DSXchange

Sorry, but can you confirm your PX release please? 6.x?

You should also provide more details as to the structure of your job and under what circumstances you get this error.

Your script is working fine, hence the 0. You need to add extra logic to detect the sqlldr failure and propogate that, typically by grepping the log for ORA errors and checking to see if a "bad" file was created.

As noted, there is more to it than simply checking a box. You have to strucuture the job such that it functions properly under MI control. For example, objects like sequential and hashed files can need unique names, typically incorporating the invocation id, in order to ensure one instance doesn't s...

And? From what I recall, this is an acknowledged bug so not sure you can do anything to fix it, per se. Can you 'work around' the issue by considering a Finished with Warnings result as ok?

Bring the issue up with your official support provider, perhaps there is a patch available.

Search the forums for "square root of a negative number", it's been reported a number times.

Depends on your mail server, so there isn't a 'one size fits all' answer.

There's more to it than just turning it on. What have you done to make the jobs 'multi-instance'?

rjhcc wrote:I wondered about the claim of dsenv not being a place to tune and was glad to see the reply stating that it is. It contains disk cache, memory, and file handling parameters among others.

No, it doesn't. As noted earlier, you are confusing dsenv with uvconfig.

Bit surprised to find one in a 10g DB as they have been 'obsolete' for quite some time. Haven't tried casting one, you could certainly give that a shot.

Welcome. :D

Short answer - a LONG is not supported, never has been. They are a PITA in any tool, why not use a CLOB instead nowadays?

Or simply leave it blank to mean the 'current project'. More details about your 'need' would help get you more answers.

The trouble is, I want to use this routine in a transform to then output the results which I can split into the relevant fields and load it to a database. But I seem to be having problems as I only seem to be able to output one row when I use the "Field (string, delimiter, instance [ ,number] )" fu...

this is the first time i am working with oracle Still not really clear - the first time you personally are working with Oracle wasn't the question, if that's what you meant. We want to know if this is the first time anyone has done anything with Oracle in DataStage. Trying to determine if it has be...

Perhaps you should post your syntax?

That error seems to indicate your database isn't setup with logging and thus does not support transactions. At least that's what Google says.