RE: Stored Procedures

[Paul Conte <pconte@xxxxxxxxxxxxxxxx>]

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

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