DSXchange

Look at the "how to use" comments in the first four lines of the code. The pathname is the first argument, and there is a total of five arguments.

No. You must use the DB2 Enterprise stage.

Even with Photoshop applying maximum sharpening, I can not read the labels on that job design. It is, nonetheless, clear that you have a circular design. -----> TransformerStage1 -----> ^ | | | | V HFStage1 HFStage2 ^ | | | | V -----> TransformerStage2 -----> which will never work. Please post a lar...

@NULL is the correct mechanism. How are you loading the DB2 table? The problem might be occurring there. You might like to edit the generated SQL to provide NULL explicitly as part of the SQL syntax.

A patch is required if your client machine is running Windows XP SP2.

select count(*) from table should be quite cheap to execute, because it should be able to be resolved with a single read from system table. One solution to the question would be a job sequence containing two jobs and an intermediate Routine activity to determine the link row count from the first jo...

And strip out the delimiters in the generated date.

Check with your vendor as to whether a more recent driver is available (with DataStage), otherwise check with DataDirect themselves.

The tables that comprise the repository are deliberately incompletely described. "They" reserve the right to change them, and do so at most major releases. Further, some tables contain multiple record structures. On this forum, and by inspecting Kim Duke's ETL toolkit, you can find out pretty much a...

I still can't tell whether "hash1" is being populated by or being used to serve a reference link by either of the transformer stages to which it is linked. Arrowheads (use "V" or "^") are needed. Or post the image, as Craig asked.

File Sets are not stored in the scratchdisk area, they are stored in the disk area. You need to clean up the control file (blah.fs) as well as the data files on each partition.

Actually, it's not complete, as we can't tell which way data flow with respect to the Hashed File stage hash1. The circularity to which Arnd refers is in the Hashed File stage hash2 - it can not open its outputs until its input is closed. Is there any reason this can't be done as two jobs - one to p...

Not only that, it logs an informational message (not a warning) when the timeout triggers.

I'm afraid you're in for pain. Have you tried multi-select (Shift-Click or Ctrl-Click) in the drop-down list of schema file names? That's about all I could suggest.

Use an ExecuteCommand activity to execute dir command, and check its exit status. It should be non-zero if no file exists to match your wildcard. Use a Routine to do the same thing. Open the folder as if it were a table and count the file names matching your wildcard. (You will need to Change() the ...