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

Dig Deeper on iSeries system performance and monitoring