RE: SQL Proceure Questions

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

To clarify...

You can use Stored Procedures and User Defined Functions in a SQL statement.

Both Stored Procedures and UDFs can be "External" or actually written in SQL.

"External" means the routine is a program or service program procedure written 
in any iSeries HLL.  Note that it was not until v5r3 that external UDFs could 
be a procedure in a service program.  Prior to v5r3, both external procedures 
and external UDFs had to be program objects.


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 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 1:44 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL Proceure Questions
> 
> 
> I agree with what Charles is saying here except that user 
> defined function can be any program object type. I have one 
> written as a ILE/RPG service program. There are two classes 
> of SQL Procedures, External and SQL. External procedures are 
> just programs of any language that get called when you call 
> the stored procedure name so you could say that they don't 
> exist except as entry in the tables pointing to a program to run. 
> 
> The SQL Procedure, which I think you are talking about, is 
> written in SQL and compiled to a C Pgm object but again the 
> SQL Procedure name itself does not exist except in the 
> tables. The tables points to the actual program name.
>