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


  • Subject: FW: ClientAccess ODBC and Stored Procedures with Result Set Arrays
  • From: Ronald Heerema <news@xxxxxxxxx>
  • Date: Tue, 30 Jun 1998 12:34:51 +0200

I would like to submit the question again. Isn't there anybody in the list that 
can help us with this problem??????

-----Original Message-----
From:   Ronald Heerema [SMTP:news@silvac.nl]
Sent:   vrijdag 12 juni 1998 6:09
To:     'MIDRANGE-L@midrange.com'
Subject:        ClientAccess ODBC and Stored Procedures with Result Set Arrays

Hey there, I'm new to the list but I would like to submit a question.

We are using Visual  Basic 4.0, client Access ODBC Windows 95/NT to Stored 
Procedures and ILE RPG at OS/400 V3.7. Our application requires multiple result 
sets. All the reading we have done says that we should use Array Result Sets. 
(We also have your latest book on the subject).

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. and maybe will go over 
to this version.

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 Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| 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-2024 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.