• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Another Way to Sort a File

    January 16, 2008 Ted Holt

    I’ve been in the information business for almost 27 years, and sometimes it seems that I’ve spent half that time sorting data. Without question, putting data into proper sequence is a big part of our jobs. Card sorters are ancient history. Sort utilities (e.g., #GSORT and FMTDTA) still run, but hopefully not in new development. These days, logical files and SQL are the iSeries methods of choice for placing data into a certain order. Here’s another sorting method you may not be aware of.

    The Reorganize Physical File (RGZPFM) command’s KEYFILE parameter provides a way to physically order records in the file. If you specify KEYFILE(*FILE), the data will be stored in key sequence. You may also specify the name of a logical file if you wish to store the data in the order of the logical file’s key field(s). The end result is that programs may read the file in arrival sequence, which is faster than reading by key.

    While I’m on the subject, let me mention KEYFIELD(*RPLDLTRCD), which I did not know existed. Selecting this option tells the system to replace deleted records at the top of the file with active records from the end of the file. I wonder how many releases ago IBM snuck that one in on me?



                         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
    ARCAD Software

    [Webinar Series] Demystifying DevOps on the IBM i

    Join us for this 3-Part Roundtable Webinar Series, where ARCAD experts will demystify the move to Git and an automated process with options that work for everyone!

    This Series will be an engaging discussion on key DevOps topics as Git, Builds, Automation and much more.

    Part 1: IBM i & Git – Developer Tools (Thursday, January 26th, at 12:00PM ET / 9:00AM PT)

    During this 1st session, we will discuss Developer Tools and all the ways to use Git including iProject, Merlin, VS Code, ARCAD’s Centralized option and more.

    Part 2: Branching & Building (Thursday, February 9th, at 12:00PM ET / 9:00AM PT)

    During this 2nd session, we will discuss Feature/Release and Branch Management and building the branches with tools like Bob and ARCAD.

    Part 3: DevOps – Automated Workflow (Thursday, February 23rd, at 12:00PM ET / 9:00AM PT)

    During this 3rd session, we will discuss what can be automated in the IBM i DevOps process starting from the build to other steps in your workflow.  We’ll discuss pipeline tools like Jenkins and the new automation features of Git packages.

    Register NOW

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Profound Logic Software:  Web-enable in less than a day with Genie
    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    Vision Solutions:  Enter to win an iPod Touch. Just download any of our DR planning resources

    IT Jungle Store Top Book Picks

    Getting Started with PHP for i5/OS: List Price, $59.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 Developers' 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
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    SugarCRM 5.0 Now Generally Available Weak Dollar, Services, and Power6 Give IBM a Solid Fourth Quarter

    Leave a Reply Cancel reply

Volume 8, Number 2 -- January 16, 2008
THIS ISSUE SPONSORED BY:

WorksRight Software
Guild Companies
COMMON

Table of Contents

  • Bringing i5/OS Resources to the Web
  • Another Way to Sort a File
  • Admin Alert: Before You Buy That New System i, Part 1

Content archive

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

Recent Posts

  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow
  • It Is Time To Have A Group Chat About AI
  • 2023 IBM i Predictions, Part 2
  • Multiple Vulnerabilities Pop Up In Navigator For i
  • Participate In The 2023 IBM i Marketplace Survey Discussion
  • IBM i PTF Guide, Volume 25, Number 4

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.