Summary of the content on the page No. 1
ERserver
iSeries
Query for iSeries Use
Version 5
SC41-5210-04
Summary of the content on the page No. 2
Summary of the content on the page No. 3
ERserver iSeries Query for iSeries Use Version 5 SC41-5210-04
Summary of the content on the page No. 4
Note Before using this information and the product it supports, be sure to read the information in “Notices” on page 261. Fifth Edition (September 2002) This edition applies only to reduced instruction set computer (RISC) systems. © Copyright International Business Machines Corporation 2000, 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Summary of the content on the page No. 5
Contents About Query for iSeries Use............................ ix Who should read the Query for iSeries Use book.....................ix Part 1. Introduction to Query for iSeries .................... 1 Chapter 1. What is Query for iSeries? ........................3 Query for iSeries fundamentals............................3 Files, fields, and record formats in Query for iSeries...................3 Query for iSeries definitions............................5 Libraries in Query for iSeries.........
Summary of the content on the page No. 6
Selecting files on the Query for iSeries Select File display .................37 Selecting file members on the Query for iSeries Select Member display ............39 Selecting record formats on the Query for iSeries Select Record Format display .........40 Displaying all files selected on the Query for iSeries Display File Selections display........41 Joining files in a Query for iSeries query........................42 Types of joins in a Query for iSeries query ......................43 How to j
Summary of the content on the page No. 7
Letting Query for iSeries select records ........................91 Selecting the records you want in Query for iSeries....................91 Comparison fields in Query for iSeries........................92 Comparison values in Query for iSeries .......................93 Comparison tests in Query for iSeries........................95 Using more than one comparison test in Query for iSeries................101 Adding and removing comparisons in Query for iSeries.................103 Chapter 8. Sele
Summary of the content on the page No. 8
Record on one page in Query for iSeries reports ...................147 Displaying wrapping widths in Query for iSeries reports.................147 Defining output to the printer in Query for iSeries reports ................148 Defining output of Query for iSeries reports to a database file...............154 Using an existing output file definition in Query for iSeries reports .............155 Building a new output file definition in Query for iSeries reports..............156 Using an output data
Summary of the content on the page No. 9
Appendix A. Differences between Query for iSeries and Query/36 ............195 Conceptual Differences..............................195 Operational Differences..............................195 Command differences between System/36 and Query for iSeries commands..........197 Migration differences between System/36 and Query for iSeries definitions...........197 Appendix B. Practice exercise for Query for iSeries query ...............199 Query for iSeries query exercise: Creating an IDDU definition
Summary of the content on the page No. 10
Running a Query for iSeries query.........................251 Running a default query in Query for iSeries.....................251 Selecting records at run time in Query for iSeries ...................251 CCSIDs and Query for iSeries query definition items...................252 CCSID and file selections in Query for iSeries ....................252 CCSID and join tests in Query for iSeries ......................252 CCSID and result field expressions in Query for iSeries.................252 CCSID
Summary of the content on the page No. 11
About Query for iSeries Use Query for iSeries is a decision support utility you can use to obtain information from the DB2 UDB for iSeries. This book describes how to use Query for iSeries to select, arrange, and analyze information stored in one or more database files to produce reports and other data files. You may need to refer to other IBM books for more specific information about a particular topic. For a list of publications related to this book, see the “Bibliography”. Who should read the
Summary of the content on the page No. 12
x Query for iSeries Use V5R2
Summary of the content on the page No. 13
Part 1. Introduction to Query for iSeries Chapter 1. What is Query for iSeries? ........................3 Query for iSeries fundamentals............................3 Files, fields, and record formats in Query for iSeries...................3 Double-byte character set (DBCS) fields in Query for iSeries...............4 UCS2 level 1 character set support in Query for iSeries.................4 Data definition languages and utilities support in Query for iSeries.............4 Query for iSeries definit
Summary of the content on the page No. 14
2 Query for iSeries Use V5R2
Summary of the content on the page No. 15
Chapter 1. What is Query for iSeries? ® Query for iSeries is an IBM licensed program and a decision support utility that can be used to obtain information from the DB2 Universal Database for iSeries database. It can obtain information from any ® database files that have been defined on the system using Operating System/400 (OS/400 ) data description specifications (DDS), the OS/400 interactive data definition utility (IDDU), or DB2 UDB for iSeries Structured Query Language (SQL). You use Query t
Summary of the content on the page No. 16
Another record format, named ZIPADDRESS, might be defined for a file that might be location-oriented and contain only the ZIPCODE, STATE, CITY, and STREETADDR fields, in that order (see Figure 2). ZIPCODE STATE CITY STREETADDR 67891 OR MushroomManor 907 Abbey Hwy 67891 OR St. Paul 19821 Metro Hwy. 67890 OR Piney Island 961 S 19th Ave Figure 2. Three Records in NAMEADDR File (Using Record Format ZIPADDRESS) Query retrieves the data you want from the files you choose. It uses certain fields (and r
Summary of the content on the page No. 17
| v CL and DDS use the same terms and descriptions as IDDU, but they provide additional support for files. | Using DDS and CL commands, you can define and create physical files and logical files to indicate how | fields are to be organized in files. | A physical file contains the fields of data, as records, but logical files do not. A physical file contains at | least one record format. The field order in a physical file determines the format of the records. | A logical file gives a different vi
Summary of the content on the page No. 18
Figure 3. Major Tasks on the Query Menu and the Work with Queries Display 6 Query for iSeries Use V5R2
Summary of the content on the page No. 19
Chapter 2. General operating information for Query for iSeries This chapter describes the general operating information for Query, such as getting started with Query, using prompts and lists, how you can check your query definition before it is finished, how to use the function keys, and error recovery procedures. Practicing with Query for iSeries Appendix B, “Practice exercise for Query for iSeries query”, provides practice examples that you can do in order to quickly become familiar with Query
Summary of the content on the page No. 20
Using Query for iSeries function keys Function keys like Enter, Help, and Print can be used at any time with any query display. However, not all the function keys (such as F3, F4, and F11) apply to all displays. Each display shows, at the bottom of the display, which function keys are commonly used with that display (all the available keys may not be shown). If you want to know how all the available keys work on a particular display, move the cursor to the function key section of that display an
