DSXchange

What's the block size?

Is your job discarding / dropping any records?

Yes. In a server job.

The syntax is good, provided both servers are in the same domain. Though you really should use a -domain option to specify the services tier in any case. The example below assumes this is the same as the name of the server (Engine) machine. dsjob -run -domain SERVER1 -server SERVER1 -user USER -pass...

DataStage is an ETL tool, not a database client tool.

You can't run dynamic SQL in database client tools anyway - they're executed on the database server.

What you seek to do can not be done with DataStage.

Names are case sensitive. "DS.TOOLS" is not the same as "ds.tools".

Repartitioning in an SMP environment is effectively cost-free, since it's all done through shared memory. It's where there's more than one fastname in the configuration file that the costs kick in - TCP connections have to be established between producer and consumer player processes and data transf...

These are options to the "UniVerse" COPY command. OVERWRITING means that, if a record with this identity already exists, it is destructively overwritten. SQUAWK is a keyword that specifies that you want the COPY command to report what it has done. A synonym is REPORTING (but don't you find...

The leading zeroes aren't really there in the data. They are added by the export operator. You can't lose them unless the data type is VarChar.

Is the hashed file created in the project or in another directory? Please advise the pathname of the hashed file if the second situation obtains.

cd doesn't have any output, so using a pipe on that output causes find to read nothing.

You probably meant to use ; or && rather than |.

Vertical pivot techniques have been discussed many times on DSXchange, as a Search would reveal.

If you have a reasonably recent version of DataStage, the PXPivot stage is capable of performing a vertical pivot.

What's not clear?

Suddenly you're using ED ? The correct syntax to edit the ProcKeyLookup entry in VOC would be ED VOC ProcKeyLookup No OVERWRITING (that's for COPY), no trailing semi-colon (ED is not SQL). But what are you trying to accomplish? How about you answer all my questions first, before getting dangerous us...

BMSK wrote:I can't use the Universe stage.

Why not?
A UniVerse table IS a hashed file.