DSXchange

Kim, You missed the point. The RecordLockU statement in my code locks the new record ID, the one that I'm about to create. The ReadU statement locks the old record ID, the one that I'm about to delete. RecordLockU is to be preferred to ReadU in this case because it does not generate any I/O to deter...

The answer changes to yes at DS 7.0!
Although the manual specifies no for MPP at release 6.x, at least one person at Ascential claims to have it working, in another thread in this forum.

Sometimes just the DS RPC service fails to start.
You can stop and start the individual services by choosing the Services applet within Control Panel (you may need to drill down into Administrative Tools to find it - its icon is a pair of meshed cog wheels).

The RecordLockU is on the yet-to-be-created record.
The ReadU is on the existing record.

LOCKED clauses were deliberately omitted, as noted in my post.

Make sure that the NLS map you use in DataStage, the language environment variable(s) you use in the Oracle client setup and, possibly, the LANG environment variable, all coincide (or, at least, are compatible).

LOCATE is fine up to a point, and better if the searchable array is kept sorted. But for very large lists (say more than about 100KB's worth), a hashed file of the (upper-cased) words, and Upcase(SearchWord) as the reference key expression, will be even more efficient.

There are quite a few ways, probably the easiest is to do it in code (either a before/after subroutine or a job control routine). You could also do it using a Folder stage. To generate the date there are again many options (look in the Routines and Transforms, particularly the SDK). However, ultimat...

This is answered in the Parallel Extender forum on this site. In short, it seems that your C++ compiler is either missing or cannot be found.

Here's another approach, provided there are no job parameters in the SQL. Execute both/all SQL statements from your Administrator client Command window. Then select them and Save. (The selected SQL statements will be saved as a "paragraph" in the VOC file of the project. You will be prompted for the...

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding. If you guys think you need to learn DataStage TX does that mean I'll have to get familiar with the other DataStage products? Jan I think it's more that ...

DataStage does not expose the encyption algorithm it uses for encrypted parameters. Nor does it provide any inbuilt encryption functionality. You have to add your own. You can access this by various means, such as a Routine invoking a C function. None of the means is straightforward, which is only t...

In INTEGRITY you must use Stage only when first using a project. That is, it's not automatic. After that it's OK to Stage and Run. Haven't installed QS7 yet, but can't imagine it's much different on this.

There's nothing I know of in the Pivot stage itself. After all, the purpose of the stage is to pivot, not to constrain. That would be a much more complex design (of the stage)!

(singing) It ain't necessarily so!

Can you do the same task using text files as source? This will isolate whether it's in the Pivot stage or not. If nothing else it will convince you that the Pivot stage works OK!