Re: finding parameters & accessing Stored Procedure definitions

[AKumar@xxxxxxxx]

Hi,
     Why don't you try Client Access Express tool. You can write stored
procedure using and also you can save the stored procedure in C:/ drive.
In this tool you can see the Stored Procedure on Screen under the library.



Regards,
Ajay Kumar
305-539-6621.





Joe Teff <JoeTeff@earthlink.net>@midrange.com on 06/29/2000 05:16:51 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   "'RPG400-L'" <RPG400-L@midrange.com>
cc:

Subject:  finding parameters & accessing Stored Procedure definitions


I have two little utilities that I want to build but am having a hard time
with.

1.  I want to be able to enter a program name that I want to create a
stored
    procedure for. I then want to figure out what the parameters are in
that
    program. I have not found a command or API that will give me this info.
    (the source may not be available)

2.  I want to present a list of available Stored Procedures on a system and
     at least see the associated info. I know I can get these from
     QSYS2/SYSPROCS. Does anyone know if there is an API available that
     would be better to use than going after the catalog file itself?

TIA
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---