DSXchange

Yay! Does the FF part of the timestamp picture handle any fractional seconds (say microseconds) or is it limited to milliseconds?

A supported version of Red Hat? It does matter.

A supported version of Red Hat? It does matter.

Enable stage tracing on the Transformer stage. Capture properties and subroutine calls. You will then see all the SQL statements sent to the ODBC driver (and thence to the database server) in the trace file. Examine these to see why a call to fetch the next row might have failed. The trace files for...

DataStage is not the only thing I do. Certainly I don't have a "home" copy - no-one does, as there is no such thing. I would have to visit someone who has DataStage to do that. You are looking for a routine that opens a hashed file called SDKSequences onto a file variable declared to be in COMMON, a...

These are exactly the same. XML is, by definition, free format.

A stage variable to record whether you're in a new group. A stage variable to "remember" the previous group. A stage variable to record the CA value on group change only. A stage variable to compare CA against that one (this is the "flag"). Output all input columns and flag. Run through Aggregator c...

I doubt that Trim() will help; a Char(n) - or string[n] - must always be n characters long. You need to ensure that all n match for the lookup to succeed. Or convert to VarChar(n) - or string[max=n].

Clearly an embedded configuration is necessary in a Data Set or a File Set. For example, if it was written under control of a four-node configuration file, then it can only be read from those four nodes, irrespective of the "current" configuration file. This can imply a need to re-partition in a run...

Does your Modify stage include an explicit KEEP specification? If not, try adding one.

Are you using the default timestamp format? If not, is the format you have specified valid (for example, does each component have a leading "%" character)? Are you returning fractional seconds from DB2, which your format does not recognize?

A lot of the pre-compilation work for parallel jobs is done in the client, which explains the CPU consumption you observed. Slowness at compile time (or, indeed, any task that needs to refresh the client) may be attributable to a number of things, even to there being very many jobs in the project, o...

Not true.

There is a Filter which, by default, limits you to the most recent 100 events, but you are in control of the Filter. Right click in the background area and choose "Filter" from the menu, or use Ctrl-T to open the Filter dialog.

You can "kinda" migrate them now; they're stored in a file called DSParams, which is in the project directory on the server. Good news awaits in the next ("Hawk") release, with a concept called "parameter sets", which will live in the Repository and will, therefore, be able to be exported/imported, ...

Has some kind soul modified your KeyMgt routine? (There was one group of consultants running around Australia and New Zealand doing that for some years - rebadged the SDK routines as their own, and managed to ruin more than a few of them in the process.)