DSXchange

You might do better to post this on the Parallel Extender forum.

DSP.Open is one of theirs (Ascential's). It's the "open" function exposed by plug-in stage types. With sufficient knowledge you could use a utility like VLIST to see what's being executed at address 0x4d4 in the object code but, without source, that won't help greatly. Fault type codes are listed in...

SQL figures out the relationship somehow within the query engine, so one does not need to declare the columns to be temporarily multi-valued.

Parallel

The SAS interface is aimed squarely at PX.

Hope the subject doesn't scare anyone away. Here's a useful query in RetrieVe, using generated field names and on-the-fly of field names temporarily declared to be multi-valued. I'll post the SQL equivalent tomorrow. LIST VOC 'DSR_LAST_UPDATED' ID.SUP F3 AS JOB_NAME MULTI.VALUE FMT "32L" F...

Delete or rename everything into a new location.
Then restore your entire project from backup media into exactly its original location.
That should work (at least as at the time of the last backup, and assuming that that was done correctly, with no DataStage processes happening on the server).

Basically it's not possible to call a Transform from a Routine. You can, of course, copy the Transform's derivation expression into your Routine, but then you incur the need to maintain it in two places. In your example, I think it's a pretty safe bet that PIC COMP3 isn't going to change any time so...

Also investigate the "shared" hashed file capability, where the two (or more) jobs can share the same cached hashed file, instead of setting up two (or more) cached copies of the same hashed file.

No. The row splitter "decatenates" based on the contents of a column. It does have the ability to generate multiple rows.
There is a separate manual (splitter.pdf) that describes this stage type. The Row Splitter stage can only have one output link.

6-10 seconds is about as good as it gets, though you don't have to wait for one to finish before you issue the reset request for the next. That is, lose the DSWaitForJob calls, and implement a different mechanism for checking that things are still running or not, checking the exit status once they'v...

I could have answered that but it wasn't addressed to me; my name is not "u".

("U" is a valid name, the only one of which I know is U Thant (secretary general of the UN some years back) but he is not in any position to answer this question, on a number of grounds.)

DSX usually gives a smaller export file than XML.

Since I often have to email these, that's an important consideration for me, as some of my interlocutors use dial-up connections.

Given that you're on Windows, you can use the ODBC driver for MS Excel. In this case, you must check the "system tables" box when importing the table definition (each spreadsheet in a workbook is reported as a system table). Further, the spreadsheet MUST have a tabular format and must have column he...

A poor education, or an attention deficit disorder, or a visual impairment are often manifested as slow reading ability. (That was to make the point about how vague your question was.) Diagnosis of anything in DataStage is by elimination. Start with the simplest; read and discard the results (no tra...

The Hashed File stage refers to a hashed file (a database table with special characteristics for locating records). A lookup stage refers to a dataset (an in-memory collection of data, with its own intrinsic indexing mechanism). Read the relevant chapters in the Server Job Developer's Guide and the ...