• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Get a Hex Dump of

    October 30, 2002 Timothy Prickett Morgan

    Dear Readers:

    Today’s tip proves the old saying, “There’s more than one way to skin a cat.” Here’s another way to view any database file member or IFS file in hexadecimal.

    — Ted

    CL’s Display File (DSPF) command displays any IFS file or database file member.

    To display an IFS file, use the STMF parameter:

    DSPF STMF('/home/mydir/mydata.dat')
    



    Press F10 to see the file in hexadecimal.

    You can specify a path name and/or wildcard characters in the STMF parameter.

    In that case, DSPF provides a list of files from which you can choose.

    This command lists all files and directories in directory /home/mydir:





    DSPF STMF('/home/mydir')
    

    This command lists files whose names start with the letter t:

    DSPF STMF('/home/mydir/t*')
    

    DSPF does not give you as many possibilities as Qshell’s od command, which I presented in the October 18 issue of Midrange Guru .

    To use DSPF to display a database file member, use the FILE and MBR parameters. The MBR parameter defaults to *FIRST:

    DSPF FILE(MYLIB/MYFILE) MBR(MYMBR)
    

    For viewing database files, I prefer the good ol’ reliable Display Physical File Member (DSPFFM) command:

    DSPPFM FILE(MYLIB/MYFILE) MBR(MYMBR)        
    

    Press F10 to view the data in hexadecimal format. The hexadecimal data will be displayed to the right of the character data. If you want to see the hexadecimal data under the character data, press F10, then F11.

    — Ted

    Sponsored By
    ADVANCED SYSTEMS CONCEPTS

    Business Analytics
    – Practical –
    – Cost Effective –
    – Easy to Deploy –

    SEQUEL FYI

    User Quote:
    “I love SEQUEL FYI because it lets me look at the data any way I need to see it, instantly. This is the easiest tool to manage complex product relationships that I have ever seen.”

    SEQUEL FYI offers outstanding OLAP business intelligence functionality for a fraction of the cost of comparable solutions.

    Read More > View Streaming Video

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 83 -- October 30, 2002

    Sponsored by
    FalconStor

    Simplify Secure Offsite Data Protection for IBM Power with FalconStor Habanero™

    IBM i teams are under growing pressure to ensure data is protected, recoverable, and compliant—without adding complexity or disrupting stable environments.

    FalconStor Habanero™ provides secure, fully managed offsite data protection purpose-built for IBM Power. It integrates directly with existing IBM i backup tools and processes, enabling reliable offsite copies without new infrastructure, workflow changes, or added operational overhead.

    By delivering and managing the service end-to-end, FalconStor helps organizations strengthen cyber resilience, improve disaster recovery readiness, and meet compliance requirements with confidence. Offsite copies are securely maintained and available when needed, supporting recovery, audits, and business continuity.

    FalconStor Habanero offers a straightforward way to modernize offsite data protection for IBM i: focused on simplicity, reliability, and resilience.

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Reader Feedback and Insights: Thanks for the Information SQL’s One-Row, One-Column Table

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 83

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights: Thanks for the Information
    • Get a Hex Dump of
    • SQL’s One-Row, One-Column Table

    Content archive

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

    Recent Posts

    • Bob 1.0 Users Bugged By Lack Of One Feature
    • Here Come The AI-Based Code Modernization Offerings
    • Guru: Cohesion First – What A Procedure Should Be Responsible For
    • IBM Offers Trade-Ins On Storage To Grease The Upgrade Skids
    • IBM i PTF Guide, Volume 28, Number 14
    • What IBM i Ideas Are Cooking In IBM’s Ideas Portal?
    • Early Bob Excels In Medhost IBM i Tryout
    • Counting The Cost Of AI Inference – And Projecting It Far Out
    • IBM i PTF Guide, Volume 28, Number 13
    • The Next Generation Of IBM i Talent in GenAI Action

    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 © 2025 IT Jungle