RE: changing keys of a physical file

Views are indeed accessible via RPG keyed access.  However, only by RRN.
Think of them as a logical file with select/omit criteria, usually with a
different format than the physical, and with no key fields.

AFAIK, the above applies to all views.

You are correct that SQL indexes can be used for keyed access by RPG.  With
one exception, EVI indexes created with the "create Encoded Vector Index ...
" statement.  Though a logical file gets created for an EVI index the same
as a normal one, you cannot open the resulting file.  Interestingly, I
recall that you couldn't even use CRTDUPOBJ at one time; however, from a
quick test that seems to have changed.

HTH,
Charles


> -----Original Message-----
> From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Monday, December 22, 2003 12:23 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: changing keys of a physical file
> 
> 
<snip>
> I believe these are even usable in RPG for keyed access - 
> VIEWs are not, as 
> they are only encapsulated SQL SELECT statements and have no 
> data, no true 
> path to the data until the SQL statement is run.
> 
> I believe these are even usable in RPG for keyed access - 
> VIEWs are not, as 
> they are only encapsulated SQL SELECT statements and have no 
> data, no true 
> path to the data until the SQL statement is run.
>