RE: SQL Issues

["Dane Cox" <DCox@xxxxxxxxxxxxx>]

Chris,

I've done some additional testing, and much to my dismay I think we are
at an impasse on this unless someone else has some input.

I thought I had this working, but in fact it was not...really.  I was
using a copy of my original program for testing and had failed to create
the stored procedure for that program name.  I was getting back my
result sets in Ops Nav with no problems but I was not actually calling
stored procedures...which completely baffles me.  Anyway, now that I
create the procedure I get nothing back.  The only time I can get
something back in Ops Nav is when I use a single 'array' result set.
Nothing else works.

Here's hoping someone else will chime in and give us a hand...

Dane


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Wolcott
Sent: Wednesday, June 16, 2004 2:49 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: SQL Issues

 
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?

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




NOTICE: This electronic mail message and any files transmitted with it are 
intended exclusively for the individual or entity to which it is addressed. The 
message, together with any attachment, may contain confidential and/or 
privileged information. Any unauthorized review, use, printing, saving, 
copying, disclosure or distribution is strictly prohibited. If you have 
received this message in error, please immediately advise the sender by reply 
email and delete all copies.