• Subject: RE: Stored Procedures
  • From: Paul Conte <pconte@xxxxxxxxxxxxxxxx>
  • Date: Sat, 24 Jul 1999 08:19:15 -0700 (PDT)

Cyndi --

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

To create an "SQL" stored procedure, you definitely must have (I'm using
product numbers for V4R4):

5769-CX2 ILE C for AS/400
5769-ST1 DB2 Query Manager and SQL Development Kit for AS/400

You can use any source type, I use SQL for documentation purposes. I would
*highly* recommend using a good quality, PC-based editor (Flex/EDIT,
Codewright, etc.) and transferring the source to the AS/400. I've found this
much, much faster to create cleanly laid out, properly working code.

Your manager may be confusing the fact that you can create an RPG program
and use it as a stored procedure, which is called via SQL (including
embedded CALL, CLI, ODBC, or JDBC). If you have the SQL Dev. Kit, you can
also embed SQL statements in the RPG program. But this would not be using
the standard SQL syntax for the entire body of the stored procedure itself.

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