How to move all spool files to a new output queue on the IBMi 

 May 20, 2010

By  NickLitten

Recently at a client site, I heard a monotonous and really quite annoying sound: tap, tap, tap, tap, tap, tap, tap, tap, TAP… tap, tap, tap, tap, tap, tap, tap, tap, TAP… tap, tap, tap, tap, tap, tap, tap, tap, TAP… tap, tap, tap, tap, tap, tap, tap, tap, TAP… coming from the adjoining Dilbert cubicle.

This prompted me to ask what she was doing. She reluctantly complained that “I have to move all these spool files to another output queue and their are hundreds and hundreds and hundreds of them”

move all spool files

I looked quizzically until I realized she was in WRKSPLF on the green screen and was manually selecting each and every spool file with a 2 before paging down for the next screen, for as many screen as was needed, then using command line to change the output queue.


Loads of time wasted doing a manual task when the tools to move the entire output queue are already right there in Windows but just didnt know about it.

Special Offer for all NICKLITTEN Punters

20% Off with Coupon: NICKLITTEN

In Partnership with SNUG CBD - American readers get 20% off

CBD helps with relaxation, focus and great for pain relief. I highly recommend the SNUG CBD Tincture to help keep you in the zone when programming!

So, to save my eardrums, I showed her how we could do it using IBM Navigator (iSeries Nav or i-Nav is its now known) in a few simple mouse clicks…

1 – Launch Navigator if you are not already running it and click BASIC OPERATIONS

move spools on IBMi or iseries or AS400


move spools on IBMi or iseries or AS400

3 – Choose SPLFS to move

Now its time to select the spool files (reports) that you want to remove. You cant use CTRL/A in my version of Iseries Navigator so I just select the first one and then…

move spools on IBMi or iseries or AS400

SHIFT/CLICK the last one to select them all

move spools on IBMi or iseries or AS400

4 – now RIGHT CLICK and select MOVE

move spools on IBMi or iseries or AS400


Yes it really is that quick and simple.

So the lesson today is to kick your brain out of green screen mode. Using IBM’s tools will not only save you time but will reduce keyboard wear, lower the irritating-sound-in-the-office ratio and prevent you developing repetitive strain injury šŸ˜‰

/me manages to stop himself moaning about people writing RPG code using SEU….


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"cff50":{"name":"Main Accent","parent":-1},"a344d":{"name":"Accent Transparent","parent":"cff50"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"cff50":{"val":"var(--tcb-skin-color-0)"},"a344d":{"val":"rgba(46, 138, 229, 0.85)","hsl_parent_dependency":{"h":210,"l":0.54,"s":0.78}}},"gradients":[]},"original":{"colors":{"cff50":{"val":"rgb(0, 178, 255)","hsl":{"h":198,"s":1,"l":0.5}},"a344d":{"val":"rgba(0, 178, 255, 0.85)","hsl_parent_dependency":{"h":198,"s":1,"l":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__

Get In Touch

Iā€™m always looking for awesome input, feedback and critique!