Thanks guys for all the suggestions,
Yes my question was more related to how to go about setting the library 
list, not the actual command itself.
Kevin's suggestion of activation group & data queues may be more efficient 
but 'complex'. I think I would go with two radio button sets (since Scott 
too finds it OK) & store the selection in cookies(yet to try) so the user 
need to make a selection only once.
I'll give it a try, I only feel retrieving the cookies & setting the 
library list for every call may cause a bit of a performance issue.
I don't want to start a debate, but because it makes 
paging/selection/sorting easier I plan to use SQL in RPG & for the first 
time I am also going to try using a view of a view of a view.....  People 
say SQL is very fast but I think this too will cause a performance issue 
as the views are built at run time i.e. each time a page is to be 
displayed on the screen. Here too suggestions are welcome - maybe I should 
start this in another thread ??
Thanks once again
BR
Ewart
Scott Klement
From:
Scott Klement <web400@xxxxxxxxxxxxxxxx>
To:
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Cc:
Date:
04/21/2011 11:05 PM
Subject:
Re: [WEB400] Library list in CGIDEV2
hello Ewart,
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 ??
To use the CHGLIBL command, just do:
   CHGLIBL LIBL(LIB1 LIB2 LIB3 .. etc)
Is that really what you're asking?  Or are you asking us where to store 
the library lists for each database environment?  Or...?
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 would use radio buttons if you want the "product area" and 
"application" to be submitted together. A link would be more appropriate 
if you want to go to the application without submitting anything else on 
the page long with it.
(At least... that's what a user would expect.)
It seems like an okay method to me -- but it's really hard to say 
whether it's a good design without being familiar with the application. 
  What's important here is that it's easy for the user to understand, 
use, and not cumbersome to repeat (if repetition is necessary.)
As an Amazon Associate we earn from qualifying purchases.