DSXchange

"11" is the "last used" (queued and ready) on the first run.
On the second run the "last used" is incremented before delivering a value. Indeed, this happens on the first run, too, where the "last used" value is 0.

True but, given the small number of reject rows likely, why not run the Head stage in Sequential mode?

"Sequential" means just that - you must read past every byte in the file to get to the next. Your simplest solution is two ReadSeq statements - discard the results of the first and process the results of the second.

First question - is this really a tilde character, or just a representation on the client of some other character? Use a hex conversion function when extracting from the database table to determine what the character actually is. Once you've determined that, post back and we'll try to work out why i...

You can have both client versions installed (in different folders, obviously) and switch between them using Multi Client Manager. You can only have one client version active at any one time, because they use identically-named DLLs for some things.

Try using a Head stage in the shared container on the input to the shared container.

Much, much, much easier done in a server job. Is this an interview question?

In a server job, generate the integers using a Transformer stage and, in that stage, generate the binary equivalents using Oconv(integer, "MB0C") then left-pad with zeroes as required.

Craig meant "import it into Access using Access".

GENERAL is a general-purpose hashing algorithm that spreads key values as evenly as possible over the available groups (= pages) of the hashed file. SEQ.NUM is a hashing algorithm that is biased towards even spread of numeric characters, so works best with unbroken unsigned integer sequences of keys...

A good example of an account-based hashed file is the SDKSequences hashed file, which is created and updated by the key management routines in the SDK.

You're not in Windows any more.

I like MatchField() to get the numeric portion.

You're not in Windows any more.

They did. The 8.5 exam was available at IOD2011, which is where I did it. No AuditStage questions, though there were some about Data Rules.

Parallel Job Developer's Guide Chapter 2.
Parallel Job Advanced Developer's Guide Chapters 1-7.