DSXchange

No. You've already stated that it is non-restartable. Nothing occurring in controlled activities will affect that.

"Better" using what criteria? My personal preference, documented more than once on DSXchange (did you Search? ) is to use an explicit Sort stage because of the extra functionality it provides, chief among which is direct control of memory allocation and the ability to generate key change c...

The Information Server installation has to pick up the installed WAS and record many things about it in the common repository (XMETA), whether there's an existing WAS there or whether it installs its own (which happens first within the install script). IBM has some scripts around this area, such as ...

Nowadays (8.1.2) the CFF stage can output different record types on different output links, not sure if this could be done in version 7.

XMETA

No.

You should not be using a Routine activity; you should be using an Execute Command activity. sed is not a routine, it is a command.

DataStage parallel jobs run in a UNIX emulator called MKS Toolkit on Windows servers. Therefore you have access to the full gamut of UNIX command even though you're "on Windows". A DataStage Data Set is probably not the best storage vehicle, since the activities that retrieve them won't ha...

I'm sure I've listed the rules here in the past. (Auto) gives: Hash on the "keys" on inputs of stages that require key-partitioned data. DB2 on the input to a DB2 Enterprise stage (probably also on a DB2 Connector, but I have yet to verify that). Entire on a reference input to a Lookup sta...

If there is such a setting it's more likely to be in Oracle than in DataStage. I'm not aware of anything in DataStage (unless you can send something like a DROP SESSION command* after your final Oracle stage). * I'm not an Oracle expert - the command may be CLOSE SESSION or something else (HALT AND ...

At the top you mentioned that 6.0.2.27 is for 64-bit and anything lower is for 32-bit, and I indicated that this was correct.

Therefore I reject your reality and substitute my own (the quote's from "Mythbusters", a TV show).

Look in line #5 in your example:

Don't re-invent the wheel. Download ETLstats from Kim Duke's web site. It will do all that work for you, and more.

As soon as there's even one space, all numeric data types are invalidated. It has to be reported as string.

Maybe you need to eliminate unwanted space characters in your Excel worksheet?

chulett wrote: the shear number of people

Is that people with bad haircuts?