× 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.

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

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

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-2023 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.