DSXchange

The links go in the direction you create them. The arrowhead is on the stage to which they are drawn (not from which they are drawn). It's perfectly OK that the arrow runs right to left, but the link must be drawn in that way. If you're concerned about rectilinearity in your job design, you can resi...

Depending on your UNIX, a named pipe is created with a command such as mknod or mkfifo - check with your UNIX man pages.

(There's a lot of peripheral stuff you need to know to be a DataStage consultant, isn't there?!!)

That's because "" and @NULL are different. "" is a known value. It is a character string containing precisely zero characters, and can be compared with other character strings, participate in concatenation and substring (!), and so on. It's called "the empty string" or "zero-length string". NULL is ...

DataStage does not have its own scheduler; all the Director gives you is an interface to the operating system scheduler - cron or at on UNIX (depending whether it's a "one off" or repeating schedule), or at on Windows. Consult with your UNIX administrator or manual to figure out how these interact w...

There should be no reason not to use sort as a filter in a Sequential File stage's Input link. You may need to specify stdin as the source file (as "-") for the command, and any key specification ("-k") must correctly match the metadata from your job design.

Can you establish which stage type it is? That is, can you open a design and see a generic icon rather than the expected icon? If so, you can probably re-install just that plug-in stage using the DataStage Package Installer.

7.1.x will install on Windows NT 4 (and works properly). 7.5 is the first that won't.

Then - clearly - you are presently somewhere east of Ankara!

I can tell you for a fact that it does not install on Windows NT 4.0 sp6a.

How about you tell us how you're trying to do it, then we might be able to spot a problem? It's really difficult to tell you if you're making a mistake if we can't see what you're doing! And you might have better luck if you posted on the Parallel forum rather than here on the Server forum. Expect t...

UniVerse SQL uses SUBSTRING as defined in ANSI SQL and in ODBC 2.0

Please avoid multiple posts. It only clutters the database and makes searching less efficient.

Easiest and most efficient is to "store" it in a column being propagated in the data stream being processed. This remains available as far downstream as you could wish, until you discard it.

What Scott said. This is basic SQL - not really a DataStage issue at all.

Check the value of Output and SystemReturnCode following the first call to DSExecute to determine why the target file is not being populated. $DEFINE TESTING Call DSExecute("UNIX","sort -u filename > filename1", Output, SystemReturnCode) $IFDEF TESTING Message = "Val...