DSXchange

You should have been able to escape the ampersand character or quote the password in your AppServerAdmin.sh command.

The schema does not contain the field ORDER_KEY mentioned in your SQL. Perhaps you need to qualify the table name with the correct schema name.

For the DataStage administrator this script is not necessary. Follow the advice in my earlier post.

Actually I just re-read the original post. It seems to me that this is just what the SCD stage is supposed to be able to do - by caching the (dimension) table in memory.

Enable gathering of performance data and use the Performance Analyzer.

Pity your initial post didn't begin "I have a requirement...". I could have answered that!

There are very many "funny" things with the DB2 Connector. We experience erratic behaviour connecting to DB2 on a mainframe. But the DB2 Connector is very new - presumably IBM will iron out some of the faults we (the users) have reported. After all, DB2's fairly important to them!

That's true (at least at first thought). Sounds like you need to process into a working area that has been pre-loaded from target, before the final load, as you suggested. I can not think of an approach in a parallel job that would allow you to do this all at once. Curiously there IS a one-job solut...

It's always the link.

What confuses people is that they open the link properties via the Input tab in the stage properties.

In most cases, of course, you can right click the stage and open the link properties directly.

The pathname of a virtual Data Set descriptor file will be found in the score. It's usually an unqualified file name, which means that the file will be found - only while the job is running - in the project directory.

My current site performs the "expiry" updates first, and queues up the inserts. It seems not only to perform better but is also easier to unwind (from a snapshot) if the update phase fails. Since the inserts all have new surrogate keys, they can happily be bulk loaded. Database is DB2, but...

Every Palette can be customized - drag stage types from the stage types branch of the Repository.

NLS maps are guaranteed to be round-trip maps within the one map, but not between maps. You really want to look at the byte values of the result of the Iconv() function. (Use the ByteVal() function for this.)

Real UniVerse (the one now owned by Rocket Software) includes a BASE64 function. I think this was added in version 10.2 or 10.3.

I doubt that anyone outside IBM can answer that, and they won't. Any reason not to upgrade to 8.1.2 ?