Thanks all good ideas. I also just found TAATOOLS has a CVTWRKSPLF which is like WRKSPLF but outputs to a DB file.
--
All service requests MUST go through Remedy.
Remember, I can't provide a precise answer to a vague question.
--
Douglas Hart - Principal Consultant
Level 3 - IBM Power i (AS/400) Technical Support
ITT Corporation - Enterprise Infrastructure (EI)
Americas East Data Center - Seneca Falls, NY
Voice: 315-568-7568 Doug.Hart@xxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hart, Doug - EI
Sent: Monday, August 30, 2010 10:19 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: API QUSLSPL - List Spooled Files
I want to list any spool files on my system with more than 1,000 pages. I wrote an RPGLE program using the API QUSLSPL to collect all the info but I hit the 16Meg limit for user space size. To "find" the big files I need to use the *ALL values input to the API, any subset would bypass the goal. With 280,000+ spool files on the LPAR I can't think of another way to do this. I can get a list sorted by pages using iSeries Nav. but it doesn't give anyway to print or export the results well. I'm running v5r4.
Any suggestions?
--
All data center service requests MUST now go through Remedy.
Please click [ HERE<
http://tinyurl.com/m2ddl2> ] for the Remedy Action Request System.
Remember, I can't provide a precise answer to a vague question.
--
Douglas Hart - Principal Consultant
Level 3 - IBM Power i (AS/400) Tech. Support
ITT Corporation - Enterprise Infrastructure (EI)
Americas East Data Center - Seneca Falls, NY
Voice: 315-568-7568 Doug.Hart@xxxxxxx<mailto:Doug.Hart@xxxxxxx>
________________________________
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
