Stored procedures

Hey there, is there anyone outthere working on Client/Server apps

We are using Visual  Basic 5.0, RDO 2.0, client Access ODBC Windows 95/NT to 
Stored Procedures and ILE RPG at OS/400 V4.2. Our application requires 
multiple(when possible) result sets. All the reading we have done says that we 
should use Array Result Sets. But are now looking at Cursor Result Sets.

We have followed the procedures laid down in the AS/400 Client/Server 
Performance Redbook (SG24-4731-00) (which is at VB 3.0) and have that working 
for a single array result set.

The ODBC Users Guide indicates that on the host side we can identify/use up to 
20 results sets with the 'SET RESULT SETS'; statement (but only one array).

When we tried to work this up for our application by receiving 2 Array Result 
Sets in the Visual Basic program, we receive only the second result set.

The host side is quite clear and it is passing out 2 result sets. On the client 
side in the 'CREATE PROCEDURE' statement we have (for this case) spoecified 
'RESULT SETS 2', and we know about SqlMoreResults.

We have also looked at the documentation of OS/400 V4.2.

Can anyone help? We cannot see what else we should do on the Visual Basic side 
to process all the result sets the host is sending. If anyone else has 
experience with a situation like this please help.

Kind Regards,

Ronald Heerema
news@Silvac.nl

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *