Re: splitting a spool file

On Apr 21, 2022, at 1:48 PM, Roger Harman <roger.harman@xxxxxxxxxxx> wrote:

Been there, done that.

Help Systems ESend product has good splitter capabilities. At a former employer we used it extensively to burst/distribute reports by department, etc.




-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Alan Cassidy
Sent: Thursday, April 21, 2022 11:38 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: splitting a spool file

For what it may be worth:

Is the spool file is all text, no overlays or embedded pictures? I once
had a situation where the scheduled spool file had various sections with
data results from different departments or something (don't remember
exactly), and they wanted separate sections to go to different people.

I just used CPYSPLF to a data file and then wrote a program that looked
for certain keywords and combinations from the pages to copy to each its
own spool file.

-Alan

On 4/11/2022 9:55 AM, Szymon Nawrocki wrote:
Hi All,

I have a spool file which is too large to be handled by DSPSPLF command.
There is no possibility to change the "creation process" of a spool file so
the idea is to split created spool into several smaller ones.
Because of performance and time limits, it should be done automatically with
APIs .

I am able to use QSPGETSP API to retrieve data from the existing spool and
then use it as a source to QSPPUTSP API as long as it is the same, newly
created spool (first new).
When I try to put the next data packet to the next spool (second new), it
seems to be corrupted.
It is probably the way the buffer data (format SPFR0200) should be altered
before it could be put with the QSPPUSP, but I cannot figure out what
changes have to be made.

Any idea what I should check or maybe someone had similar problems (or has
an example how to do it ) ?

Kind regards
Szymon Nawrocki


Szymon Nawrocki | ul.Stolarska 11/04 | 43-190 Mikołów | https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.asimple.com.pl%2F&amp;data=05%7C01%7C%7C0b5aa9531c3c482ebe9908da23c6236b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861631175063932%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=5majlPd%2Fa1%2F04QmvY3b%2Bz%2FbiMwx5%2BLSVEPKPQbY3hqU%3D&amp;reserved=0

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7C%7C0b5aa9531c3c482ebe9908da23c6236b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861631175063932%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=vExFhhDSEuqqbfAJQoqkfhVDFhYIu0rTwrmpW2jhx7Q%3D&amp;reserved=0
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&amp;data=05%7C01%7C%7C0b5aa9531c3c482ebe9908da23c6236b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861631175063932%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=O%2FryFTHZTAPLXhQHAqnTbBvwnwORx3zXQt5EryU2zc0%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=05%7C01%7C%7C0b5aa9531c3c482ebe9908da23c6236b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861631175063932%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=9VXLcOxvSIfrKkuC45am1XJl1gs0NHNWK8WARgYg568%3D&amp;reserved=0
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com