Re: IBM i 7.2 & Power8

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.

Charles


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