× 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.


  1.  Home
  2. RPG400-L
  3. September 2014

One view per program?

I've been using SQL for years. But was humbled at the recent OCEAN conference to realize how much there is to learn. I've never used views before. I'm starting to grasp the importance of using them and flexibility they provide but I still can't quite wrap my head around the idea of "one view per program."

From p.258 of the Modernization redbook<http://www.redbooks.ibm.com/abstracts/sg248185.html?Open> "The view should be specific to your program." Am I misreading this to think that means one view per program? I've seen this idea referenced in other posts here. I understand a change to the view will only be required if a table change impacts the view. But one view per program still seems like a potential maintenance hassle?

Thoughts on the subject? Other references?

Vic



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.