Re: SQL User Defined Functions

----- 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.