DSXchange

Using routines? Yes, but why re-invent what a DataStage job can do perfectly well?

Merge stage must read its source files. Therefore to join more than two files you need more than one job. To do it without the Merge stage you would need to load the text files into temporary tables (UV tables would do) and use the database to effect the N-way full outer join. Hashed file lookups do...

Don't know. Seems like a bug. This is one of those cases when you need the Clear Status File facility.

The writing rule "replace existing rows completely" effects DELETE followed by INSERT for each row sent to the target.

6 is not in that list either. 6 and -6 are not the same value.

The Field() function may have three or four arguments, Arnd. The fourth is number of fields to return. However, I do not believe that the third argument for Field() can legally be a string; it must be an integer. Therefore, assuming that you've read the entire source record (RecIn) as a VarChar and ...

How many CPUs? And please verify the number of processing nodes in the configuration file used when the error was encountered. Does the error occur with half that number of nodes? Depending on what you try to do, a Transformer stage may use scratch space. The partitioning and collection may also use...

Moderator: please remove this duplicate post.

Others: please respond to this post instead.

The job needs to wait until the 275,000 row transaction is assembled and successfully committed. This is your choice, since your job specifies "all rows are one transaction" (transaction size 0). You also need to check what obstacles exist to update operations (which are slow in any case). What inde...

You are going to need to assemble the fields into a single field, so that a string such as the one in your original post occurs. Then apply the Field() function to that, returning everything after the second "#" character. Field(assembled_data, "#", 3, Count(assembled_data, "#...

"Natural" is the pathname of the control file for the virtual Data Set associated with the link. "Synthetic" is the internal name for the buffer associated with the same link. When an equi-join is performed, you only need one of the two source fields (since they have identical values) so the other i...

IsValid("date", InLink.TheColumn)

Don't use StringToDate() in the formulation, as this may fail if the column does not contain a date.

Create a job parameter that is the environment variable and use a reference to the job parameter in your DB2API stage for the Schema.

Why do you not free the memory that you malloc? Of course this is a memory leak.

Correct. In the fullness of time, as you tune your rule set and rule overrides, you expect to have fewer unhandled patterns. You will always, of course, have unclassified tokens, but these can still be handled in patterns. For example in the ?,FI pattern the unknown token in a name rule set is going...