× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. December 2010

Re: Basic stored procedure questions

Hi, David:

Take a look at:
http://www.sqlthing.com/book.html

You might want to buy a copy of this book. Also, on this web page is a "Downloads" link (on the left) where you can download the "freeware" version of "SQLThing" ... this PC-based tool makes it easy to test SQL statements, stored procedures, etc.

Hope this helps,

Mark S. Waterbury

> On 12/2/2010 7:08 AM, David FOXWELL wrote:
Hi,
I'm looking at the red book Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries. Now I'm trying to call the stored procedure. I can't use iNav as it seems to be broken so I'm calling in a STRSQL session. Can this be done when a stored procedure returns a parameter? The sql session doesn't like '?'. Also, the red book example used a bound rpg pgm. I created my program using a call to a service program which didn't work. When I switched to a bound by copy, it worked. Is there a reason for this?


Thanks

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.