DSXchange

NUL (0x00) is not the same as NULL (unknown value). It's unfortunate that the nomenclature was chosen as it was.

Not everything you read on the web is correct.

One example is that vertical pivot worked with the Pivot stage prior to version 8.5.

For only two rows I would not bother with DataStage at all.

I did give you an alternative where you could have used the Exception Handler absolutely (a downstream Routine).

The same thoughts that Arnd had just over a year ago.

Disable runtime column propagation (RCP) on the output link of this stage.

If the subject areas are distinct, you could use grep command to read the line from the file.

You could have an explicit Failure trigger on the server job's Job activity, leading (through a Sequencer) to the same stream of processing that is executed following the Exception Handler (or a modified stream).

If you have only one field, why is the error message referring to parameter 6 ?

chulett wrote:An Oracle VARCHAR2 can support up to 4000, unless the version is very old.

Yes, that's what triggered my question. We had no information about the Oracle version.

There is a property in the ORABULK stage that allows you to run sqlldr automatically or not. Make use of that property.

No, because it's out of scope by the time the Exception Handler triggers.

You could re-vamp the server job to post the error code in its user status area (perhaps in an after-job subroutine). Or you could create a Routine activity to scan the server job's log.

Ah. My last three installs have been on Windows servers.

I have certainly configured multiple 8.5 engine tiers on AIX (separate machines) using a single, shared, services tier. But it's been a while, and there was no need to investigate the itag capability then.

Try it. Let us know. There are many other variables, such as the hardware you are using. Try a third alternative where DataStage does not automatically invoke sqlldr - you can do this piece manually or in an after-job subroutine that checks that the job will finish successfully (its "interim st...