DSXchange

The "different name" replaces the reserved characters with substitutes of the form __nn__ where nn is the ASCII code for the character. It's all in the manual somewhere, I don't have access to them at the moment.

Search DSXchange. This has been answered many times in the past.

The same as the purpose of the escape character in any FTP session - it provides the ability to interrupt the flow.

I disable Director auto-refresh. I believe it's purely cosmetic. You get a refresh on any page change, and when you ask for one.

9.5 is the version that installs automatically. According to the documentation this or 9.1 are the only versions you can use for XMETA.

9.7 is the "warehouse" version of DB2.

Take a look at the score to see whether tsort operators and/or buffer operators are being inserted.

Add explicit Sort stages on the input links, with sort mode set to "don't sort, already sorted" (to prevent insertion of tsort operators) and with memory boosted as high as you can afford.

A column may be declared, for example, as VARCHAR2(20 BYTES) or VARCHAR2(20 CHARACTERS). The latter takes up 60 bytes in Oracle. You can get DataStage to manage it properly if declared as VarChar(60). There is a setting in Oracle to switch the default from BYTES to CHARACTERS or vice versa, but I ca...

Check out http://www.ibm.com/support/docview.wss?uid=swg21414265 this article

Depending on the database and how it has been configured, lengths for string data types may be reported in bytes rather than in characters. You get fewer Unicode characters than you have bytes.

What lengths are reported when you import the table definition? Use these.

Please decode the DPID acronym in your context. Google does not yield anything probable. Where I am it means Delivery Point ID and is related to postal mail. Nothing to do with operating systems. You can get DPID data for QualityStage to use in conjunction with the AUAREA rule set. I'm guessing that...

24:00:00 is not valid in DB2. Only 00:00:00 through 23:59:59 are valid.

Umm... not so, because the ";" characters have become field marks, and FindStr and related statements don't include these as data values. However, a trailing "+" would do the trick.

Is there any scope to use a static variable instead?

Does anyone have any experience using DB2 version 9.7 as the Information Analyzer database?

Basically I seek to know whether (given that access is via ODBC) it works or not.

If you have installed 7.5 with the default memory key ("ade") you will need to change this. I vaguely recall that there are some scripts for doing this associated with the product. If there isn't, then you will need to re-install version 7.5 with the -itag option. You will also need to use...