Re: Stored Procedures

[Paul Conte <pconte@xxxxxxxxxxxxxxxx>]

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