Re: Library list in CGIDEV2

[Kevin Turner <kevin.turner@xxxxxxxxxxxxxxx>]

Of course, having your application constantly reclaiming the activation group is not great for performance.

A more efficient model might be to exclude all database i/o from your cgi programs and instead delegate it to server programs via keyed data queues. The servers/queues are dedicated to certain library lists.

This is the model followed by renaissance, where cgi programs only handle the ui and back-end servers deal with database I/o and business logic.

On 21 Apr 2011, at 12:56, "Kevin Turner" <kevin.turner@xxxxxxxxxxxxxxx> wrote:

> We do something similar by ensuring the application is in a named activation group, and that every request goes through a routing program that is in a completely different activation group.
>
> Each request will need to contain the selected product area (unless you are using session management, in which case it can be stored in the session).
> This enables the routing program to check the product area on the request to see if it different from that used on the previous request. If it is different then the routing program can change the library list and reclaim the application activation group. Finally it calls the application cgi program to process the request.
>
> That us a very high level overview of one possibility. Hopefully it will give you some ideas.
>
>
> On 21 Apr 2011, at 12:19, "ewart.desouza@xxxxxxxxxxx" <ewart.desouza@xxxxxxxxxxx> wrote:
>
> > Hello All,
> >
> > I'm new to CGIDEV2 & am trying to work my way out of rather simple
> > processes on the green screen.
> >
> > We have 18 identical databases based on 18 product areas. I'm trying to
> > find a comparatively 'easier' way of accessing identical files from any of
> > the 18 databases based on the user's choice.
> >
> > I've done this using the usropn function in RPG but I plan to use SQL. So
> > I feel it would be easier to use the CHGLIBL command to set the library
> > list before using any SQL command. The problem is how ??
> >
> > After the login screen I plan to have another screen where the various
> > product areas are listed (using Radio buttons) & the various applications
> > are listed (in the form of links / Radio buttons, which is better ??). The
> > user will then have to select any one product area & an application to
> > proceed. Is this a good way of doing it ??
> >
> > I've tried to search the net unfortunately I couldn't find anything. All
> > suggestions are welcome.
> >
> > Thanks & best regards
> > Ewart
> >
> > This e-mail is confidential and it is intended only for the addressees. Any review, dissemination, distribution, or copying of this message by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error, kindly notify us immediately by telephone or e-mail and delete the message from your system. The sender does not accept liability for any errors or omissions in the contents of this message which may arise as a result of the e-mail transmission.
> >
> > --
> > This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> > To post a message email: WEB400@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/web400
> > or email: WEB400-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/web400.
>
> NOTICE: The information in this electronic mail transmission is intended by CoralTree Systems Ltd for the use of the named individuals or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone, so that the sender's address records can be corrected.
>
>
>
> --------------------------------------------------------------------------------
>
>
> CoralTree Systems Limited
> 25 Barnes Wallis Road
> Segensworth East, Fareham
> PO15 5TT
>
> Company Registration Number 5021022.
> Registered Office:
> 12-14 Carlton Place
> Southampton, UK
> SO15 2EA
> VAT Registration Number 834 1020 74.
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.

NOTICE: The information in this electronic mail transmission is intended by CoralTree Systems Ltd for the use of the named individuals or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone, so that the sender's address records can be corrected.



--------------------------------------------------------------------------------


CoralTree Systems Limited
25 Barnes Wallis Road
Segensworth East, Fareham
PO15 5TT

Company Registration Number 5021022.
Registered Office:
12-14 Carlton Place
Southampton, UK
SO15 2EA
VAT Registration Number 834 1020 74.