SQL vs native access (was: Record name the same as the file name)

["Joep Beckeringh" <joep.beckeringh@xxxxxxxxxx>]

SQL was never designed for random access; it was designed for working with
sets. That is why I think it is silly to use SQL for things like file
maintenance ('give me the set of all the customers whose customer number is
12345').

Joep Beckeringh

----- Original Message -----
From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, August 20, 2003 9:15 PM
Subject: RE: Record name the same as the file name


> I hear what you are saying, Bob, but I think you missed my point.  There
is
> no new feature to be had here.  We can already use a SQL table in RPG by
> renaming the format to be unique.
>
> Even if the compiler team developed this, it still doesn't address the
> biggest problem with using SQL tables as native access files in RPG, and
> that is the lack of an integrated index in the table object.  Because SQL
> seperates the access path from the view, there's no way access keys,
making
> random access impossible.
>
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863