DSXchange

String math functions (SADD, SSUB, SMUL, SDIV) allow unlimited precision - at least in theory - I've only tested to a million digits or so. But they are slower than using the arithmetic logic unit in the CPU (that is, doing regular arithmetic). 57 significant digits should be more than enough for mo...

Is the grid manager process running?

In summary, they will behave differently on strings such as TrimLeadingTrailing() will produce Trim() with no other arguments will produce

Welcome aboard.

If we design this for you, who would own the intellectual property rights? Would you be prepared to purchase these?

There is no job-level override. Changing EXACTNUMERIC will require regenerating .uvconfig (and restarting the engine) but won't have a deleterious effect on your jobs.

Sort in reverse order and use stage variables to remember the previous row. Effecting your change is now straightforward. Sort back to ascending order if needed.

You can't post images directly, but you can post them on an image hosting site and refer to that from here.

There may be a patch that addresses the problem in the free form editor.

This is only a guess: CurrentDate() from the functions list.

Wouldn't think so - it's not really a rule, is it? You have EXISTS and you have EXISTS n, which are rules, but how does your count fit in to a data rule?

Your data lacks the pipe delimiter following col2. Does the error message mention the row number at which this occurred? If row 0, how is the "first line is column names" property set?

chulett wrote:Never mind the fact that && is valid for UNIX, not DOS.

&& is valid for DOS.
See, for example, Conditional Execution - Conditional Execution Based on Result of Previous Command in DOS Script Snippets.

Certification test 000-303 (DataStage version 9.1) is now available.

(QualityStage and Information Analyzer certifications will follow soon.)

So, to put it another way, you want to traverse a hierarchy and return the start and end points?

OVER.30 stores overflowed groups and large records. DATA.30 stores the primary buffer of each group. As Arnd notes, both are required; the contents of both are loaded to/from memory where memory caching is used.

When I stated

ray wurlod wrote:either a ";" or a "&&" between them

I did not intend for you to put ; OR %% between the two commands. I meant you to put ; between the two commands, or to put && between the two commands. That's why the word "either" was there.