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



Actually, you're _WAY_ better off explicitly defining the fields in the logical.

In fact, every logical should have fields explicitly defined and every
program should be using a logical never the physical.

Why? Simple, lets say you want to add a couple new fields, and out of
200 programs using the file only two need the new fields.

With explicitly defined fields in the logicals and all access via
logical, you can just add the fields to the physical and create a new
logical with the existing and new fields and change just the two
programs. You don't have to even recompile anything else! Even if
you have a CMS that makes recompiles easy, a recompiled program still
needs to be tested. Unless you happen to be the only RPG shop in the
world with 100% automated regression testing, reducing the number of
programs you need to test is a great idea... :)

Yes, you'll have extra logicals around, _BUT_ those new field logicals
have basically no overhead since they will presumably share the same
key as an existing logical; and the i automatically shares the access
path of the original with the new. The overhead of logicals comes
from maintenance of the access paths.

HTH,
Charles


On Thu, Aug 23, 2012 at 2:41 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
Problems are:

1) I am forced to name each field in the DDS. I would like it to pull in all fields so the file is interchangeable in pgms with the PF. If someone adds a field to the product file in the future, the pgms would not get the new fields.

And to NOT have to name each field that I want included in the LF; ie I would like to take ALL fields from the PF without individually naming each field?

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