Re: Question on Structuring Product Attributes
From: Lennart Jonsson <erik.lennart.jonsson_at_gmail.com>
Date: Fri, 08 Feb 2013 06:53:26 +0100
Message-ID: <kf23ro$gme$1_at_dont-email.me>
Date: Fri, 08 Feb 2013 06:53:26 +0100
Message-ID: <kf23ro$gme$1_at_dont-email.me>
On 2013-02-04 02:01, derek.asirvadem_at_gmail.com wrote:
[...]
> My performance (DB2 and Sybase) flies. I already have close to one hundred standard Subtype structures in production. Millions of transactional inserts have been tested. Probably a thousand full table unload/reloads (thousands to millions of rows each) have been tested.
>
I tried to read through this thread, so there might be peaces that I missed. I like the idea that you present, but AFAIK DB2 (LUW) does not support sub queries in check constraints. I tried to rewrite your code for DB2 (LUW), but get an error. Are you on ZOS, or am I missing something? can you provide a short example for DB2? [...]
Cheers
/Lennart
Received on Fri Feb 08 2013 - 06:53:26 CET