RE: SQL Proceure Questions

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Alan,

It is slick.  What's interesting is that, as far as I know, SQL UDFs have 
always functioned this way.  Which makes sense, given that a UDF needs to run 
as quickly as possible as it would be called once for each row in a table with 
millions of rows.  The interesting thing is that prior to v5r3, an external UDF 
had to be a *PGM.  You couldn't call a procedure in a *SRVPGM as a UDF; even 
though IBM obviously could.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Alan Campin
> Sent: Thursday, June 02, 2005 6:01 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: SQL Proceure Questions
> 
> 
> >> If you use SQL to actually write a stored procedure or a 
> UDF, then behind the scenes OS/400 creates the ILE C *PGM or 
> >> >> *SRVPGM objects as shown in my first post.
> 
> Charles, if you write a UDF in SQL, it will create a service 
> program? Checked the manual and you are right. Slick. Have to 
> play with it to see how it creates the "C" code. 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>