Re: API QUSLSPL - List Spooled Files

[Kirk Goins <kirkgoins@xxxxxxxxx>]

A non programmer way ( ie no fancy-mancy RPG/API stuff ) would be a WRKOUTQ
xxxxx output(*PRINT) then copy that to a PF and parse out what you needed...



On Mon, Aug 30, 2010 at 7:59 AM, Hart, Doug - EI <Doug.Hart@xxxxxxx> wrote:

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