DSXchange

Unless someone can tell me it's smart enough to only allocate as much of that as it needs based on hash size, up to that as a maximum. I am (obviously) under the impression that it doesn't work that way. The manual (dsdskche.pdf) is silent on this question, or I need to read it more carefully. Migh...

You can use that expression directly in a Modify stage.

If you're really careful, you can export from one project, perform a global search-and-replace on the export file, and import into the other project.

Also fewer jobs in the project. If you have thousands of jobs, consider splitting into two or three projects. Archive and remove any "practice" jobs that will never be used again. Fewer simultaneously-connected developers would help, too. Fewer simultaneously-running jobs would help, too. Not using ...

You could have used the Debugger here.
Set a breakpoint on the input link, and edit the breakpoint expression to something like

Use DB2 stage or ODBC stage. Use ODBC stage to take advantage of the multi-row return capability. Use user-defined SQL. Define one key column. Use BETWEEN; it's perfectly legal, and does exactly the same work as what you are proposing. If you want to use separate >= and <= operators, you must define...

The answer is that it cannot be done. There is no command line interface for the Documentation Tool. Export to the other database must be done through Manager. Once the export's been done, the results are in the other database and you can open that directly. For example, if you are using the default...

MetaStage doesn't have a nice Web front end, though the two views that can be brought into a browser are getting close. Problem is, that's OK for an intranet - what are the issues with the internet? RedBack is a separate IBM product for managing Web connections to UniVerse and UniData databases. Rea...

Trim(Arg1) removes leading, trailing and redundant (multiple) white space within the string, leaving single white space. The most efficient way to remove all space characters is Convert(" ", "", InLink.TheString) However, this trims only space characters, whereas Trim() r...

My choice would be RedBack. This sits on both sides of the firewall, managing potentially many web-side connections with many fewer database connections. RedBack works with UniVerse. It should work with DataStage, though its BASIC programs would need to be recompiled under DS. Since all are now owne...

The (server) job runs in one process. This executes a BASIC program called DSD.RUN. Variables opened into COMMON in a before-job subroutine are accessible - provided the same COMMON declaration exists - in an after-job subroutine for the same job. A Transformer stage runs in a separate process. This...

Keep the Property Browser window open!

Welcome aboard! :D In the menu at the top of this screen is a Search capability. You should be able to find answers among the more than 50000 posted already. One suggestion is to open Director, disable display of Categories, and set a Filter so that only Fatals are displayed. Ctrl-T to open the Filt...

A sequential file is an operating system file. It's size limit is determined by the operating system (and your ulimit setting on UNIX). A File Set is a construction of one or more operating system files per processing node, each of which may be no more than 2GB. You can have up to 1000 files per pro...

I strongly advocate using Data Elements to document some business rules. For example a Data Element called Telephone number carries all the information about a telephone number. In Australia this is quite short; the first two digits of a ten digit number are the area code or 04, which indicates a mo...