× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Stored Procedures
  • From: Cyndi Bradberry <CyndiB@xxxxxxxx>
  • Date: Fri, 23 Jul 1999 08:45:59 -0600

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


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