That is not the answer I was looking for Vern :)
   All the same, appreciated.
   From:      vhamberg@xxxxxxxxxxx                                            
   To:        RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>  
   Date:      09/03/2008 05:23 PM                                             
   Subject:   Re: Sql Table / View / index issue                              
     ----------------------------------------------------------------------
   Nope!!
   Nice short answer, eh?
   Vern
   -------------- Original message --------------
   From: Doug Palme <DPalme@xxxxxxxxxxx>
   > Is there any way to create an index over a view?
   >
   > This transmission may contain information that is privileged,
   confidential
   > and/or exempt from disclosure under applicable law. If you are not the
   > intended recipient, you are hereby notified that any disclosure,
   copying,
   > distribution, or use of the information contained herein (including any
   > reliance thereon) is STRICTLY PROHIBITED. If you received this
   > transmission in error, please immediately contact the sender and destroy
   > the material in its entirety, whether in electronic or hard copy format.
   > Thank you.
   > --
   > 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.
   This transmission may contain information that is privileged, confidential
   and/or exempt from disclosure under applicable law. If you are not the
   intended recipient, you are hereby notified that any disclosure, copying,
   distribution, or use of the information contained herein (including any
   reliance thereon) is STRICTLY PROHIBITED. If you received this
   transmission in error, please immediately contact the sender and destroy
   the material in its entirety, whether in electronic or hard copy format.
   Thank you.
As an Amazon Associate we earn from qualifying purchases.