DSXchange

There is an API function and a dsjob option for writing events to the log, but neither of these allow you to tamper with existing events. I agree with the undesirability of importing logs. On the other hand, a tool that could view archived logs might be a useful thing to have (and not difficult to c...

Actually substrings() is a function available in the Transformer stage, but the substring operator ([]) will be slightly more efficient. The nth character in a string is given by string[n,1] Note, too, that substrings in the Transformer stage are 1-based, not 0-based. You also have string_trim() ava...

Is isnull() really the function you want to use, and does it really take two arguments?

With an Index() function. It searches for substrings (specify the substring - you don't need a wildcard character).

Connectors are available in server jobs.

By default $DSHOME/bin is not included in PATH in dsenv. DataStage projects know where it is (because they know where $DSHOME is). Lots of sites do include it so that they can source dsenv and then execute commands from the command line (explaining your experience), but it's not necessary for DataSt...

Not true. You have to change the Transformer stage properties explicitly to have it run in sequential mode (another way is to force the entire job to run in sequential mode, or to use a one-node configuration file). Rank is not really an ETL function - it's a display function. That said, it can be d...

Are the Dependencies tab information details in the sequence all set correctly?

The AppServerAdmin.bat -user command can be used to reset the administrative user.

Should be.

There was a browser-based Director client available in the mid 7.x releases, but they dropped this idea for no given reason.

The "A margin" in a COBOL FD is the column in which the "01" of the Level 01 items exists.

The virtual data set is created and indexed automatically (by the LUT_CreateOp operator in the score). You don't have to worry about it.

From UNIX ?!! Where do you propose to get this Windows authentication from?

Hashed files do not release space unless they are resized. The philosophy is that they will soon need that space again, so may as well hang on to it when records are deleted.

Good thought. Alas customer does not (yet) have MWB. But I'll try it myself, maybe can convert into an opportunity.