DSXchange

You can not do it that way (Q pointers). DataStage and UniVerse are separate products, and their compiled code is incompatible - even though they can compile the same source code successfully the magic number in the header of the object code is different. So if you were to compile in DataStage the s...

Learn patience. Transferring 1GB via FTP is NOT going to happen in a couple of seconds. Like Craig, I'd suggest using a Sequential File stage to write the file to disk locally at the DataStage server, and an FTP script (BAT file) from there. The FTP stage streams data straight into the transfer, and...

You may - depending on the O/S - also need to have an active network card - that is, be connected to a network (even to a router) that can serve an IP address. I know this is the case for Windows XP professional.

You don't need to count them to validate that only the appropriate types are in the string. Alpha() will work on the entire string, returning 1 if every character in the string is alphabetic. The easiest way to test for a set of valid characters is to convert them all to "" then test the length of t...

To run ExecSH itself as the after-job subroutine, simply put the command line argument after the command pathname in the Input Values field. To call ExecSH from your own routine you need simply add the command line argument to the command line issued. If you mean "job parameter" here, rather than co...

All that shows is that you can copy/paste faster than DSGuru2B can type!

More easily done in DataStage for those who don't know or don't have awk.

The documentation for Link Partitioner specifically notes that inter-process row buffering must be enabled when this stage type is used, because it creates a process for itself. See top of page 13-2 in Server Job Developer's Guide for version 7.5

You are going to need to debug it systematically. Are the correct and consistent number of rows being extracted from source? If not, then whether you have zero or 100 lookups is irrelevant; you are going to have to solve this issue first. Then start adding lookups one at a time, and observing the be...

One possible reason is looking ahead to the day when/if it's converted to a parallel job, in which it is not possible to do it in the same job. Another reason is philosophical - the original requirement specified "after" - having separate jobs makes it easy to make this "after" relationship obvious ...

I think DRS is reasonably well-understood in our milieu to mean Dynamic RDBMS Stage.

But why was this posted here, and not in the parallel forum?

Permissions?

Reason code 1 is usually permissions, reason code 2 is usually file not found, and so on.

Pathnames are case sensitive on UNIX. Did you specify "Scratch" instead of "scratch" or vice versa?

Yes.



The first two arguments are input, the final two are output. Output is any output from the script, ExitStatus is the exit status of the script.

You know that. I know that. But it's probably the price.

Folks, this stuff is FREE - provided out of the goodness of Kim's heart (and in the hope you'll buy some of his other stuff).