× 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. RPG400-L
  3. January 2005

RPG SQL stored procedure

We have an RPGSQL program that is used as a stored procedure.  The text to 
create the stored procedure is 
 
 CREATE PROCEDURE AIPDFVIEW     
 (                              
   In    TRKID Char(29),        
   In    PCUNO dec(7,0),        
     OUT PCOUNT DEC(4,0)        
 )                              
                                
 Language RPG   
 
 
IBM's DB2 development center never has a problem running the stored procedure.  
              

When the stored procedure is called by a java process that uses the result, a 
sporadic cursor state error occurs that indicates to the java process an error 
happened when actually the RPG program ran correctly and should have returned 
the result set requested.
 
The question that I have is ....   Is there something wrong with the create 
listed above. 
 
 
 
Thanks
 
 
 
Bill Grossenbacher
IT Project Manager
USA Mobility
601.977.1583
Bill.Grossenbacher@xxxxxxxxxxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.