Re: DDL Files - Tables and keys

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

However,

If you already have the extra cost DB2 Multi-System license program or
you are willing to pay for it, the you may find your multi-member
files are easier to handle.

The DB2 Multi-System license program enables you to create Partitioned
Tables, which look to RPG like multi-membered PFs.

In that case, the issues Elvis mentioned do not apply.

HTH,
Charles


On Fri, Aug 15, 2008 at 12:53 PM, Elvis Budimlic
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> SQL is not member aware which causes headaches.  Some examples follow:
>
> Default behavior is that you can't access non-*FIRST members using SQL
> statements (you can access it using the ALIAS support or OVRDBF, but in my
> opinion, that's just a kludge).
> You can't build an SQL index on a non-*FIRST member (I suppose you could
> build member-specific keyed LFs instead and HOPE query optimizer will use
> them).
>
> So, while there are workarounds, the fact that SQL is not designed with
> members in mind, will cause you headaches from the get-go.
>
> HTH, Elvis
>
> Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
> OS/400
> www.centerfieldtechnology.com