Re: Sql Table / View / index issue

LOL

As you know, I think, a view is a logical file with a special couple of attributes, and an index is also a logical file with a special couple of attributes. There really is no such thing as an index over a view, however.

Vern

-------------- Original message --------------
From: "Michael Ryan" <michaelrtr@xxxxxxxxx>

An index over a view is called a logical file.

On Wed, Sep 3, 2008 at 6:45 PM, Walden H. Leverich
wrote:

Is there any way to create an index over a view?

Nope... and why would you want to?

(Actually I can think of a couple of reasons you'd want to, but I don't
believe you can do it on i)

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.