AW: SQL logical file equivalent

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi Rob,

A SQL Index can be used with native I/O like any keyed DDS described logical
file.
Contrary to SQL where an index never can be specified directly, an index can
be used in the F-Specs in RPG.
It it not neccessary to create a DDS described logical file with the same
key fields as the index.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von rob@xxxxxxxxx
Gesendet: Thursday, April 19, 2007 22:21
An: Midrange Systems Technical Discussion
Betreff: RE: SQL logical file equivalent


Depends on how the RPG programs "use" it.  First, can RLA even directly 
access an index?  Is RLA limited to tables and views?  Only RLA will ever 
give you a level check.

Rob Berendt