DSXchange

Surely user-defined SQL can issue a CALL (or EXEC) statement?

Yes, right click in the background and enable "Show Performance Statistics". There is also a menu option available.

1. Each stage (conceptually at least) becomes a separate process so that there is, in general, no way for a transaction to span multiple stages. However, the Distributed Transaction Stage does allow a transaction to span multiple links. 2. There is no configurable connection pooling in DataStage. If...

Yes. Once you have your premium membership you will be able to join them.

Not obsolete. Some functionality (such as Connectors) will find its way into server jobs. But the server job architecture does not warrant the "one task, one stage type" functionality of parallel jobs. Rather, server jobs tend to use the Transformer stage as the workhorse.

Ignore your client requirement. Develop it in DataStage. When compiled this will generate an osh script that is run when the job is run. The client's requirement is now met.

Use a Column Generator stage to generate three new fields, which contain the month name abbreviations. Pivot these into "Month_Name" field as well as pivoting the monthly value columns.

If the Transformer stage is running in sequential mode, then the constraint @INROWNUM > 1 will do it for you.

DataStage clients make a connection to the engine tier using a proprietary protocol called DSObjects, which uses TCP port number 31538 by default.

You have a problem with the Connector Access Service. You need to involve your official support provider, who will guide you through gathering all the log information needed to diagnose this problem. While you are awaiting their callback, you might like to learn about the "Must Gather" req...

This is not an Information Analyzer question then?

Welcome aboard. You have posted in the incorrect forum - this forum is for Information Analyzer questions. The answer to your question will depend on how you are requesting the run of the DataStage job - through Director, through a job sequence, through a command line interface, or by some other mea...

Search DSXchange for APT_STRING_PADCHAR environment variable.

The character is not special, it's the value of that environment variable, by default 0x00 (the ASCII NUL byte).

... except that Convert() will also remove any single '|' characters too.

No. But there are C++ functions that are similar or even functionally identical to some of them.