Re: Defining Files locally in Sub-Procedures - What advantages has everyone found doing it that way?

I use SQL for almost all of my data file needs. SQL cursor logic has more
pros than cons. However, traditional files are still necessary for display
and printer file interaction.




From: Alan Campin <alan0307d@xxxxxxxxx>
To: "RPG programming on the IBM i / System i"
<rpg400-l@xxxxxxxxxxxx>,
Date: 07/27/2012 03:30 PM
Subject: Re: Defining Files locally in Sub-Procedures - What advantages
has everyone found doing it that way?
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



I would ask a higher level question. Is it time to move to SQL? With
all the advantages and power of modern SQL I would question continuing
to use files.

On Fri, Jul 27, 2012 at 12:52 PM, Andy Hautamaki
<ahautamaki@xxxxxxxxxxxxxxx> wrote:

Our shop is going to be moving from V5R4 to V7 in a few months so I can
finally start using the enhancements in V6 and V7.

The idea of being able to define the files in Sub-Procedures instead of
globally in a module I was thinking would be very cool. Then I got to
thinking when would I really need to do that? When has everyone else been
finding it was a better idea to define the files in a sub-procedure?

I was reading about how the file will be closed without it having the
static keyword. When would it be better to use the static versus not? If
your using the sub-procedure repeatedly the open and closing of the file
seems like a reason to be using the static. Interesting idea that you

could

be getting different records for the same file in different

sub-procedures.

Thanks
Andy
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.