IBM SC41-5210-04 manual Using Query for iSeries commands, Using the Query Utilities menu

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:

vSTRQRY brings up the Query menu.

vWRKQRY brings up the Work with Queries display.

vRun 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.

vDelete 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