• Subject: Re: Stored Procedures
  • From: Paul Conte <pconte@xxxxxxxxxxxxxxxx>
  • Date: Thu, 22 Jul 1999 14:37:23 -0700 (PDT)

Eric --

>We are currently writing are main system in Java.  We have SQL statements
>our class files.  We would like to create pure SQL stored procedures on the
>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).


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.