DSXchange

Identify the second column of the lookup Data Set as key. Make your "lookup failed" rule Continue.

Not unless you show exactly how you used the FIELD function. I can't read your mind and am not prepared to waste time guessing what you might have done.

The only way to install NLS is to go through the server installation process again.

The percentages can be rounded, but the counts ought to be correct. The only think I can think of is what Ashok has already highlighted, that there are NULL values. But I've usually found that even these are counted correctly.

... and we DON'T double-post, and we DON'T post on inappropriate forum (this one is about suggestions for improving DSXchange). Consider yourself castigated.

Welcome aboard. :D Re-read the thread from the top, where the original line had ten columns of which the final two delimited fields specified what should occur in the output. Your question substitutes four for ten and can be solved in exactly the same ways. Not even any requirement to change the rou...

... but a Modify stage is lower impact and therefore likely to be more efficient than a Transformer stage

Yes. Read the chapter on configuration files in the Manager manual, particularly the sections on resources. Data Sets are automatically partitioned across all the processing nodes in the configuration, unless explicitly constrained into a node pool or a disk resource pool by means of stage properties.

Yes, if you're worried about less than a millisecond in an entire job run. When a routine is first called (for row #1) it has to be found in the Catalog and loaded into memory. After that its exectuable code is in memory and its entrypoint address is cached. The down side is that, if the definition ...

On the other hand, I would be happy to be engaged to read the manuals on your behalf. A word of warning, though, I charge substantially more than the US$38/hour postulated elsewhere.

How To Write Routine (server routine) Start with a specification of what you want to achieve. The specification is written in normal language, for example English. Formalize the input arguments needed; seek opportunities to make a more flexible reusable component. Determine whether your need is a b...

WRITESEQF guarantees an immediate flush. There's also a FLUSH statement, and you can use the NOBUF statement to make I/O to this particular file non-buffered. You can certainly treat the file as a dynamic array but, to do this, you must open its parent directory with OPENPATH then read the entire fi...

UniVerse actually supports eight levels of nesting. Can you think or even imagine in eight dimensions? One simplistic explanation I like is that, in these non first normal form databases, you can have a cell with a "data type" of "table". Unless you've got such nested data, don't worry about it. If ...

The default configuration is the one you see as "default" in the configuration file viewer/editor in Manager client.

MFILES is best sized as large as possible, subject to the restriction that you don't exceed the UNIX limit (NFILE) and reserve eight file units. That is, MFILES <= NFILE - 8 It doesn't really matter what it is you're opening. For UniVerse, you also reserve a file unit per UV/Net connection and one f...