DSXchange

Anybody can guide me to calculate storage required for working files? What to consider for calculating disk space required for staging, temp, hash, reject files etc. I also want to know space requrements for each project. Please send back any questions, if my inquiry is not clear. How long is a pie...

Welcome aboard. They were originally separate products (Ascential's DataStage server and Torrent's Orchestrate parallel execution environment) and are radically different architectures. Much could be written about each architecture and almost no overlap would occur. Is there anything specific you ar...

I believe its just an interlude to the system function getenv().

Is H:\ a network drive? I don't believe it's possible to use mkdbfile to create a hashed file on a network drive.
I'm also a little concerned about how there is a double "\" in the pathname.

The row from the input link plus an extra column called sqlcode.

Have you thought about creating a separate index on each key column?

The jobs write to CSV files. You open these with Excel. Voila!

For efficiency you might evaluate FMT(L1.ORG_NM,"25T") once in a stage variable rather than three times in expressions.

One (at least) needs to be an "-itag" installation.

Taking the ELSE clause with Status() returning 0 indicates that the file is opened for writing, but does not exist. Check that /projectds/Operator/files/File_Special.txt exists, that components in the path are correctly spelled and cased, and that the executing user has sufficient rights to access t...

UniChar(x) returns the character whose Unicode code point is x. You use it in a Transformer stage expression.

By the time they get into DataStage, they have been mapped to Unicode code points. You may need, therefore, to use the UniChar() function to specify the character from which to convert.

We keep advising you to use sorted data. 30 million rows is not too many. Even a UNIX sort can manage this many. The Aggregator stage with unsorted input will almost always abort with this much data, but will not with sorted input.

In version 7.5 and earlier the Surrogate Key Generator supports up to uint32 - that is, a 10-digit key. You can satisfy yourself that this is so by inspecting the stage type properties. In version 8.0 there is support for uint64 in the Surrogate Key Generator stage. Row Generator stage works in sequ...

With presorted data you won't need big buffers.