IBM SC41-5210-04 Using the Work with Queries display, Choosing a single Query for iSeries task

If you select option 3 (Delete a query) on the Query Utilities menu, you are shown the prompt display for the Delete Query (DLTQRY) command. You can use this command to delete a query definition. 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.

There are other tasks that you can do that are not part of Query but may be related to it or may be convenient to get to from the Query Utilities menu:

vIf you select option 30 to work with files, the Files (FILE) menu is displayed. From that menu, you can do a file-related task (display, copy, delete, save, restore, or edit) or you can use a different file-related utility such as IDDU or DFU, or a licensed program, such as the DB2 UDB for iSeries program. For example, you can use IDDU to define and create files, and you can use either IDDU or DFU to type data into the files.

vIf you select option 31 to do an office-related task, the Office Tasks (OFCTSK) menu is displayed. From that menu, you can choose to work with documents or folders, with office security, or with OfficeVision or Client Access.

Using the Work with Queries display
The Work with Queries display is the major starting point for working with one or more queries at a time.
Using this display, you can select (and, therefore, start) one or more of the following primary tasks:
v Create a new query definition.
v Change, copy, display, or delete an existing query definition.
v Print the definition of a query.
v Run a query to select data from files and produce a report using that data.
Part 2 of this book describes these primary Query tasks. Creating query definitions is described in
Chapters 3 through 14, running queries is described in Chapter 15, and the remaining tasks (changing,
copying, displaying, printing, and deleting query definitions) are described in Chapter 16.
Choosing a single Query for iSeries task
To work with a query, you need to determine which query you want to work with, and you need to select
the task you want to do. To select a task, you can type the number of the task you want to do in the
Option prompt on the Work with Queries display, or if a list of query names is shown, you can type the
number of the task in the Opt column (as shown in Figure 4 on page 13). These are the tasks that you can
choose from:
Query Task	Description of Task
1=Create	Creates (defines) a new query. When this option is processed, the Define the Query
	display is shown so you can start defining a query.
2=Change	Changes an existing query definition. The Define the Query display is shown for this
	option also.
3=Copy	Copies an existing query definition. The Copy Queries display is shown.
4=Delete	Deletes an existing query definition. The Confirm Delete of Queries display is shown.
5=Display	Shows the definition of a query without being able to change it. (To change the query,
	choose option 2.) The Define the Query display is shown.
6=Print definition
	Prints a query definition. For more information, see “Printing a Query for iSeries query
	definition” on page 180.
8=Run in batch
	Runs a query in batch, reducing the resource drain caused by running the query
	interactively.

12Query for iSeries Use V5R2