×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.



  1.  Home
  2. MIDRANGE-L
  3. June 2009

Re: Should we still be using select/omit in logical files?

All the new files (tables) I've defined for the past several years have been
DDL (SQL).

If your select / omit logicals are "read only" that can be accomplished in a
view.

Depending on how a view is defined, it can be update-able. Does i5/OS
support update-able views (curious, I don't know). Otherwise, I think you'll
have to code select / omit criteria as part of any update.

--Loyd

On Tue, Jun 16, 2009 at 6:00 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

I created LF8 following the advice from SYSIXADV. The performance on the
SQL request in question is greatly enhanced. However, if I understand
correctly, SQE would not use LF8 if I used SELECT as in the other LF.

Should we still be using select/omit in logical files?



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.