Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

View files fast with PDM and RUNQRY

This is a procedure for adding commands that can be executed on single objects.

You Can View User Feedback To This Tip

Add a command to the WRKOBJPDM display by pressing F16 to view the available 2 character commands. Press F6 to create a new command. I chose the code RQ for 'RUNQRY'. On the command line type RUNQRY QRYFILE((&L/&N)) RCDSLT(*YES) and press enter to save it. From the Work with Object using PDM you can now type the option RQ in the Opt field next to any Physical or Logical file. The Query record selection screen will come up first allowing you to filter the records in the query. This is a fast way to view data in a file, and it's useful if you're solving a problem or preparing to create a more complicated query, SQL statement, or program. PDM commands can be created for many AS/400 commands that execute on a single object. With PDM they can then be easily executed on many objects interactively or submitted to a JOBQ if the command created is inside a submit job (SBMJOB) command.


  • The tip might work better as:

     Option  Command                            _____________ 
      RQ    RunQry  Qry(*None) QryFile(&l/&n) RcdSlt( *Yes ) 

    Without the Qry (*None) there will need to be a predefined query of the same name as the file in the library list.

    . — Denny Ray

This was last published in July 2001

Dig Deeper on iSeries system performance and monitoring

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...