× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.