
	Home > AS/400 Tips > iSeries administrator tips > View files fast with PDM and RUNQRY

iSeries 400 Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

ISERIES ADMINISTRATOR TIPS

View files fast with PDM and RUNQRY

Derrick Kostiner
07.23.2001
Rating: -3.66- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

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.

USER FEEDBACK TO THIS TIP

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

Rate this Tip
To rate tips, you must be a member of Search400.com. Register now to start rating these tips. Log in if you are already a member.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	iSeries system performance and monitoring
	Analyze the health of your IBM i server with iScore
	Translating Linux for IBM i admins: Working with jobs and networking
	Database performance comparisons on IBM i
	How to: Monitoring job activity on the AS/400
	Performance tuning for IBM i: The basics and beyond
	How to: Reduce the percentage of ASP used on the AS/400
	Detecting system changes made by outside IP address
	AS/400 system values quiz
	Checking on System i disk space requires creating a new command: XRTVSYSSTS
	Drive space management commands

Implementation

Getting modules to adopt authorities from the main program

iSeries i5/OS: Top 10 Q&As

iSeries i5/OS: Top 10 Q&As

Using the SPLF0200 format in QUSLSPL API

New option within the WRKSYSACT command

Identify files used in all queries

Security Tools can help manage your system security

Client Access Express password cache

Check constraint allows database admins to sleep a bit better at night

See the users with *change or *all authority

Implementation Research

iSeries administrator tips

Analyze the health of your IBM i server with iScore

Researching high availability for your System i shop

Translating Linux for IBM i admins: Using GUI to make it easy

Translating Linux for IBM i admins: Working with jobs and networking

OpenOffice: What to know before making the transition from Microsoft Office

OpenOffice: An enterprise open source solution

Database performance comparisons on IBM i

Translating Linux for IBM i admins: User profile commands

Modern System i reports using Client Access

Tips for installing Lotus Domino server on a System i partition

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

CIW (Search400.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

iSeries Security - Security Tools, Physical Security and System Security

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy