RE: Usage of Indexes and its Effects on an RPG Program

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Exactly...  The index is operationally equivalent to a plain keyed logical.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Fleming, Greg (ED)
Sent: Wednesday, December 14, 2005 10:22 AM
To: Midrange Systems Technical Discussion
Subject: RE: Usage of Indexes and its Effects on an RPG Program


So how would one go about using it?  Do you name the index on an F spec
like you would a logical file ? 

>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
>bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
>Sent: Wednesday, December 14, 2005 11:11 AM
>To: 'Midrange Systems Technical Discussion'
>Subject: RE: Usage of Indexes and its Effects on an RPG Program
>
>Greg,
>
>Interestingly enough, RPG has no problem using a SQL index for native
I/O.
>You cannot generally use a SQL view in RPG though, unless you adopt
>embedded
>SQL.
>
>Eric DeLong
>Sally Beauty Company
>MIS-Project Manager (BSG)
>940-297-2863 or ext. 1863
>