DSXchange

Set array size to 1 is the safest when multiple instances are running, and set rows/transaction to 1 also. That way you will not experience lock (or deadlock) problems.

Are you (the executing user - the user ID used to connect to Oracle) the owner of this particular sequence? You may need to qualify the sequence name with its owner's identity.

How?

Etiquette Note
When we resolve an issue, and mark the thread as Resolved, the convention here is to post a final piece showing the solution.

ALL of the date conversion functions allow you to specify the date format string. You can convert one format from a string to a date, and convert that date to a differently formatted string. In a Transformer stage your most likely candidates are TimestampToString() and StringToTimestamp() functions.

In a Transformer stage the equivalent function is NullToValue(). When the lookup fails and the rule is Continue, you get a genuine NULL on the output. If the field is non-nullable you also get a warning, and that field will take its default value, which you can set (for example to -3) in the metadat...

You could download my date arithmetic routines - just heed the conditions of use on the General tab.

Welcome aboard. Can you please expand on this?

... and you can expect a LOT more acronyms as you research further! Find yourself a good acronym-decoding web site such as this one at IBM. Though, curiously, WISD and RTI don't appear there. Ernie - one for you to follow up?

DSXchange has a whole forum devoted to RTI (now called the SOA edition). Try posting your question there. Ignoring DataStage for the moment, do you know what a web service is, in the more general sense? If not, I strongly advise that you find out before pursuing your DataStage-specific question, as ...

The Operator role can only run released jobs. I'm prepared to bet you have none of these.

The Super Operator role has been introduced at version 8.0 to allow running of all runnable jobs.

1. No. Sequential files (text files) do not have data types, only text. Therefore they can not store NULL "as is". They can only store whatever the metadata specifies to be the representation of NULL. 2. If the file is a delimited format, there is a global property in the stage for the representatio...

If you are converting to string it can convert format also.

Your understanding is correct. This is why one of the troubleshooting tools ("compile in trace mode") has an option to force every stage to execute in sequential mode; by doing so you can eliminate any problems caused by inappropriate partitioning while you fix the other problems. And then you can r...

You will find at least one Bourne shell script (or BAT file if on a Windows platform) that is responsible for running the osh executable, which gives the Orchestrate shell for executing *.osh files. Search your manuals for "generated OSH". Also obtain a set of Orchestrate manuals from your support p...

Upgrading from server to enterprise is simply licensing the parallel job capability. However, as noted, you do require a compatible C++ compiler if you want to use Transformer or Build stages. The jobs themselves will remain server jobs. There is no automatic upgrade; parallel jobs are radically dif...