Calculating the number of records parameter for batch extract

I am running a batch extract on V4R2, and want to set the optimum number
of records to read in using 
the SEQONLY parameter on OVRDBF. 

Is it 4K Divided by RCDLEN  or 32K divided RCDLEN? 
I realise there are other factors to consider, but I am just using this
as a starting point.


-----Original Message-----
From: Mike Sackman [mailto:msackman@kdpsoftware.co.uk]
Sent: Friday, March 24, 2000 9:28 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: AS/400 to Excel Data Transfer


A commercial application 'AS/400 File Downloader' from 
Evergreen Interactive
systems will do all you want and more.
They are at http://www.evergreeninteractive.com

Regards
Mike


-----Original Message-----
From: JDE Temp 1 [mailto:JDETEMP1@legacyptr.com]
Sent: 23 March 2000 18:11
To: MIDRANGE-L@midrange.com
Subject: AS/400 to Excel Data Transfer


Hi Falks,

The present way of automating an AS/400 DB2 file to be transfered as an
Excel worksheet is using the IBM's Client Access. Is there any 
other way we
could have this done w/o using Client Access. For example, can we use
Rumba/400? Or is there any other way doing this?

Nimal.  

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