DSXchange

Welcome aboard. There are actually eight choices for partitioning algorithm, and four for collecting. However, the decision is usually easier than that. If you don't need to keep like-valued keys together, use an algorithm that spreads rows as evenly as possible over processing nodes. If you do need...

Except for Special Ed.

He's definitely a special character.

Step 1. Get the software.
Step 2. Get a license key - in exchange for money.
Step 3. Read the installation instructions.
Step 3b. Do what the instructions specify.

What happens if your transaction size is 1 row? In that case you won't (well, shouldn't) run into locking issues or huge rollback segments.

Probably a bug. Day 00 is invalid. Involve your support provider.

(I presume you used "%yyyy%mm%dd" as the format string. "20100100" is valid for "%dd%mm%yyyy". The year is 100.)

DB2 Control Center (which installs from the DB2 client software media) or DB2 Data Studio - the newer tool. Both support through to DB2 v9.7, which is the version of InfoSphere Warehouse.

royarellano wrote:What do you mean by, data definition?

A table definition or record schema in DataStage and/or an XSD for the XML structure.

This question has been asked, and answered, previously. Please Search

karthi_gana wrote: i tried like

not(num(salary)) in the transofrmer...

but no use...

it is not rejecting the rows...

Show us the precise constraint expressions you are using.

Four column names, five columns ?

When the Fmt() function breaks the string, it inserts a special delimiter called a "text mark" in at each break point. This special character is available through the system variable @TM. Internally it is represented by the single byte whose decimal value is 251 (or 0xFB if you prefer).

You really should wrap fixed-format text in Code tags. Input Output AD-ADE-0000000001 0000000001 AF-ADF-0000000002 0000000002 The delimiter in these delimited strings is "-", and that becomes the second argument to the Field() function. The delimited string that you want to extract is the ...

Then, read previously, the answer is no. Each version 8.0 or later server must be on its own machine. 8.x and earlier server versions can be co-resident, but not two or more 8.x. And most PCs wouldn't have the grunt to drive more than one version 8 server anyway. Recommended minimum memory is 6GB, s...

Fold() breaks on length boundaries, not word boundaries.

Yes to the first, provided you have some kind of data definition.

I can't help you with examples - all of my work at the moment is covered by heavy-duty non-disclosure requirements.