RE: Re-creating a spool-file using USERSPACE

Dirk,

I think the answer lies in the documentation for the QSPGETSP API. Read it carefully. It specifically mentions that there are two possible solutions to the situation where the spool file is larger than the size of a user space. Both solutions hinge on the number of buffers returned and the starting buffer passed to the API. Using the number of buffers you can retrieve only enough of the spool file to fit into your user space. Using the ordinal buffer to read you can control what part of the spool file is copied into your user space or you can create a second user space and place the information into it.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of DMarien@xxxxxxxxxxxx
Sent: Wednesday, April 08, 2009 12:32 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re-creating a spool-file using USERSPACE

Hi,

We currently re-create spoolfiles using the following logic and API's (using chgsplf op cpysplf doesn't offer sufficient functionality in our
case) :

CrtUsrSpc : Create user space in QTEMP.
Call 'QUSCRTUS'
CrtSplFil : Create spooled file 2.
Call 'QSPCRTSP'
OpnSplFil : Open spooled file 1.
Call 'QSPOPNSP'
GetSplFil : Get data spooled file 1.
Call 'QSPGETSP'
PutSplFil : Put data in spooled file 2.
Call 'QSPPUTSP'
CloSplFil : Close spooled file 1 & 2.
Call 'QSPCLOSP'
DltUsrSpc : Delete user space in QTEMP.
Call 'QUSDLTUS'

However, we are facing the following problem : some spoolfiles are larger than 16 MB and since the API's are using userspaces, the re-created spoolfile only contains the first 16MB (hence the resulting spoolfile is incomplete). Is there an alternative for using the userspace API's or a way to make userspaces larger than 16 MB ??? All tips are welcome.... .

Dirk Mariën

business application analyst | LeasePlan Belgium
Tel: +32-2-722 19 24
Fax: +32-2-722 61 71 | DMarien@xxxxxxxxxxxx Excelsiorlaan 8 | 1930 Zaventem www.leaseplan.be

It's easier to leaseplan

LeasePlan Belgium is a commercial name which is used for the following
companies: LeasePlan Fleet Management sa (Registration number BE 0424 632 148), LeasePlan Truck sa (Registration number BE 0414 860 486), Iris Holding sa (Registration number BE 0412 459 143) and Accident Management Services sa (Registration number BE 0412 990 069). All these companies have their statutory seat at Excelsiorlaan 8, B-1930 Zaventem.