Re: Stored Procedures

[Glenn Holmer <gholmer@xxxxxxxxxxxxxx>]

Thanks to everybody who sent pointers on this subject.  The Redbook in
particular seems to be "holy writ" in this area.

Raikov, Lo wrote:

> You can try SG24-6503-00 (DB2 UDB for iSeries Stored Procedures and
> Triggers) Redbook. But, I'm afraid, it does not dwell too much on
> performance - just shows how to do what you're after.
> My own advice would be to convert JDBC statement calls to JDBC stored
> procedure invocations, the more the better. Stored procedures should be
> written in RPG (no tricky subselects - the simpler the better) with (only if
> you need it) an intermediate C wrapper layer for complex parameter
> conversions. For instance, RPG-generated arrays can be converted in the C
> layer into the array result set format for easy access from your PC
> programs.
>
> Lo
>
> -----Original Message-----
> From: Glenn Holmer [mailto:gholmer@weycogroup.com]
> Sent: Wednesday, December 19, 2001 4:27 AM
> To: java400-l@midrange.com
> Subject: Stored Procedures
>
>
> Can someone point me to some information on how to create and call
> stored procedures using SQL on the '400 from Java programs?  I am
> writing a Java program to run on a PC that requires a horrific SQL
> with subselects and so forth and we need to speed it up.



--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601