Filter
Top Products
Using Query for iSeries commands
A command is a statement used to request a function of the system. This means you need only
remember a command that is a few characters long instead of remembering all the individual instructions
or taking the time to go through a series of menus.
Query has four commands, which can be entered from any command line:
v STRQRY brings up the Query menu.
v WRKQRY brings up the Work with Queries display.
v Run Query (RUNQRY) runs an existing query, or you can use it to run a default query. This command
can also be embedded in CL programs so that you could, for example, run several queries overnight.
v Delete Query (DLTQRY) deletes one or several query definitions.
For detailed information about how you can use these commands, see the CL Reference information in
the iSeries Information Center.
Using the Query Utilities menu
The Query Utilities menu allows you to select Query tasks for working with queries, running queries that
have previously been defined, deleting query definitions, or working with files.
QUERY Query Utilities
Select one of the following:
Query for iSeries
1. Work with queries
2. Run an existing query
3. Delete a query
SQL/400
10. Start SQL/400 Query Manager
Query management
20. Work with query management forms
21. Work with query management queries
22. Start a query
23. Analyze a Query for iSeries definition
More...
Selection or command
===>
F3=EXIT F4=PROMPT F9=RETRIEVE F12=CANCEL F13=USER SUPPORT
F16=OS/400 MAIN MENU
(C) COPYRIGHT IBM CORP. 1980, 1991.
If you select option 1 (Work with queries) and press the Enter key, the Work with Queries display is
shown. On that display, you can specify which query you want to work with and in what way. The tasks
that can be started using that display (including additional ways for running and deleting queries) are
introduced in “Using the Work with Queries display” on page 12.
If you select option 2 (Run an existing query) on the Query Utilities menu, you are shown the prompt
displays for the Run Query (RUNQRY) command. You can use this command to run a query and produce
a query report of the data selected from one or more database files. You can use this command to run an
existing query (one that is defined and stored by name on the system) or to run a “default” query (one that
is unnamed and that uses mostly system-supplied values). If you do not know the name of a query or
library, use option 1 (Work with queries) so that you can get a list of queries and libraries.
Chapter 2. General operating information for Query for iSeries 11