RE: Good size for multiple row fetch

Now that you have pointed me in the right direction I have actually found something in the big vaults of the information center. It stated that data and feedback information is passed in that 32kb block. So how big would that feedback information be?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Schmidt, Mihael
Sent: Thursday, August 20, 2009 10:05 AM
To: RPG programming on the IBM i / System i
Subject: RE: Good size for multiple row fetch

Thanx for the quick and precise answer (as always =)

Thanx

Mihael Schmidt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Thursday, August 20, 2009 9:57 AM
To: 'RPG programming on the IBM i / System i'
Subject: AW: Good size for multiple row fetch

... as close as possible to 32K (Because SQL is blocking in 32K!)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Schmidt, Mihael
Gesendet: Thursday, 20. August 2009 08:37
An: RPG programming on the IBM i / System i
Betreff: Good size for multiple row fetch

Hi,

I'm using the multiple row fetch feature in my sql rpg program and am
wondering what a good size for the returning data would be (how big should
the array of my host data structure be)? Anybody a good formula?

Thanx in advance.

Mihael Schmidt
Anwendungsentwicklung

Dirk Rossmann GmbH
Iserhägener Str.16
30938 Burgwedel
* +49 (05139) 898 - 4353

Handelsregister-Nr. HRB 120546, Amtsgericht Hannover
Ust-Id-Nr. DE 115055186
St.-Nr. 16 / 205 / 65401
Geschäftsführer: Dirk Roßmann, Alice Schardt-Roßmann, Roland Frobel, Klaus
Praus