DSXchange

You could extend the Chinese rule sets so that they handle English as well as Chinese representations; you could create an entirely separate rule set (Chinglish?).

Can you find this process in Task Manager processes? It might be process number 3848 (that is, 65536 - 61688, since DataStage uses negative numbers to represent background processes but reports them as uint32).

PTERM CASE INVERT as a default stems from the early days if UniVerse (and precursor products) when the input device was a teletypewriter that only had upper case; this default recognizes the fact that most components are named in all upper case because of this historical artifact. You can institute ...

There should be an OFFSET column in your time dimension table.

Setting the project default map to NONE gets close to "disabling" NLS in the project.

Umm... DataStage NLS Guide?

That's precisely what the query on UV_SCHEMA does in the code.

Try this Oconv(ICONV(In.Date[1,10],"D-MY(2,2,4)"),"Y-MD(4,2,2)"):Right(In.Date,9) Almost, but not quite (and therefore wrong). You left the day specifications out of Iconv and Oconv arguments. Oconv(Iconv(Left(In.Date,10), "DDMY"), "D-YMD[4,2,2]") : Right(In....

Why do you claim that 61688 is "locking 62560"? The device and inode number will tell you which "file" the locks are on. 61688 holds a RD group lock only, while 62560 holds a WR group lock and a shared (RL) record lock on item "RT_CONFIG449" (which lock is also owned by...

Sort stage (not performing a unique sort) does not drop records. How are you handling nulls in the sort keys?

One job (a server job is best for processing one row) to query the table and park the value into the job's user status area. In the calling sequence the user status area can be interrogated as an activity variable in any downstream activity.

Can you enclose your examples in Code tags? It's not clear what's going on when the HTML browser minimizes multiple space characters.

With a little care where YY is "98" or "99".

What (environment variable) settings do you have to govern precision of intermediate results in decimal calculations?

When reading from an RDBMS DataStage has two possibilities. For a Table read, the database server returns a null indicator only, which DataStage converts to its own internal representation (@NULL, if you like). For an SQL query the database server converts the null into a zero-length string, or perh...