DSXchange

Not in so few words. You have to struggle through the verbiage, but it's there.

I understand that routines can only have a single return value. That may prove limiting.

Of course you could "adjust" your code so that the two return values are returned as a delimited string, and unpack them after the routine returns.

Do you have this port number blocked with firewall software?

Attention to detail is one of the principal characteristics necessary in a DataStage developer.

It would appear that two jobs have generated the same pipe filename. This is odd, as the numeric component should be the process ID. But, if you are using an O/S with large pids and the name only uses the rightmost six characters, I guess there's a chance of this happening. Involve your support prov...

Please check that the components of the table name are being spelled correctly in the SQL that DataStage sends - the easiest way is to inspect the job log. The message suggests to me that table GODSLDPF is not defined for owner (schema) GLOTEMLIB, at least for the user ID that the DataStage job is u...

You can not use DB2 version 8 for the common Repository; it must be DB2 version 9. Therefore you probably have DB2 Client version issues. Similarly the common Repository requires Oracle version 10g so an appropriate version of Oracle client software is needed for that if Oracle is your DBMS of choice.

You already have Enterprise Edition. As soon as you license it, all the parallel stages will magically appear. That is the end of the magic, however; your server jobs will remain as they are - server jobs, and will continue to work the same way that they do now. Parallel jobs, as you will discern by...

I like to initialize stage variables and never re-evaluate them as each row is processed. If it's in code, of course, you have EQUATE and $DEFINE declarations, which you can load up in to header files (blah.H), most easily in the DSU_BP or DSINCLUDE directory. But you have to remember to migrate the...

You left out the grep ! Anyway, this shows that NLS is not currently installed.

When you can get exclusive access to the project, execute the following command:

The reference link data have to be loaded completely into memory (a virtual Data Set). This is a documeted requirement. If it is not possible, as you have noted, a fatal error occurs.

External Filter stage.

I just did, eight minutes prior to you re-posting your question. Was there anything about my answer that was unclear?

In versions prior to 8.0 Range lookup is possible using a sparse lookup only.

The last one first; the MINIMUM and MAXIMUM functions ignore differences in the separators. Which is what the example was trying to show. The different marks provide levels of hierarchy. A dynamic array may have as many as eight levels of hierarchy but let me describe the usual three, since these ar...