Re: Are SQL Stored Procedures Really Transformed into ILE C and Compiled?

In that case, the RPGLE program is the stored procedure.

All you're doing is basically prototyping the interface for SQL to use it.

Fun fact...every *PGM object on the IBM i is technically a stored
procedure. The only reason you need to "prototype" it to SQL is to make
parameter passing work easier.

Charles


On Wed, Apr 29, 2015 at 4:59 PM, Ken Sims <mdrg8066@xxxxxxxxxxx> wrote:

On Wed, 29 Apr 2015 11:14:40 -0600, Nathan Andelin
<nandelin@xxxxxxxxx> wrote:

Several people assure this is true. But where are the references? I'm
primarily interested in IBM i references.

Several references for z/OS state that the C compiler is no longer
required, and they differentiate between "native stored procedures" and
"external stored procedures", where only the latter require the C

compiler.

Based on my extremely limited experience with stored procedures, if
the stored procedure calls an RPGLE program to do the actual work, no
C program is generated.

Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.

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