DSXchange

You have to count all fields, not just the key columns.
There is a single byte delimiter between each field. Count those too.
That is the figure to present to HFC - it does the rest.

That is output from the HASH.HELP.DETAIL command or something similar. The record length is not calculated from the field sizes; it is actually measured from the data stored in the file. What you have highlighted in the picture is merely the key columns. Chances are that there are non-key columns as...

Depends how you get it to the other machine, maybe. FTP will probably effect the translation transparently; copy/paste is less likely to do so.

First tell us what kind of activity you used for your stored procedure in a job sequence. I've searched my Palette and can't find one called Stored Procedure.

All this seems like overkill. Create a job sequence. Include an Execute Command activity to execute your command. Use the output and/or exit status from that command (available through activity variables) in a downstream Nested Condition activity or to provide a job parameter value in a Job activity.

Make sure all DataStage users' umask is set to 002, and that they belong to appropriate operating system groups.

@PARTITIONNUM is the ordinal number of the partition on which the process is executing. Possible value is in the range 0 through (@NUMPARTITIONS - 1). @NUMPARTITIONS is constant, established by the number of nodes mentioned in the configuration file or in the node pool in which the stage is executin...

It (RPC) may be disabled for the entire project which, to my mind, is a Good Thing.

The error message (which you only posted part of) suggests incomplete mapping to the output link. Go there, and check the Mapping tab.

The place to find it is on the Partitioning tab on the input link. But the place to do it is in an upstream Sort stage, as a couple of posters have pointed out.

It will not be before January 2007, because I am already fully booked and need some time to develop the materials. And have other development tasks competing for priority. The reason to seek expressions of interest at this time is precisely to gauge interest, and organize priorities accordingly. As ...

Watch that space! Gig finishes today (the day before Turkey Day).

It's really quite amazing the number of folks who are looking forward to turkey, having forgotten last year's week or two of having to eat turkey leftovers!
Plus ca change, plus la meme chose.

But you can do it from DataStage, perhaps using ExecSH or ExecDOS (depending on platform) as an after-stage or after-job subroutine. In UNIX use the cat command, in DOS use the type or copy command.

DSguru2B wrote:You are correct Craig. It is control Z. I dont know about dos but in unix it is control z (^Z).

My understanding is that Ctrl-Z is the DOS end-of-file character, and that the UNIX end-of-file character is Ctrl-D.

OCONV may be better.
If you want characters converted to pairs of hex digits representing byte values, use Oconv(TheString, "MX0C")