DSXchange

Simple. As noted in the message, set your Array Size value to 1. That's required when using those 'combo' actions and if you don't do it yourself, it issues the warning and changes the value at runtime for you.

I would think you should be using DSJ.PARAMVALUE for the actual value rather than the seeing what the default value is.

And your 'target' is what exactly? A flat file?

So... just to be clear... when you say a null string here, you actually mean a string with the value of "NULL", yes? What is the source data type?

Since answering my questions seems to be a problem, perhaps your official support provider can help. What advice did they have for you when you reported this problem?

I know some people who wouldn't consider any release of Oracle particularly stable.

Seems to me you are squarely in the hands of IBM and Oracle for this resolution. Let us know what you find out! I'm really curious what the culprit here is going to turn out to be.

In other words, if you ever see this question:

This directory is not set up for DataStage.
Would you like to set it up (Y/N)?

The answer should always be NO.

Aborted how? What error? Your TO_DATE syntax looks fine as long as there's a comma in there: to_date(string, 'dd-mon-yy').

The upgrade will automatically compile everything. And everything will work just as it did before unless you've taken advantage of bugs that have subsequently been fixed.

Details, please. That error is a PL/SQL / cursor error, is there a stored procedure involved here anywhere?

You'd need RTI if you wanted to expose your job as a web service or otherwise operate in an "always on" mode for "real time" updates. If you only need "near real time" and could run periodic "micro batches" or did one large daily update, then no, RTI is not required.

I agree with Ray. There's nothing stopping you from "synchronizing" any two tables regardless of structures or databases as long as you can define what that synchronization should consist of. We can't do that for you - you need to detail out for your efforts how it all will work: how to match the re...

Suggestion: Post the actual, unedited, full error. Is it a DataStage message or one from Oracle?

Advise... patience.

Using a "dsx" export rather than xml might be a little more... straight forward.