<David Foxwell>How is this different from having a stored procedure calling
a CL? We're doing it like that so that we can pur the right library list in
place. Are we missing out on the advantages of global variables ?
I rarely use CL except for install scripts and what not, and instead use RPG
ILE *SRVPGM's for 90% of all my development. The nice thing about *SRVPGM's
vs. CL is that you get multiple entry points in the same object with
*SRVPGM's. As far as missing out on the benefit of global variables, it may
not be that important to you depending on what you are trying to accomplish.
I haven't fully explored the benefits of stateful *SRVPGM's, but one thing
you could consider is the fact of how it is different from a CGI app. In
the case of an SQL stored proc you have a dedicated connection (unless you
are using connection pools) and that can provide benefits in not having to
try and retain state by passing pseudo cookies down to the client and back
again.
You may have just given me another topic to write on :-)
<David Foxwell>Can you tell me which months thes articles are in ? We are
proVIP subscribers but unable to access articles from their website.
Here's the original from Scott Klement:
http://www.systeminetwork.com/artarchive/20815/index.html
Paul Touhy wrote one in Oct for the CGI front end:
http://systeminetwork.com/artarchive/21037/Pattern_Recognition__Adopting_the
_Pattern.html
I believe mine will be in the January issue, though it could be December. I
can't remember the turn around systeminetwork.com has with articles. I just
delivered it to them a couple days ago, so I would lean more towards
January.
HTH,
Aaron Bartell
http://mowyourlawn.com
midrange.com
