• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • How To Use the Inhibit Write Keyword?

    February 24, 2010 Hey, Ted

    I stumbled upon the Inhibit Write (INHWRT) keyword parameter of the Override with Database File (OVRDBF) command recently while I was looking through the help text for something else. How long has the parameter been there? I can think of some ways to put it to work. Can you tell me something about INHWRT and how to go about using it?

    –Bill

    That parameter has been there forever, Bill, but I don’t think a lot of people know about it. I see it mentioned occasionally in online forums. I don’t consider it a terribly useful feature of i5/OS.

    When you override a database file with INHWRT(*YES), the database manager suppresses all output operations to the file. To the best of my knowledge, the INHWRT parameter was designed with debugging in mind. When you enter debugging mode with STRDBG UPDPROD(*NO), the system halts if you try to write to a database file in a production database. By overriding the file with INHWRT(*YES), the debugger can run without writing to the file. However, if you can make a copy of the file in a test library, such as QTEMP, you won’t need the override. Use the TYPE parameter of Create Library (CRTLIB) or Change Library (CHGLIB) to determine whether a library is for production or test.

    Also, many shops now have a test system (often a logical partition), which means they can debug in production mode all the time. Such was not the case on the S/38 and earlier versions of the operating system currently known as IBM i.

    If you use INHWRT in testing, be aware that your test may not be complete. For example, if the program tries to write a record with a duplicate key, your test run won’t catch it if INHWRT is in effect. If you have calculations that are conditioned to the success or failure of output operations, they may not work the same under INHWRT(*YES) and INHWRT(*NO).

    I know of two other ways to control output that you might consider when writing or modifying source code. You can use the EXTIND keyword in the F spec to control any file, input, as well as output. If an external indicator (U1-U8) is off when the cycle gets ready to open the file, the file will not be opened and all I/O will be ignored. I used that technique a good bit back in my S/34 and S/36 days.

    The other way is control the file open and I/O operations manually. That is, pass a parameter into a program, and depending on the setting of that parameter, either process the file or not. You’ll have to include the USROPN keyword on the file. This method is more work, but it’s my preference.

    All this is not to say that INHWRT is worthless. Many shops still run old programs that were written years ago. Imagine a program that builds a report and writes to a database file. Imagine that the report has gotten misplaced and needs to be regenerated. How do you rerun the program in order to get the report without corrupting the database file? Maybe you can use INHWRT(*YES).

    And by the way, INHWRT also applies to output done though SQL.

    –Ted



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    PowerTech:  Strengthen your security. Get a FREE Compliance Assessment today
    looksoftware:  Learn more and get your complementary ilook licences
    COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    eCMS Gets an Interface to Vehicle Scales X64 and Blade Servers Lead the Server Recovery

    Leave a Reply Cancel reply

Volume 10, Number 7 -- February 24, 2010
THIS ISSUE SPONSORED BY:

WorksRight Software
Profound Logic Software
Northeast User Groups Conference

Table of Contents

  • Naming Idiosyncrasies with the DB2 Storage Engine for MySQL
  • How To Use the Inhibit Write Keyword?
  • Hunting Down Storage Hogs

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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