AW: Activation groups

Hi,

>> We are having similar problems when a user switches from
>> 1 current library to another and the service programs continue to use the
>> files from the previous library.

> Yes, this is also why I don't like to keep files open...

This is why I prefere embedded SQL!
Changing library lists results in access plan revalidation and, possibly,
the deletion and re-creation of Open Data Paths (ODP) for unqualified SQL
statements running under system naming.

Using named activation groups allows me to reduce the OPDs to a minimum.

Birgitta

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx]Im Auftrag
von Simonse, Arco (CMK)
Gesendet: Montag, 19. Dezember 2005 22:18
An: RPG programming on the AS400 / iSeries
Betreff: RE: Activation groups


Hi Jim,

> We are having similar problems when a user switches from
> 1 current library to another and the service programs continue to use the
> files from the previous library.

Yes, this is also why I don't like to keep files open...

> Would it work to create only a "Close" procedure that closes all files
used
> in the service program and call it whenever you exit the calling program
> (via LR or return).

Thanks for your suggestion.
I actually have coded some CloseFiles routines for usage with a series of
serviceroutines I have recently created. But I'm not very happy to use this
approach with lots of serviceprograms. It happened a few times to me that I
forgot to define a call to a CloseFiles procedure of a serviceprogram that I
used in the calling program.
So that is why I consider to create a serviceprogram that registers every
serviceprogram and its CloseFiles procedure when the serviceprogram is
called for the first time.

Best regards,
Arco Simonse
--


DISCLAIMER:
This message contains information that may be privileged or confidential and
is the property of the sender.
It is intended only for the person to whom it is addressed. If you are not
the intended recipient, you are not
authorized to read, print, retain, copy,disseminate, distribute, or use this
message or any part thereof. If you
receive this message in error, please notify the sender immediately and
delete all copies of this message.

This footnote also confirms that this email message has been swept for the
presence of computer viruses