Re: Index over join tables

[Jim Essinger <dilbernator@xxxxxxxxx>]

> From the redbook:  Stored Procedures, Triggers, and User-Defined Functions
on DB2 Universal Database for iSeries (sg246503.pdf) I find this comparison
table.

SQL term --> iSeries term


Table --> Physical file
View --> Non-keyed logical file
Index --> Keyed logical file
Column --> Field
Row --> Record
Schema --> Library, Collection, Schema
Log --> Journal
Isolation level --> Commitment control level

I think you want the VIEW and the INDEX.   The index is over the same table
the view is pointing to.

Jim


On Fri, May 11, 2012 at 8:31 AM, Raul A. Jager W. <raul@xxxxxxxxxx> wrote:

> Using DDS I can create a "view" that has an index and some data from one
> table and data from other joined tables.
>
> Can I do the same using SQL? at V7.1
>
> TIA
> Raúl
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.