DSXchange

Could be lots of things. For example (and I'm not claiming you're doing this), a large database-transfer array size means that that array has to be built in memory. Aggreagtor stages with unsorted input and Sort stages can also exhibit gradually increasing demand for memory. Have you isolated the pr...

RTI is a special set of stage types that listen on IPC mechanisms.

An RTI-enabled job includes these stage types, runs continuously in one or more instances. The RTI Input stage is effectively the listener, while the RTI Output stage sends stuff out.

Nah.

"Websphere" is just a catch-all for middleware products.

"DB2" is an IBM catch-all for database products, including UniVerse, UniData, Red Brick, Informix, Cloudscape and, yes, DB2.

It's an IBM thing. They don't want their sales dudes to have to remember too many things.

Deleted. Discarded. Freed.

Rubbish

You can use any extant "UniVerse" file that has a file dictionary defined.

It (a Transformer stage) won't even attempt a lookup if the reference key value is null, so there's no way you could claim that it succeeds. OK, it returns NULL, but that's the documented behaviour when the lookup fails or is not attempted.

Not possible using a Hashed File stage. This uses the primary key, the whole primary key, and nothing but the primary key.

How would you do it if one table were Oracle and the other DB2? You can do the same with anything and a hashed file, if you access the hashed file via a UV stage.

All that's in a state of flux right now. All of the Ascential suite tools integrate with each other to give you a full EAI environment. You can also, for example, work with data from/to MQ Series queues (there is a stage type in DataStage for connecting to these). Thus far (remember that IBM only ac...

In earlier versions (DataStage 4.1 and earlier, IIRC) a zero-length string was not permitted as a key value in a hashed file. Since then it has been, and can be looked up successfully. "" and " " are different and would be separate key values. It remains the case that @NULL is illegal as a primary k...

I had posted this earlier, but in the ADN downloads area as a DSX file. A few people report that they don't have ADN access and would like it here. It shows the full drama that you should go through when opening a text file. The code is good with any version of DataStage from 1.0 through 8.7. FUNCTI...

Only through job parameter. The ODBC stage will not compile unless there is something in the DSN property.

Len(@NULL) returns 0. This may simplify your expression.

(1) No. It's a tool that can be used within a BPA environment, but it's definitely not the whole deal. DataStage can move data from point A to point B and transform the data on the way through. That's its purpose, that's what it does. (2) No. It's a tool that can be used within an EAI environment, b...

Use a Stored Procedure stage.

Rows/second is a meaningless indicator. How big is a row? You could create a job that moved four-byte rows, and you'd get thousands per seconds. Try to use a metric like MB/minute. Secondly, you have to compare apples with apples. Comparisons between identical condfigurations are valid. But no-one i...