DSXchange

You must have NLS installed and enabled. You must be aware of how the Japanese characters are encoded - there are at least fifteen different ways. This map (for example one of the SHIFT-JIS maps) must have been loaded - use the Administrator client to get maps loaded. Then you set this map on the st...

The Columns grid has numbers in every stage!

Ah. So we await Mr Morris's return.

Can't open dictionary suggests that job number 862 has been incompletely deleted. If this is not the case, please post the results of the following command issued from TCL:

T30FILE setting is irrelevant; it relates only to hashed files.

What are the data types of RCT.TRX_NUMBER and RC.LAST_UPDATE_DATE in the Oracle table, as reported by DESCRIBE ?

Is this really a Cartesian product, or have you not posted the WHERE clause that joins the two tables?

sqlldr is an Oracle utility. You set up the Oracle utility on the DataStage server machine, but not "within" DataStage.

DataStage can invoke sqlldr through its command line or via the ORAOCIBL or ORABULK stage types.

Welcome aboard. :D The answer is no. Decimal always reserves space in the string for the leading sign and the decimal placeholder character. The most efficient algorithm for removing them is conversion to string, then using Convert() to remove the space and dot. Just make sure you're not doing this ...

Transport blocks apply only for fixed-length records and only between player processes. I guess by the time you're in a virtual Data Set you effectively do have fixed-length records, because bounded VarChar is stored as prefix bytes and full allocation of character space.

DB2 Connect is DB2 client software, not part of DataStage. The line in dsenv will depend on where you have installed DB2 Connect; essentially you need its bin directory in your PATH and its lib32 directory in your LD_LIBRARY_PATH (though after $APT_ORCHHOME/lib). Questions 4 through 7 relate to sett...

Short of modifying the JCL template, I don't believe so.

Server job Transformer uses server routines.
Parallel job Transformer uses parallel routines.

Create parallel routines and they will appear in the Expression Editor.

Padding of CHAR fielsd uses the character specified by APT_STRING_PADCHAR, which is \000 by default.

Stop overloading the server machine.

When it occurs, reset the job in Director then read (and post) the "from previous run" message. Also read (and post) the detail of the error message itself.

DataStage will request what memory it needs. In general data are not held in memory, but streamed through the job. Exceptions include blocking stages, such as the Aggregator and Sort stages. If the requested (virtual) memory can not all be allocated, then you are likely to receive a "heap allocation...

Just spell out the rule in English. A year is a leap year if the year number is divisible by 4 except if (the year number is divisible by 100 but not by 400). Hence 2000 was a leap year but 1900 was not. The Mod() function is the easiest way to determine exact divisibility; it returns 0 in this case...