DSXchange

2) It's only time shifting in any case. Using MINIMUM.MODULUS you take the hit (of allocating disk space) up front. Using defaults you take the hit as the hashed file grows. With static hashed files you are obliged to take the hit up front. 3) The whole point of dynamic hashed files is that you don'...

1. You will retain existing server job functionality exactly as it is. Enterprise Edition gives you additional (parallel job) functionality. The two co-exist and do not, generally speaking, overlap. 2. No. You make a cogent decision as to which jobs will benefit from a parallel execution model, prim...

Maube it's the right approach if you're being paid by the hour!

Header date was not in your original specification. My original solution is inappropriate for the new specification. You are being too complex. In particular you don't need any Sort stage and you only need one Transformer. SeqFile1 -----> Transformer -----> Aggregator -----> Join -----> Target | Seq...

The format of the files in rule sets does not change. And they're text files, so you can compare them with just about any tool. I don't believe the content of the "out of the box" rule sets changes between 7.0 and 7.5 either except, of course, for the postal certification rules (CASS, SERP). So you ...

You provide your exact code. We will comment upon it.

What do you know of the MultiValue model (sometimes called non first normal form) for database design? DataStage hashed files (which is how UV tables are implemented) are based on this model; it can contain record types in which other tables (for example collections) can be nested. These can be retr...

1) Use 32-bit unless there is danger that the hashed file will near/exceed 2GB. 2) There IS an overflow file - it's tacked onto the end of the non-overflow part, all in one physical file. Speed of creation will be the same as creating a dynamic hashed file with MINIMUM.MODULUS set to the same figure...

Run the data through a Sort stage, and get the Sort stage to create a key change column. In a downstream Transformer stage, the key change column will identify the beginning of each group - that is, of each set of duplicates. Constrain on the key change column - where it is reset (0) you have a dupl...

There is no APT_JOB_MONITOR environment variable. You may be confusing it with APT_NO_JOBMON, which disables gathering of statistics.

Research the following statements in the on-line Help or in the DataStage BASIC manual:
OPEN
RECORDLOCKU
READU
WRITE
RELEASE
CLOSE

That should get you close.

There is nothing, in this scenario, to prevent one job from clearing the hashed file while the other job (on the other server) is attempting to read from it. Don't update/clear hashed files on network drives. Don't even PUT hashed files on network drives. UniVerse can manage locking across the netwo...

It's probably fair to say that U doesn't want to.

asitagrawal posted the original question.

The correct spelling of the second person personal pronoun is "you".

They're stored in a database.
They're not stored in a folder structure.
The database varies at different versions of the product.
In short, no.
The vendor has chosen not to publish this information.

Yes and yes.