Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Future consideration
Workspace IBM i
Categories Print
Created by Guest
Created on Mar 26, 2025
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit IBMI-I-4099 Display Spooled File needs to support better F14/F15/F16 find options.

Make spoolfile searching case insensitive Merged

When searching a spooled file, the information must be entered case sensitive. 

  • Instead of searching for escape, I have to search for Escape in order to find escape messages in job logs.  
  • Instead of searching for 'library list changed', I have to search for 'Library list changed'
  • If searching by message ID I have to search for CPC2101 instead of cpc2101.

F14=Search options does not allow to change case settings


Idea: Make searching spooled files case insensitive. 

Idea priority Low
  • Guest
    Jun 11, 2025

    The way I read this request was the requestor was asking for this capability in the base OS display spool file program's search. Accessible by directly specifying a spool file in the DSPSPLF command, or probably more commonly via option 5 when looking at an OUTQ's spool files, job's attached spool files, or the spool files listed in the WRKSPLF command.

    That SQL may work, but it is a very complex solution to having case insensitivity allowed (I'd prefer by toggle) in the search within the DSPSPLF's output screen.

    Edit to add another example. The interactive output of the DSPFD command is in a "Display Spooled File" screen. Something I frequently go in here to quick check is if a file being investigated reuses deleted records. Despite 20+ years on the platform I've got a brain block that prevents me from remembering if "deleted" in the associated reuse deleted records line of the output is capitalized or not. The habit I've formed is instead to search for "eleted" and omit having to worry about case sensitivity of the D. Allowing toggle of case sensitivity would make this easier.

    This can be even more useful when looking at a joblog spool file as one may not be searching for fixed text of a message ID, but instead for the string that would go into a message field where the case of that data may not be immediately known.

  • Guest
    Jun 11, 2025
    What tool are you using when doing this search? Are you looking for the specific spoolfile or looking for a string within a known spoolfile?
    You could use SQL service and change all text to UPPER before comparison with the following:
    This will not give you the whole spool file to read, but will give you the name, spool file number and the row and row number where the search string match, just replace MY_LIB, MY_OUTQ, my_search_string and the time fram you want to search:

    select O.CREATE_TIMESTAMP,
    O.JOB_NAME,
    O.SPOOLED_FILE_NAME,
    O.FILE_NUMBER,
    O.USER_DATA,
    S.ORDINAL_POSITION,
    S.SPOOLED_DATA
    from table (
    QSYS2.OUTPUT_QUEUE_ENTRIES('MY_LIB', 'MY_OUTQ', 'NO')
    ) O,
    lateral (
    select ORDINAL_POSITION,
    SPOOLED_DATA
    from table (
    SYSTOOLS.SPOOLED_FILE_DATA(
    JOB_NAME => O.JOB_NAME, SPOOLED_FILE_NAME => O.SPOOLED_FILE_NAME,
    SPOOLED_FILE_NUMBER => O.FILE_NUMBER)
    )
    ) S
    where S.SPOOLED_DATA like '%my_search_string%'
    and O.CREATE_TIMESTAMP between
    '2023-05-08 20:21:00.000000' and '2023-05-10 20:00:00.000000';
    IBM Power Systems Development
  • Guest
    Mar 26, 2025

    While not necessarily make it case sensitive, having the "Kind of match" option like is in F14 search options when browsing a member in PDM (STRSEU) would be welcome. I definitely wouldn't want to lose the ability to search with case sensitivity, but having the option to not do so would be welcome.