DSXchange

You could upgrade to version 7, and get the BASIC Transformer stage.

If it's not already sorted, get it sorted; use a UNIX sort, the Sort stage, or the CoSORT plug-in (from the folks who host this site). Run the results through a Transformer stage, with an output link constraint such as @INROWNUM <= 10. Similarly, sort in descending order to get the other end of the ...

Well, I DID say my mathematics was approximate! The 12 bytes is per record, not for the entire file. So your calculation should be 70 + 5 + 12 (=87), rounded up to the nearest multiple of 4 (=88 bytes), then multiplied by 4 million (=352000000), or 344MB. There is also one (static) or two (dynamic) ...

Kia ora. If there are a fairly constant number of rows, then a static hashed file rather than the default (dynamic) may be more performant. You might like to follow that train of thought a little further in your researches. The good news is that there are quite a number of (UniVerse) hashed file exp...

Nope, that one's got me, too.
PhantomSquawk, care to enlighten the world?

Just to reinforce that, even though it's quite a thick book, I carry my copy wherever I travel. It's a vital tool as far as I'm concerned.

However, in version 6 of DataStage, the "external function" can only be one exposed in an ActiveX control.

Unless, like much of the world outside the USA, you're in a locale that uses DMY or YMD as the default date order. I have a better one back at home, which I will post after I return from Thailand.
Basically, it does an OCONV to test the local order, and does the generic conversion on this basis.

In version 5 there's a relink.uvlibs step that has to be carried out. Don't have the details with me, but it's in the server installation instructions and in the ODBC driver documentation. It makes sure that the hidden file (it's actually a symbolic link) /.uvlibs points to the right place. That was...

This exact question has been answered a number of times on the forum.
Try a search for "BETWEEN JOIN" as a start point.

Is that what's on screen, or what's in /tmp/dsrpc.log?

If - as I suspect - it's what's on screen, it means simply that the command has started as a background process with process id (PID) of 13527.

What's in the file /tmp/dsrpc.log? It's a text file; you can read it with cat or more.

Yes, it tends to be one-way traffic. You can convert from binary data into equivalent string representation (which is DataStage's internal representation) but not, it seems, the other way. I'm certain there is a way, but can't remember right now (10:30pm in a Bangkok hotel, without DataStage) how to...

You seem to have missed the -d9 for debugging mode.

Thanks, Eric.

Can you share with us the name of the manual from which you obtained this, or the command that you executed?

Still don't know the phantom reference, though. DSD.RUN invokes DSD.StageRun with PHANTOM SQUAWK DSD.StageRun { command_line_options } SQUAWK is a synonym in the VOC for REPORTING. It used to cause gales of laughter as the preferred option for COPY for Prime INFORMATION. COPY FROM file1 T...