DSXchange

The resize command is available from the operating system. Its executable is in the DataStage Engine's bin directory.

I believe hash_help is also available from the operating system, but will have to check after the weekend.

From your description it sounds like a problem in the client. Did all client PCs manifest this behaviour? Did re-booting the client (which you probably should have tried first) fix the problem? Did you minimize all windows on the client machine to see if there is a hidden DataStage client window (su...

There are two or three separate kinds of caching: private link caching, shared caching (it's this that's enabled in uvconfig) and public link caching (from version 6.0 onwards). Read the Hashed Stage Disk Cache technical bulletin (dsdskche.pdf in the DataStage manuals set) to get an understanding of...

but since this file is in this format even i cannot read it becoz it is giving errors like this and job gets failed controlDfile..Sequential_File_0.DSLink40: nls_read_delimited() - row 1, column Field003 Within the Sequential File stage on the Columns grid there is scope for setting "missing column...

Isn't the CFF stage limited to a single OCCURS?

Are you extracting from SAP R/3 or loading into SAP BW (or both)? I have no experience working with SAP from Parallel jobs; hopefully someone else will be able to answer. Certainly the SAP Extract PACK and SAP Load PACK are for use with server jobs. Without them you have to negotiate your own way ar...

Is it possible to manage this through environment variables? The job parameter can access an environment variable. Just a thought.

Morney, at least, seems to have major issues. See today's post from Morney for example.

Server-side tracing (the one turned on in the Administrator or via the DS.TOOLS menu) captures everything that occurs on the server, including servicing DataStage clients. Its trace files can grow very large, very fast. Server-side trace files are stored in the &COMO& directory in the project and ar...

You should not need any difference to the logic, except where explicit character comparisons (including sorting) is being performed. There are NLS character maps at the boundaries between DataStage and all external data sources so, provided you get these correct, everything inside DataStage should b...

Mandy's code can be implemented either in job control (in a server job), or in a Routine, preferably of before/after genre. It can not be implemented directly in a parallel job. Typically you run the parallel job, then use this kind of processing from job control (or through a Routine Activity in a ...

What's the format of the target which, because of "their" requirement, I am assuming is a text file? You don't need to write any BASIC for the header row. You could use ExecSH as the before-job subroutine, to execute a command such as echo H`date +"%Y%m%d"` > #FileName# where #FileName# is...

The obvious ones. The DataStage RPC daemon listens on port number 31538 for connection requests from DataStage clients. If this daemon (dsprcd) is not running, there is no way you will be able to connect. Use ps -ef | grep dsrpcd | grep -v grep to find out. If dsrpcd is running on the server, then c...

On the topic of using private messages or private email (I was also sent one) please read this item from the February 2004 Newsletter.

Welcome aboard! :D How you create multi-valued columns depends on how you create the hashed file. If you're using a Hashed File or UV stage to create the hashed file, specify M in the Type column in the Columns grid. If you're using a CREATE TABLE statement, you specify that the column is MULTIVALUE...