• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Case-Insensitive Searching Of Spooled Files

    March 3, 2015 Ted Holt

    We rely heavily on the DSPSPLF (Display Spooled File) command. We use it all day long, you and I, usually by selecting option 5 from various work-with displays. And yet this workhorse on which we depend suffers from a glaring deficiency–searching for text is case-sensitive. We expect case sensitivity from primitive operating systems like Unixsaurus, but not from the powerful IBM i. Here are a few ways to locate text in spooled files regardless of case.

    First is the modern–and in my opinion, the best–way: IBM Navigator for i, the browser application that replaces System i Navigator. This app runs on port 2001 and requires that the *ADMIN instance of the HTTP server be running. If you haven’t tried it yet, I encourage you to do so. For more information about Navigator for i, visit the Navigator for i Web page.

    Expand Basic Operations and click on Printer Output to get a list of your spooled files.

    Figure 1

    (Click graphic to enlarge.)

    You can open a spooled file in a viewer or as a PDF. Either way, you have a case-insensitive search option.

    Maybe you need something that doesn’t require a browser, something that runs in a batch job perhaps. A second method to search a spooled file is with SQL. Create a temporary physical file if you don’t have one already.

    crtpf mylib/splf rcdlen(132)
    

    Copy the spooled file to the temporary file.

    CPYSPLF FILE(QPJOBLOG) TOFILE(MYLIB/SPLF)
       JOB(123456/MYSELF/MYJOB) SPLNBR(3) CTLCHAR(*NONE)
    

    Use SQL to query the physical file.

    select * from mylib/splf
     where upper(splf) like '%SMITH''
    

    The query yields something like the following:

    Smith Widget Mfg Corp                   45.00     7.91        21
    Joe Smitherman, Esq.                   150.00     2.80         6
    Billy Gunsmith                          28.00    14.02       300
    LO-SMITHY-DIN                             .00     3.75        93
    

    You can also use Qshell to search spooled files. Use the catsplf utility to pipe the spooled file into the tr utility, which translates the text from lowercase to uppercase. Pipe the uppercase text into grep to find the search string.

    catsplf -j 476583/MYSELF/MYJOB QSYSPRT 1 | tr 'a-z' 'A-Z' | grep 'SMITH'
    

    Or:

    catsplf -j 476583/MYSELF/MYJOB QSYSPRT 1 | tr '[:lower:]' '[:upper:]' | 
    grep 'SMITH'
    

    Output looks like this:

    1 SMITH WIDGET MFG CORP                   45.00     7.91        21
    3 JOE SMITHERMAN, ESQ.                   150.00     2.80         6
    4 BILLY GUNSMITH                          28.00    14.02       300
    6 LO-SMITHY-DIN                             .00     3.75        93
    

    If you want to see the text without converting the text, try this version of grep instead:

    catsplf -j 270234/MYSELF/MYJOB QSYSPRT 1 | grep [Ss][Mm][Ii][Tt][Hh]
    

    The grep expression tells the system to look for a upper- or lowercase s followed by an upper or lowercase m followed by . . . . You’ll get output like this:

    1 Smith Widget Mfg Corp                   45.00     7.91        21
    3 Joe Smitherman, Esq.                   150.00     2.80         6
    4 Billy Gunsmith                          28.00    14.02       300
    6 LO-SMITHY-DIN                             .00     3.75        93
    

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Racksquared

    It’s time for IBM Power in the Cloud!

    Stop buying hardware and make the move to the cloud. It’s easier and more cost effective than you might think.

    • IBM Power in the Cloud
    • IBM Power Backup Solutions
    • IBM Power High Availability and DR solutions
    • IBM Power Colocation with Management and Monitoring

    Let’s talk about your business needs.

    Call: 855-380-7225

    Email: Sales@racksquared.com

    www.racksquared.com/ibmsolutions

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    LaserVault:  Outperforming Tape: Faster IBM i Backups with Fibre Channel. Webinar - March 3
    BCD:  Modernize Your IBM i Document Design and Distribution. Free Webinar: March 5
    System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Dallas, March 17-19

    IBM Boosts Capacity On FlashSystem Arrays There Is No Lack Of RPG Programmers, IBM i Community Contends

    One thought on “Case-Insensitive Searching Of Spooled Files”

    • shaychuk says:
      September 6, 2020 at 9:43 am

      thank you, I find catsplf command unusable when there are many spool files to search from after some time it starets running very slow are there any alternatives ?

      Reply

    Leave a Reply Cancel reply

Volume 15, Number 04 -- March 3, 2015
THIS ISSUE SPONSORED BY:

WorksRight Software
Bug Busters Software Engineering
Northeast User Groups Conference

Table of Contents

  • Old Stuff, New Ways: Avoiding Record Locks
  • Case-Insensitive Searching Of Spooled Files
  • Git To GitHub

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Guild Mortgage Takes The 20-Year Option For Modernization
  • IBM i Licensing, Part 3: Can The Hardware Bundle Be Cheaper Than A Smartphone?
  • Guru: The Finer Points of Exit Points
  • Big Blue Tweaks IBM i Pricing Ahead Of Subscription Model
  • We Still Want IBM i On The Impending Power E1050
  • DRV Brings More Automation to IBM i Message Monitoring
  • Managed Cloud Saves Money By Cutting System And People Overprovisioning
  • Multiple Security Vulnerabilities Patched on IBM i
  • Four Hundred Monitor, June 22
  • IBM i PTF Guide, Volume 24, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.