RE: SQL Issues

["Chris Wolcott" <CWolcott@xxxxxxxxxxxxxxxxxxxxxx>]

I compiled my SQLRPGLE program with DBGVIEW(*SOURCE) and CALLED it from
a command line.  I can fetch the cursor contents into a DS table with no
problem.  However, when I call it as a Stored Procedure the result set
is still empty.  Ack!  Phht!  If I use RPG commands to populate the
table, I can see them in the result set but not if I use a cursor.

Here is the CREATE PROCEDURE code:

CREATE PROCEDURE library/rpgproc                         
(IN CDE CHAR (10), IN PRM CHAR (1024), OUT RTN INT)
DYNAMIC RESULT SETS 1                                    
LANGUAGE RPGLE  NOT DETERMINISTIC  CONTAINS SQL          
EXTERNAL NAME library/rpgproc                            
PARAMETER STYLE GENERAL WITH NULLS                       
CREATE PROCEDURE statement complete. 

Any ideas?