DSXchange

When hashed files are empty each group is in one "buffer", the size of which is decreed by the separation parameter (static hashed files) or the GROUP.SIZE parameter (dynamic hashed files). When a group overflows, a secondary group buffer (the same size) is used. In static hashed files this is appen...

The doc_tool.mdb file is to be found with your DataStage client software in the Documentation Tool folder.
By default (for version 6) this is
C:\Program Files\Ascential\DataStage\Documentation Tool

When you say the Aggregator didn't work, what do you mean? Did it yield incorrect results, or abort?
Did you really understand what I advised?
I put together a small test case here and it worked fine.

Take the Ascential class.
It takes you through a hands-on project, as well as providing detailed information about what you're doing at each step.
Check out the Education page on the Ascential web site for your region.

When you're at the TCL prompt you must refer to the hashed file name by its name in the project's vocabulary. Usually this is the same as the entry name - that is, the name of the file in its directory. So, for example, if your hashed file is called Customers and it is in the C:\HashedFiles director...

It depends on whether you created your hashed file in a project (=account) or in a directory. If they're in a project, you can execute the commands from the TCL prompt ( > ). If they're in a directory, you'll need to include the DataStage Engine bin directory in your PATH environment variable, so th...

... and the Test grid for Routines is a great tool for doing just that!

Folks to whom I teach DataStage classes will recount how I use this technique to help get a feel for the intricacies of Oconv, for example.

Good catch, Vince.

This is an easy task for DataStage's pattern matching capabilities. You need to determine what's between "Mark" and "Jason" and then replace this with the three characters '" "' (a double quote, a space and another double quote). Use the MatchField function to get what's between "Mark" and "Jason". ...

Current timestamp in ISO8601 format is given by Oconv(Date(), "D-YMD[4,2,2]"):" ":Oconv(Time(), "MTS:") Substitute system variables @DATE and @TIME for Date() and Time() if you want "current timestamp" as at the start time for the job, in...

This has been discussed before, for example here and here.
DataStage philosophy is to log all messages; after all they are generated for some reason!

A job that populates a hashed file can take a backup before doing so. On the inputs link to a Hashed File stage there is a check box called "Backup existing file" - click on the Help button for more information. As other posters have noted, because a hashed file exists in the operating system, you c...

Sure can. Don't use DataStage BASIC (though this could be done). Use a DataStage job. SeqFile -----> Aggregator -----> SeqFile In the Aggregator stage, group by OLDPOLID and use the Last (or Max, whichever you prefer and depending on the sorting in the original file) function on NEWPOLID. This job w...

You can use the multi-value handling capabilities of DataStage. Parse the string into multiple values based on the dot characters. Apply the multi-valued equivalent of the Oconv function (Oconvs) with "MCT". Parse the value delimiters back into dots. NewString = Convert(".", @VM, OldSt...

If you have the plug-in, you have its manual. Is there anything specific in the manual you need to know more about?

See the paper Date Conversion Demystified to learn about conversion of dates using the Iconv and Oconv functions.