RE: Stored Procedures

[Cyndi Bradberry <CyndiB@xxxxxxxx>]

Paul --

My manager just finished reading the News 400 July 1999 issue and decided
that we should try to implement stored procedures for use in our Active
Server Pages.  I just want to make crystal clear on what we need to have
installed to do this. He keeps insisting that we should be able to do this
with RPG/IV, but in your article you mentioned the C compiler.

Could you tell me exactly which LP's I need? 
Also another stupid question, when entering these statements with SEU, what
is the member type? 
Currently I have RPG installed on my systems, both at V4R3, a model 510
production and a model 150 test box.
TIA,

Cyndi Bradberry
Idaho Housing and Finance Association
Boise, Idaho


-----Original Message-----
From: Paul Conte [mailto:pconte@picante-soft.com]
Sent: Thursday, July 22, 1999 3:37 PM
To: JAVA400-L@midrange.com
Subject: Re: Stored Procedures


Eric --

>We are currently writing are main system in Java.  We have SQL statements
inside
>our class files.  We would like to create pure SQL stored procedures on the
400.
>Has anyone created these and could someone please give me an example of the
>code.  I have found a little on IBM's web site, but I don't think it is
very
>good.  What should the source type be and what are the steps to compile
this.

See the following articles (by me) in NEWS/400 (www.news400.com):

"New! SQL/400 Implements Stored Procedures" -- April 1998
"Inside an SQL Stored Procedure" -- July 1999
"Produce Result Sets from SQL Stored Procedures" -- (to be published) --
October 1999

I will also be covering this topic in my forthcoming SQL/400 book from 29th
Street Press, which will be out later this year.

I put the Create Procedure statement in a source member with SQL as the type
(you can uses anything), and use RUNSQLSTM to run the statment (which
generates the C code, runs the C precompiler, and compiles the C program).

HTH

-- Paul

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---