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

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

To be more specific, RPG has no problem using an SQL view either.

But one must remember that an SQL view has no keys.

Thus the only way RPG can use the SQL view is via sequential reads or
via RRN.

The fact that SQL views don't have keys means that they aren't usually
useful in an RPG program.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----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
> 
> 
>