DSXchange

Well, certainly in 8.5, the oldest version to which I currently have access.

Welcome aboard.

The project may not be synchronized with XMETA. Investigate the SyncProject command (part of ISALite).

All versions of DataStage. The Data Direct drivers have their own versioning.

An ODBC driver (on UNIX) for SQL Server ships with DataStage. It's OEM from Data Direct.

Sometimes I answer the unasked question. Unknown unknowns, and all that...

Involve your DBA, because it may be that more Oracle listeners need to be configured.

The answer to this one has to be "it depends". If you could indicate what kind of "complex derivation" you have in mind, then we could perhaps be more specific. If there's one best practice for avoiding errors in expression construction, it would be to use the Expression Editor a...

Stop and start the engine, which forces the dsrpcd process to re-read the dsenv file. All child processes that it creates (i.e. requests from clients) will then carry the new values into their shells.

Don't enable RCP.

Then the umask setting for the credentialled user may be incorrect; your job may have been able to create the file but not to write to the newly-created file. Check the permissions on the newly-created file.

Also, by default, they are in each user's home directory.

Try this. Oconv(Date() - Mod(Date(),7), "DYMD[4,2,2]" : @VM : "MCN") The internal format of the date is an integer. Assuming your system is set up with Sunday = 0, the first argument of the Oconv() function above will give the date of the most recent Sunday. If your system is set...

Given that the Lookup stage loads its reference data set into memory and indexes it before any rows are processed you're not going to get much more efficient than that. If the reference data don't change all that often you could look at loading them into a Lookup File Set, thereby pre-building the i...

Basically you need to ascertain what kind of characters they are (Traditional or Simplified) and then how they are encoded. Set the NLS map appropriately for that encoding in the Sequential File stage (and make sure that the Unicode extension is set for string data types).

The list_readu command only shows connected DataStage clients.