Re: Is AS400JDBCDriver available outside jt400.zip?

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

Thanks Buck.
I looked into SYSPROCS, SYSPARMS, SYSROUTINE and they are what I want!
I try to figure out what you mean by "a generic stored procedure" but I can'
t come up with a strategy. Could you explain this a little bit?
Bruce
 ----- Original Message -----

From: "Buck Calabro" <Buck.Calabro@commsoft.net>
To: <java400-l@midrange.com>
Sent: Wednesday, October 10, 2001 8:47 AM
Subject: RE: Is AS400JDBCDriver available outside jt400.zip?


> >We mostly use JDBC stored procedures to run RPG/CL.
> >I found one inconvenience with this approach: I
> >have to create a stored procedure for
> >each RPG/CL in the database.
>
> You can create a more generic approach if you pass the "real" program name
> as a parameter to a generic stored procedure (that is essentially a CALL
> &PARM1) and pass the other parameters through.
>
> >BTW, is there a way to list all the defined procedures in a database?
>
> Depending on what you want to know, look at the system catalogue files
> SYSPROCS, SYSPARMS, SYSROUTINE...
>   --buck