Why is that a bad idea?

Unless the keys don't already exist in another logical, there's no
additional overhead beyond a few bytes of disk.


On Fri, Apr 25, 2014 at 3:27 PM, Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>wrote:

That is exactly why programmers created Logical Files with just the fields
they needed for their program. You could change the physical but the
logical would remain unchanged. In my opinion that was a bad idea. I
think I still have a few of those LF Views floating around our systems.

Chris Bipes
Director of Information Services
CrossCheck, Inc.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Friday, April 25, 2014 12:20 PM
To: Midrange Systems Technical Discussion
Subject: Re: IBM i 7.2 & Power8

I'm signed up for the webinar and you've peaked my interest.

You know one thing that would be cool?

If RPG database RLA was more like SQL in that data from a file was
retrieved based on field *name* at run time and not on field *position* at
compile time.

The only fields retrieved at run time would obviously be the ones that
existed at compile time, but it would really make it easier to make
database changes.

Yea, everything could be rewritten to SQL access but that's not really in
the cards for thousands of existing programs with millions of lines of

Just dreaming out loud on a Friday . . .

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot 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 here. If you have questions about this, please contact