RE: SQL logical file equivalent

Hi, Vern:

I was responding to what seemed to me to be some confusion about the
utility of logical files defined with a limited subset of the base
physical's fields. Of course the value of doing it one way over another
depends on what it is you are trying to do, and in what environment.

Darrell

Darrell A. Martin - 630-754-2141
Manager, Computer Operations
dmartin@xxxxxxxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 04/20/2007 08:01:47 AM:

Hi Darrell

As the original post asked for the equivalent, here you go. In SQL a
view gives you the subset of fields. An index gives you the key. So
you would use a select over the view with an order by that
corresponds to an index key.

Now you cannot have both view and index combined in one object in SQL
- that is where non-SQL logicals have an advantage when using F-specs
and native RPG op-codes. You CAN use a view in RPG, as well as an
index, but you get one or the other, as has been said already, I think.

HTH
Vern

This e-mail, including attachments, may contain information that is
confidential and/or proprietary, and may only be used by the person to
whom this email is addressed. If the recipient of this e-mail is not the
intended recipient or an authorized agent, the reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is
prohibited. If this e-mail has been delivered to you in error, please
notify the sender by replying to this message and deleting this e-mail
immediately.