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:email@example.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: firstname.lastname@example.org +--- +--- | 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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.