Re: Internal Procedure In SQL

[rob@xxxxxxxxx]

I think what he means is that, instead of a traditional, or prototyped,
CALL he wants to do something like
     C/EXEC SQL
     C+ CALL MYSQLPROC :MyHostVar
     C/END-EXEC

And wondering what the syntax was for the CALL in RPG.  And how to pass
them back from the sql stored procedure itself.

Good references though.  That should be a good start.  Along with the IBM
doc and some books at:
http://store.midrange.com

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


|-----------------------------+-------------------------------------------|
|   "Buck Calabro"            |                                           |
|   <buck.calabro@xxxxxxxxxxxx|                                           |
|   >                         |                                         To|
|   Sent by:                  |                                      rpg40|
|   rpg400-l-bounces@midrange.|                                      0-l@m|
|   com                       |                                      idran|
|                             |                                      ge.co|
|   08/10/2004 11:50 AM       |                                      m    |
|                             |                                         cc|
|         Please respond to   |                                           |
|      RPG programming on the |                                     Fax to|
|          AS400 / iSeries    |                                           |
|      <rpg400-l@xxxxxxxxxxxx>|                                    Subject|
|                             |                                      Re:  |
|                             |                                      Inter|
|                             |                                      nal  |
|                             |                                      Proce|
|                             |                                      dure |
|                             |                                      In   |
|                             |                                      SQL  |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|-----------------------------+-------------------------------------------|






> Anyone has the syntax for an internal procedure
> in sql on an AS/400. Just one using a select
> statement, receivng a param and returning one.

I'm not sure what 'internal procedure' means, but the FAQ has links on
learning SQL http://faq.midrange.com as well as to the RPG IV Redbook.
Also, the archives here have a bunch of SQL references.
http://archive.midrange.com  Search the RPG list for 'SQL' 'SQL
SELECT' 'SELECT' and the like.
--buck



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.