Re: SQL statements for physical and logical files

On Tue, Feb 14, 2017 at 12:36 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

- telling people, that they could use SQL indexe for RLA access seems to
be a joke to me, in reality you would end up with accesspaths containing
all fields of the underlaying table - a real night mare for all DBMS!!!

​Hasn't been true for a while now...

create index myidx
on mytbl (mykey)
add fld1, fld2, fld3

creates a *FILE object that contains only mykey, fld1, fld2, fld3;
regardless of how many other columns are there.

Works just like a DDS keyed logical with an explicit column list.

Great for RLA.

And FYI: qibble - a slight objection or criticism.

Charles


​