DSXchange

Meaning, there is no 8.2 version as of yet. Did you perhaps mean 8.1?

No. As noted, you'd need to explicitly select the 'Range' option, something I believe is not available in the 7.x release.

As noted, that mailing list is long dead but if you look closely you'll find that its entire contents have been archived in a locked forum here.

Other than the 'meta' kind.

While they are included on your licensed installation media, you can also download them from IBM. Or even order a printed copy but they're not... inexpensive.

In other words, provide for the maximum number in your design, remove any null/empty ones post pivot. The Column Import stage or a Transformer leveraging the Field() function will prep the data for the Pivot.

No, for the first load it will not exist so it will create it and then with the right setting overwrite it after that. No "workaround" needed.

As noted, stop pre-creating empty files.

For the Universe stage to be 'functional' over a hashed file like that, you need to create a secondary index over those fields. A search for CREATE.INDEX and BUILD.INDEX should get you the syntax here.

I didn't see any such when I checked my logs, just the actual dumped 'records' from the Peek stage. Is this functionality, optional or otherwise, that was added in 8.x?

... or store the valid characters (if smaller) and do the "double convert" that's been posted here before.

I don't, I think it's one of those goofy errors you can get when you hack off the end of a query.

OK. What have you tried so far or thought might be the approach you'll take? Look into the various command line dsjob options. First, you could use "-ljobs" to get a list of all jobs in the project and then use "-jobinfo" to check the most recent run status in a loop to identify ...

Yes.

Side note: At release 8.0, if you are on an SMP (single box) configuration you can reduce memory usage by selecting "Auto". By default it will select "Entire" and use a single copy stored in shared memory that can be accessed by all partitions. This happens in 7.x as well, from ...