Re: SQL User Defined Functions

["David Foxwell" <david.foxwell@xxxxxxxxx>]

----- Original Message -----
From: "albartell" <albartell@xxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, October 11, 2007 1:15 AM
Subject: RE: SQL User Defined Functions


> I have been using them here and there (SQL External Stored Procedures more
> than UDF's).  They are decently fast in execution _and_ they retain state
of
> the called RPG *SRVPGM.  What I mean by that is you can make a first call
to
> RPG *SRVPGM XYZ and subsequent calls on the same connection with get the
> same RPG object loaded into memory (i.e global variables will retain their
> values, etc).

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 ?


> iSeries Network has a three part article series on pattern recognition
where
> the same RPG logic is re-used from multiple mediums (green screen, Web
app,
> Java desktop).  I wrote the Java desktop article portion and used SQL
> External Stored Procedures to call the existing RPG service program sub
> procedures.

Can you tell me which months thes articles are in ? We are proVIP
subscribers but unable to access articles from their website.