RE: SQL Issues

[CWilt@xxxxxxxxxxxx]

Dane,

Ah, I understand what you are wanting.

Unfortunately, I've never done this myself.  Have you tried using the same
format for the arrays as you do the cursors?

/exec SQL
set result sets array :rs for :rsrow rows, array :ms for :msrow rows
/end-exec


Other than that, I don't have a clue.  Perhaps someone else will.


Charles


> -----Original Message-----
> From: Dane Cox [mailto:DCox@xxxxxxxxxxxxx]
> Sent: Tuesday, June 15, 2004 6:51 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL Issues
> 
> 
> Charles,
> 
> That's not exactly what I mean.  He is using an 'array' result set in
> his first example.  The example he used later in his post is 
> the one I'm
> talking about.  Here are the two different statements...
> 
> Array:  set result sets array :rs for :rsrow rows
> Cursor:  set result sets cursor c1
> 
> For some reason, I am unable to see multiple 'array' result 
> sets coming
> back from a stored procedure.  In this case, I use two different
> statements to set the result sets.
> 
> /exec sql
> set result sets array :rs for :rsrow rows
> /end-exec
> 
> /exec sql
> set result sets array :ms for :msrow rows
> /end-exec
> 
> This doesn't work as expected and we only get one result set 
> back to the
> caller...the second one.
>  
> With your help, I am able to see multiple 'cursor' result sets coming
> back.
> 
> /exec sql
> set result sets cursor c1, cursor c2
> /end-exec
> 
> Now that we can get multiple result sets back using the 'cursor'
> technique, I am wondering how to get a simple array (or array ds) into
> an SQL cursor in an RPG program?  Specifically, I would like to put
> array 'rs' into cursor 'c1' and array 'ms' into cursor 'c2'.
> 
> Does that make sense?
> 
> Thanks,
> Dane
>