DSXchange

You don't have to copy the entire VOC file - indeed this would be bad because you would lose all the "local" entries. You only need to copy the pertinent record. First, set a pointer to the other VOC using SET.FILE command. SET.FILE projectname VOC OTHERVOC Then effect the copy. COPY FROM ...

I thought you said you'd copied dsjob executable and its dlls. Why are you using call ?

pandeesh wrote:It Looks he is getting the error:

Code: Select all

DS.TOLLS is not in your VOC

even though he executes DS.TOOLS

To use an Australian expression, "Bullshit!".

It appears that some other job is using the same state file to generate key values.

Add -domain, -user and -password options.

Pivot.
Sort (if necessary).
Count.
Pivot.

Terse.
Yes.
Like your subject.

dongyingying wrote:...so i need to loops and nest condition and sequencer

No you don't. You can create two parallel streams of processing independently in the one sequence.

Not possible.

A shared container has fixed functionality. It can not be used to write in one job and read in another.

Create two "companion" shared containers.

In a Hashed File stage you must use the entire key.

You can use a UniVerse stage if you want to use a partial key.

Assuming the string is exactly nine characters long:

DS.TOOLS is not the same as DS.TOLLS.

You need to have selected one or more stages.

You can seed the random number generator in DataStage. I'd recommend something based on time (seconds since midnight, for example), possibly multiplied by numeric date components.

Given that it's version 8.x, I'd simply use a Transformer stage upstream of the Standardization stage. Beware, however, that there are some strange individuals out there who insist on the numeric (for example "HEN3RY" is "Henry with a silent three"). They're more likely to be fou...

Check that your shared library search path (for example LD_LIBRARY_PATH) is correct.