Manual query v61

System i

Query for i5/OS
Version 6 Release 1
SC41-5210-05

System i

Query for i5/OS
Version 6 Release 1
SC41-5210-05

Note Before using this information and the product it supports, be sure to read the information in Appendix F, “Notices,” on page 253.

This edition applies to version 6, release 1, modification 0 of IBM i5/OS (product number 5761-SS1) and to all subsequentreleases and modifications until otherwise indicated in new editions. This version does not run on all reduced instruction set computer (RISC) models nor does it run on CISC models. © Copyright International Business Machines Corporation 2000, 2008. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.Contents
About Query for i5/OS . . . . . . . . ix
Who should read the Query for i5/OS book Prerequisite and related information . . . How to send your comments . . . . . . . . . . . . ix . ix . ix Selecting a library for your Query for i5/OS queries . . . . . . . . . . . . . . Other considerations when you are trying to locate or use a particular Query for i5/OS query . . . . . . . . . . . . .Displaying the format of constants in Query for i5/OS . . . . . . . . . . . . . . . Query for i5/OS profile information . . . . . Handling Query for i5/OS messages and errors . Changing your Query for i5/OS queries . . . . 16

. 17 . . . . 17 18 18 18

Part 1. Introduction to Query for i5/OS . . . . . . . . . . . . . . . . 1
Chapter 1. What is Query for i5/OS? . . 3
3 3 4 4 4 5 5 5 Query fori5/OS fundamentals . . . . . . . . Files, fields, and record formats in Query for i5/OS . . . . . . . . . . . . . . . . Double-byte character set (DBCS) fields in Query for i5/OS . . . . . . . . . . . UCS2 level 1 character set support in Query for i5/OS . . . . . . . . . . . . . . . Data definition languages and utilities support in Query for i5/OS . . . . . . . . . . Query for i5/OS definitions . .. . . . . . Libraries in Query for i5/OS . . . . . . . . Major functions of Query for i5/OS . . . . . .

Part 2. Defining and using Query for i5/OS query definitions . . . . . 21
Chapter 3. Creating a Query for i5/OS query definition . . . . . . . . . . . 25
Starting Query for i5/OS query definition . . . . Selecting definition steps when defining a Query for i5/OS query . . . . . . . . . . .. . . Selecting options for a Query for i5/OS query definition . . . . . . . . . . . . . . Moving through the Query for i5/OS definition displays . . . . . . . . . . . . . . When you return to the Query for i5/OS Define the Query display . . . . . . . . . . . Considerations for creating Query for i5/OS queries Selecting files, records, and fields for Query for i5/OS . . . . . . . . . . . . . . .Suggested sequence of tasks for creating Query for i5/OS queries . . . . . . . . . . . 25 26 27 28 28 28 28 29

Chapter 2. General operating information for Query for i5/OS . . . . . 7
Practicing with Query for i5/OS . . . . . . . . 7 Getting started with Query for i5/OS . . . . . . 7 When you are finished working with Query for i5/OS . . . . . . . . . . . . . . . . 7 Telling Query for i5/OSwhat you want . . . . . 7 Using prompts and default values in Query for i5/OS . . . . . . . . . . . . . . . . 7 Using Query for i5/OS function keys . . . . . 8 Checking the results before printing the Query for i5/OS report . . . . . . . . . . . 8 Printing what you see on your Query for i5/OS display . . . . . . . . . . . . . . 9 Using lists in Query for i5/OS . . . . . . . 9 Displaying a Query fori5/OS list . . . . . 9 Selecting items in a Query for i5/OS list . . . 10 Special library names in Query for i5/OS . . 10 Using Query for i5/OS commands. . . . . . . 11 Using the Query Utilities menu . . . . . . . . 11 Using the Work with Queries display . . . . . . 12 Choosing a single Query for i5/OS task . . . . 12 Specifying a Query for i5/OS query and its library . . . . . . . . . . . . . ....