DSXchange

Make sure also that Oracle 32-bit libraries appear (before Oracle 64-bit libraries if these are also needed) in your shared library search path for DataStage processes.

Note all that this CONVERT() function is SQL, not the DataStage function.

And, in passing, NLS uses a completely different mechanism in parallel jobs from that used in server jobs.

Do an exact search for "less than the number of input datasets". You are not the first to see this.

U can pass parameters in UserVariable Actvity. I'm sure U will be happy to know that, next time he logs in to DSXchange. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, not least ...

(Auto) does give "Hash" on inputs to those stage types that require key-based partitioning.

Therefore I say again, (Auto) will always work.

Again, this may be sub-optimal. Modulus may be more appropriate (it is more efficient, but requires a single integer key column).

Don't you need a double semi-colon between multiple commands?

Search for SPINTRIES and SPINSLEEP also. Your processor may be too fast for its own good.

You can't have a link inside a Sequencer, you can only have links attached to a Sequencer. I think the word you wanted was "Sequence".

You have to invent your own naming conventions; no-one will impose any.

If you disable NLS, why do you expect an NLS conversion to work? What do you mean by "does not work" anyway? Conversion to a different character set is not the intention of NLS maps. They are to convert externally-coded character sets into or from the internal encoding (a special variant o...

Check the name of the driver, check that it is in your shared library search list. Search DSXchange for "specified driver could not be loaded".

Auto will always work. Somewhere else on DSXchange I have posted a list of what you get in various situations.

Auto may not, however, be optimal in all cases, particularly where it sets Entire as the algorithm on a reference input to a Lookup stage in a multi-machine environment.

nirav.parikh wrote:In server jobs we could have done it using output as Folder Stage. wonder what's the equivalent for Parellel jobs.

Don't hijack the thread - your question is not directly related to that of this thread. Start a new thread.

Try checking the box that says "show errors only".

The message is telling you that it is unable to INSERT.

Check your update action property.

Ignore "phantom", that's just another word for a background process. Your errors are on mutex locks, probably timing out while waiting. You should find solutions by searching DSXchange.