• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • File Members and the Library List

    May 25, 2005 Dominic Lefevre

    What happens when an RPG or COBOL program opens a file? For one thing, the system has to find the file. And where does it look for the file? Everyone knows the answer to that question. The system searches the libraries in the library list, beginning with the system library list, proceeding through the product libraries, the current library, and finally the user libraries. The system selects the first file it finds of the desired name, right? Not necessarily.

    The exception comes when the system is searching for a certain file member. If the system does not find the desired file member in a file of the desired name, the system will continue to search the libraries in the library list.

    Here’s a little test you can run for yourself. Create two files of the same name in different libraries. I suggest you use work libraries. You can use QTEMP for one of them. Give the members different names.

    crtpf qtemp/x rcdlen(48) mbr(one) 
    crtpf mylib/x rcdlen(48) mbr(two)
    

    Use a database utility, such as DFU, to load one record into each of the files. I suggest you key ONE in member ONE and TWO in member TWO.

    Use the Display Physical File Member (DSPPFM) command to display the files.

    dsppfm x one
    dsppfm x two
    

    You will see that the system will find the right member, no matter the order of the libraries in the library list.

    Source physical files also work well for this test. Give it a try with files of the same name, such as QRPGSRC, in different libraries.

    This same behavior holds true with RPG (and, I assume, COBOL) programs. RPG normally opens the first member of a file, but if you override a file to a certain member, or you add the EXTFILE and EXTMBR keywords in RPG F specs, the system will continue to scan through the libraries in the library list until it finds a file member of the proper name.


    The system is not consistent, however. The Run Query command chokes if it does not find the desired member in the first instance of the desired file.

    runqry qry(*none) qryfile((x two))  
    runqry qry(*none) qryfile((x one))  
    

    One of the two commands generates message QRY1612 (Member ONE not in file X in MYLIB).

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    OCEAN User Group

    OCEAN TechCon22 – July 21-23, 2022
    Three Days of Inspiration & Innovation!
    In-Person & Online

    Join your IBM i Community for hands-on learning from technical presentations and workshops, plus a Vendor Solutions Expo. Technically, We’re passionate about continuing education on the IBM Power Systems platform!

    Register Now!

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    WRQ Improves Security of Terminal Emulation Suite Intel Partnership Doesn’t Hurt iSeries Strategy, JDA Software Says

    Leave a Reply Cancel reply

Volume 5, Number 21 -- May 25, 2005
THIS ISSUE
SPONSORED BY:

ProData Computer Svcs
iTera
WorksRight Software

Table of Contents

  • Creating Pivot Tables on the iSeries
  • File Members and the Library List
  • Admin Alert: Configuring Windows Desktops to Use SSO

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.