Home
IBM
Server
ISERIES SC41-5210-04
IBM ISERIES SC41-5210-04 User Manual
5
of 1
of 1 rating
294 pages
Give review
Manual
Specs
To Next Page
To Next Page
To Previous Page
To Previous Page
Loading...
Query
performs
the
file
join
in
two
steps:
Step
1:
Join
the
first
two
files,
A
and
C
.
Query
joins
the
files
in
the
order
listed,
starting
with
file
A
(
CUSTOMER
),
and
file
C
(
ITEM
).
But
there
is
no
join
test
that
compares
a
field
in
A
to
a
field
in
C
.
Query
joins
every
record
in
file
A
(one
record
at
a
time)
to
52
Query
for
iSeries
Use
V5R2
63
65
Table of Contents
Default Chapter
5
Table of Contents
5
About Query for Iseries Use
11
Who Should Read the Query for Iseries Use Book
11
Part 1. Introduction to Query for Iseries
13
Chapter 1. What Is Query for Iseries
15
Query for Iseries Fundamentals
15
Files, Fields, and Record Formats in Query for Iseries
15
Double-Byte Character Set (DBCS) Fields in Query for Iseries
16
UCS2 Level 1 Character Set Support in Query for Iseries
16
Data Definition Languages and Utilities Support in Query for Iseries
16
Query for Iseries Definitions
17
Libraries in Query for Iseries
17
Major Functions of Query for Iseries
17
Chapter 2. General Operating Information for Query for Iseries
19
Practicing with Query for Iseries
19
Getting Started with Query for Iseries
19
When You Are Finished Working with Query for Iseries
19
Telling Query for Iseries What You Want
19
Using Prompts and Default Values in Query for Iseries
19
Using Query for Iseries Function Keys
20
Checking the Results before Printing the Query for Iseries Report
20
Using Lists in Query for Iseries
21
Printing What You See on Your Query for Iseries Display
21
Displaying a Query for Iseries List
21
Selecting Items in a Query for Iseries List
22
Special Library Names in Query for Iseries
22
Using Query for Iseries Commands
23
Using the Query Utilities Menu
23
Using the Work with Queries Display
24
Choosing a Single Query for Iseries Task
24
Choosing Multiple Query for Iseries Tasks
25
Specifying a Query for Iseries Query and Its Library
25
Working with a List of Query for Iseries Queries
26
Selecting a Query for Iseries Query Name from a List
26
Using Query for Iseries List Subsets
26
Positioning a List of Query for Iseries Queries
27
Using F11 to Display Additional Information about Query for Iseries Queries
27
Selecting a Library for Your Query for Iseries Queries
28
Displaying the Format of Constants in Query for Iseries
29
Other Considerations When You Are Trying to Locate or Use a Particular Query for Iseries Query
29
Query for Iseries Profile Information
30
Handling Query for Iseries Messages and Errors
30
Changing Your Query for Iseries Queries
30
Part 2. Defining and Using Query for Iseries Query Definitions
33
Chapter 3. Creating a Query for Iseries Query Definition
39
Starting Query for Iseries Query Definition
39
Selecting Definition Steps When Defining a Query for Iseries Query
40
Selecting Options for a Query for Iseries Query Definition
41
Moving through the Query for Iseries Definition Displays
42
When You Return to the Query for Iseries Define the Query Display
42
Considerations for Creating Query for Iseries Queries
42
Selecting Files, Records, and Fields for Query for Iseries
42
Suggested Sequence of Tasks for Creating Query for Iseries Queries
43
Chapter 4. Specifying and Selecting Files for a Query for Iseries Query
45
Specifying File Selections for a Query for Iseries Query
45
Choosing a File for a Query for Iseries Query
46
Choosing a Library for a Query for Iseries Query
46
Choosing a Member or Record Format for a Query for Iseries Query
47
Selecting Multiple Files for a Query for Iseries Query
47
Confirming Your Options for a Query for Iseries Query
48
Handling Errors on the Query for Iseries Specify File Selections Display
48
Using File Ids for a Query for Iseries Query
48
Removing a Option for a Query for Iseries Query
48
Selecting Files on the Query for Iseries Select File Display
49
Selecting File Members on the Query for Iseries Select Member Display
51
Selecting Record Formats on the Query for Iseries Select Record Format Display
52
Displaying All Files Selected on the Query for Iseries Display File Selections Display
53
Joining Files in a Query for Iseries Query
54
Types of Joins in a Query for Iseries Query
55
How to Join Files in a Query for Iseries Query
55
Rules for Joining Files in a Query for Iseries Query
56
Examples of Joining Files in a Query for Iseries Query
58
Example: Selecting Matched Records from All Selected Files in a Query for Iseries Query
59
Example: Selecting Matched Records Using a Primary File in a Query for Iseries Query
60
Example: Selecting Unmatched Primary File Records in a Query for Iseries Query
60
Sequencing Secondary Files for a Primary Join in a Query for Iseries Query
61
Example: Sequencing Secondary Files in a Query for Iseries Query
61
Displaying All Join Tests in a Query for Iseries Query
65
Handling Missing Fields in a Query for Iseries Query
66
Handling Missing Fields During File Selection Process of a Query for Iseries Query
67
Handling Missing Fields When Starting to Change or Display a Query for Iseries Query
67
Chapter 5. Defining Result Fields in Query for Iseries
69
Creating Results Fields in Query for Iseries
69
Query for Iseries Result Field Name
70
Query for Iseries Expressions
70
Query for Iseries Numeric Expressions
71
Query for Iseries Character Expressions
72
Query for Iseries Concatenation Operation
72
Query for Iseries Character Functions
73
SUBSTR Query for Iseries Function
73
DIGITS Query for Iseries Function
74
VALUE Query for Iseries Function
74
VARCHAR Query for Iseries Function
75
VARGRAPHIC Query for Iseries Function
77
Date, Time, and Timestamp Expressions in Query for Iseries
78
Query for Iseries Date
79
Query for Iseries Time
79
Query for Iseries Timestamp
80
Displaying Constants Format in Query for Iseries
81
Date, Time, and Timestamp Arithmetic Operations in Query for Iseries
81
Date Arithmetic Operation in Query for Iseries
82
Subtracting Dates in Query for Iseries
82
Incrementing and Decrementing Dates in Query for Iseries
83
Converting a Numeric Field to a Date Field in Query for Iseries
83
Working with Numeric Dates in Query for Iseries
83
Time Arithmetic Operation in Query for Iseries
85
Durations in Query for Iseries
85
Incrementing and Decrementing Times in Query for Iseries
85
Timestamp Arithmetic Operation in Query for Iseries
85
Labeled Duration in Query for Iseries
85
Date Duration in Query for Iseries
85
Time Duration in Query for Iseries
85
Date, Time, and Timestamp Functions in Query for Iseries
86
CHAR Query for Iseries Function
86
Timestamp Duration in Query for Iseries
86
DATE Query for Iseries Function
87
DAY Query for Iseries Function
87
DAYS Query for Iseries Function
88
HOUR Query for Iseries Function
88
MICROSECOND Query for Iseries Function
89
MINUTE Query for Iseries Function
89
MONTH Query for Iseries Function
90
SECOND Query for Iseries Function
90
TIME Query for Iseries Function
91
TIMESTAMP Query for Iseries Function
91
YEAR Query for Iseries Function
92
Additional Date, Time, and Timestamp Functions in Query for Iseries
92
Converting Date Formats in Query for Iseries
92
Converting Date for Output to a Database File in Query for Iseries
92
Converting Date for Output to a Display or Printer in Query for Iseries
93
Example 1-Converting from MMDDYY to YYDDD Format in Query for Iseries
93
Example 2-Converting from MMDDYY to YYDDD Format in Query for Iseries
93
Example 3-Converting from YYDDD to MMDDYY Format in Query for Iseries
94
Example 4-Converting from MMDDYY to YYDD Format in Query for Iseries
94
General Considerations When Creating an Expression in Query for Iseries
95
Column Headings in Query for Iseries
97
Length and Decimal Positions in Query for Iseries
97
Example of Defining a Result Field in Query for Iseries
98
Adding or Removing Result Fields in Query for Iseries
98
Chapter 6. Selecting and Sequencing Fields in Query for Iseries
99
Letting Query for Iseries Select and Sequence Fields
99
Selecting Fields and Specifying Their Sequence in Query for Iseries
99
Chapter 7. Selecting Records in Query for Iseries
103
Letting Query for Iseries Select Records
103
Selecting the Records You Want in Query for Iseries
103
Comparison Fields in Query for Iseries
104
Comparison Values in Query for Iseries
105
Fields as Values in Query for Iseries
106
Character Constants as Values in Query for Iseries
106
Numeric Constants as Values in Query for Iseries
106
Comparison Tests in Query for Iseries
107
Date, Time, Timestamp Constants as Values in Query for Iseries
107
Null Values in Query for Iseries
107
Date, Time, or Timestamp Comparisons in Query for Iseries
108
Testing for Equal (EQ) and Not Equal (NE) in Query for Iseries
108
Testing for IS Null (IS) and ISNOT Null (ISNOT) in Query for Iseries
108
Testing for Greater (GT or GE), Less (LT or LE), and Range (RANGE) in Query for Iseries
108
Testing for Values in a List (LIST NLIST) in Query for Iseries
109
Testing for Values that Are Similar (LIKE NLIKE) in Query for Iseries
110
Testing for DBCS LIKE (Like) and NLIKE (Not Like) in Query for Iseries
111
Using more than One Comparison Test in Query for Iseries
113
Adding and Removing Comparisons in Query for Iseries
115
Chapter 8. Selecting Sort Fields in Query for Iseries
117
Letting Query for Iseries Determine the Order of Records for You
117
Selecting the Sort Fields You Want to Use in Query for Iseries
117
Additional Sort Considerations in Query for Iseries
120
Chapter 9. Selecting a Collating Sequence in Query for Iseries
123
Letting Query for Iseries Select a Collating Sequence
123
Setting Your Default Collating Sequence in Query for Iseries
123
Purpose of a Collating Sequence in Query for Iseries
123
Collating Sequence and Ccsids in Query for Iseries
124
How a Collating Sequence Affects Query for Iseries
124
Selecting a Query for Iseries Collating Sequence
125
Using the Hexadecimal Collating Sequence in Query for Iseries
125
Using the Language Collating Sequence for Your Country in Query for Iseries
126
Defining Your Own Collating Sequence in Query for Iseries
127
Selecting a Translation Table in Query for Iseries
128
Selecting a System Sort Sequence in Query for Iseries
129
Chapter 10. Specifying Report Column Formatting in Query for Iseries
131
Formatting the Columns of the Query for Iseriesquery Report
131
Column Spacing in Query for Iseries Reports
131
Column Headings in Query for Iseries Reports
131
Length and Decimal Positions in Query for Iseries Reports
132
Omitting Fields from a Query for Iseries Report
133
Editing Numeric Fields in Query for Iseries Reports
134
Defining Numeric Field Editing in Query for Iseries Reports
134
Describing Numeric Field Editing in Query for Iseries Reports
136
Decimal Point in Query for Iseries Reports
137
Thousands Separator in Query for Iseries Reports
137
Show Negative Sign in Query for Iseries Reports
137
Left Negative Sign in Query for Iseries Reports
137
Right Negative Sign in Query for Iseries Reports
138
Show Currency Symbol in Query for Iseries Reports
138
Left Currency Symbol in Query for Iseries Reports
138
Right Currency Symbol in Query for Iseries Reports
138
Describing Date/Time Field Editing Display in Query for Iseries Reports
139
Print Zero Value in Query for Iseries Reports
139
Replace Leading Zeros in Query for Iseries Reports
139
Replace with Option in Query for Iseries Reports
139
Single Leading Zero in Query for Iseries Reports
139
Date/Time Separator in Query for Iseries Reports
140
Specifying an Edit Code in Query for Iseries Reports
141
Edit Code in Query for Iseries Reports
141
Specifying Edit Words
143
Optional Edit Code Modifier in Query for Iseries Reports
143
Edit Word in Query for Iseries Reports
143
Edit Word for Summary Total in Query for Iseries Reports
145
Chapter 11. Specifying Report Summary Functions in Query for Iseries Reports
147
Types of Summary Functions in Query for Iseries Reports
147
Location of Column Summary Values in Query for Iseries Reports
149
Summarizing Columns in Query for Iseries Reports
149
Chapter 12. Defining Query for Iseries Report Breaks
151
Defining a Query for Iseries Report Break
151
Defining Report Break Formatting in Query for Iseries Reports
155
Skip to New Page in Query for Iseries Reports
155
Suppress Summaries in Query for Iseries Reports
155
Break Text in Query for Iseries Reports
156
Chapter 13. Selecting Output Type and Output Form in Query for Iseries Reports
157
Selecting the Output Type and Form You Want in Query for Iseries Reports
157
Form of Output of Query for Iseries Reports
158
Line Wrapping in Query for Iseries Reports
158
Wrapping Width in Query for Iseries Reports
159
Record on One Page in Query for Iseries Reports
159
Displaying Wrapping Widths in Query for Iseries Reports
159
Defining Output to the Printer in Query for Iseries Reports
160
Printer Device in Query for Iseries Reports
161
Form Size in Query for Iseries Reports
161
Start Line in Query for Iseries Reports
162
End Line in Query for Iseries Reports
162
Line Spacing in Query for Iseries Reports
162
Print Definition in Query for Iseries Reports
162
Specifying Spooled Output Overrides in Query for Iseries Reports
162
Defining the Printout Cover Page of Query for Iseries Reports
164
Defining the Page Headings and Footings in Query for Iseries Reports
165
Defining Output of Query for Iseries Reports to a Database File
166
Using an Existing Output File Definition in Query for Iseries Reports
167
Building a New Output File Definition in Query for Iseries Reports
168
Specifying an Output Database File for Query for Iseries Reports
169
Summary-Only Output of a Query for Iseries Report to a Database File
172
Using an Output Database File Created by Query for Iseries
173
Chapter 14. Specifying Query for Iseries Processing Options
175
Purpose of Query for Iseries Processing Options
175
Ignoring Decimal Data Errors During Query for Iseries Processing
176
Rounding Numeric Field Values During Query for Iseries Processing
176
Ignoring Character Substitution Warnings During Query for Iseries Processing
177
Using Collating Sequence for All Character Comparisons During Query for Iseries Processing
177
Chapter 15. Exiting and Running a Query for Iseries Query
179
Ending a Query for Iseries Query Definition
179
Saving a Query for Iseries Query Definition
179
Storing the Query for Iseries Query Definition
179
Describing the Query for Iseries Query Definition
180
Giving Authority to Others to Your Query for Iseries Query
180
Running a Query for Iseries Query
181
Using Function Key F5 When Running a Query for Iseries Query
181
Running a Query for Iseries Query from the Query for Iseries Menu
181
Running a Query for Iseries Query from the Exit this Query Display
181
Running a Query for Iseries Query from the Work with Queries Display
182
Running a Query for Iseries Query Using the RUNQRY Command
183
Changing a Query for Iseries Query Definition
185
Starting Changes by Copying a Query for Iseries Query Definition
185
Changes You Can Make to a Query for Iseries Query
185
Considerations for Changing Query for Iseries Queries
188
Changing Your Collating Sequence on Query for Iseries Queries
188
Chapter 16. Working with Query for Iseries Query Definitions
185
Copying a Query for Iseries Query Definition
189
Deleting a Query for Iseries Query Definition
190
Renaming a Query for Iseries Query Definition
190
Displaying a Query for Iseries Query Definition
191
Printing a Query for Iseries Query Definition
192
Information Printed for a Query for Iseries Query Definition
193
Example of Printed Record Format Information for a Query for Iseries Query Definition
194
Part 3. Advanced Information about Query for Iseries
197
Chapter 17. Additional Information about Query for Iseries for Programmers
199
DBCS Considerations When Defining Result Fields in Query for Iseries
199
File Sharing Considerations in Query for Iseries
199
Files with Different Record Formats in Query for Iseries
199
Overriding Database Files in Query for Iseries
199
Joining Files in Query for Iseries
200
Using *ALL in Query for Iseries
200
Result Field Length and Decimal Positions in Query for Iseries
200
Tips for Dealing with Presentation Length and Decimal Positions in Query for Iseries
200
Length and Decimal Positions Used for Internal Numeric Calculations in Query for Iseries
201
Addition and Subtraction in Query for Iseries
201
Multiplication in Query for Iseries
201
Division in Query for Iseries
201
Example: Increasing the Decimal Precision for Result Fields in Query for Iseries
202
Selecting Records (Ignoring Field Case) in Query for Iseries
203
Using Fields Other than Sort Fields for Report Breaks in Query for Iseries
200
Part 4. Appendixes
205
Appendix A. Differences between Query for Iseries and Query/36
207
Conceptual Differences
207
Operational Differences
207
Command Differences between System/36 and Query for Iseries Commands
209
Migration Differences between System/36 and Query for Iseries Definitions
209
Appendix B. Practice Exercise for Query for Iseries Query
211
Query for Iseries Query Exercise: Creating an IDDU Definition
211
Query for Iseries Query Exercise: Creating a Database File
215
Query for Iseries Query Exercise: Entering Data
215
Query for Iseries Query Exercise: Creating and Running a Query
218
Query for Iseries Query Exercise: Creating a Query
219
Query for Iseries Query Exercise: Changing a Query
223
Query for Iseries Query Exercise: Creating an Advanced Query
227
Appendix C. Query for Iseries Performance Tips and Techniques
243
Introduction to Query for Iseries Query Processing
243
Keyed Sequence Access Paths in Query for Iseries
243
Select/Omit Access Paths in Query for Iseries
244
Access Plans in Query for Iseries
244
File Definitions and Data in Query for Iseries
245
File Definitions in Query for Iseries
245
File Data Considerations for Query for Iseries
246
Defining Queries for Query for Iseries
246
Query for Iseries Performance When Designing or Changing Queries
246
Define Result Fields in Query for Iseries
247
Select and Sequence Fields in Query for Iseries
247
Select Records in Query for Iseries
247
Select Sort Fields in Query for Iseries
248
Select Collating Sequence in Query for Iseries
249
Specify Report Summary Functions in Query for Iseries
249
Select Output Type and Output Form in Query for Iseries
249
Specify Processing Options in Query for Iseries
250
Using Join Operations in Query for Iseries
250
Performance Tips for Join Operations in Query for Iseries
251
Miscellaneous Tips and Techniques for Query for Iseries
252
Batch Processing for Query for Iseries
252
Query for Iseries Performance Tuning
253
Query for Iseries Migration Considerations N to N-1
253
Query for Iseries Status Messages
253
Query for Iseries Debug Mode Messages
254
Appendix D. Preventing Users from Running Query for Iseries Queries Interactively
255
Appendix E. Coded Character Set Identifiers (Ccsids) in Query for Iseries
257
CCSID Marking in Query for Iseries
259
Ccsids and Collating Sequences in Query for Iseries
260
Query for Iseries Language Sequences
261
CCSID Conversions for Query for Iseries Options and Functions
261
Displaying a Query for Iseries Query
261
Changing a Query for Iseries Query
262
Getting a List of Objects with Text in Query for Iseries
262
Defining a Query for Iseries Query
262
Defining a Collating Sequence in Query for Iseries
262
Getting a List of Formats or Members with Text in Query for Iseries
263
Saving a Query for Iseries Query Definition
263
Running a Query for Iseries Query
263
Running a Default Query in Query for Iseries
263
Selecting Records at Run Time in Query for Iseries
263
Ccsids and Query for Iseries Query Definition Items
264
CCSID and File Selections in Query for Iseries
264
CCSID and Join Tests in Query for Iseries
264
CCSID and Result Field Expressions in Query for Iseries
264
CCSID and Result Field Column Headings in Query for Iseries
265
CCSID and Sort Fields in Query for Iseries
265
CCSID and Record Selection Tests in Query for Iseries
265
CCSID and Summary Functions in Query for Iseries
265
CCSID and Column Formatting and Editing in Query for Iseries
265
CCSID and Report Breaks in Query for Iseries
265
CCSID and Break and Final Text in Query for Iseries
265
CCSID and Cover Page, Page Headings and Footings in Query for Iseries
265
CCSID Compatibility Considerations in Query for Iseries
266
Bibliography
271
Notices
273
Trademarks
274
Index
275
5
Based on 1 rating
Ask a question
Give review
Questions and Answers:
Need help?
Do you have a question about the IBM ISERIES SC41-5210-04 and is the answer not in the manual?
Ask a question
IBM ISERIES SC41-5210-04 Specifications
General
Brand
IBM
Model
ISERIES SC41-5210-04
Category
Server
Language
English
Related product manuals
IBM iSeries 810
622 pages
IBM iSeries 820
46 pages
IBM iSeries 800
622 pages
IBM iSeries 270
46 pages
IBM iSeries Series
512 pages
IBM i 830
1000 pages
IBM i Series
46 pages
IBM System i
290 pages
IBM eserver i5
940 pages
IBM System x3200 M3
17 pages
IBM System x3250 M4
108 pages
IBM System x3650 M4 Type 7915
192 pages
To Next PageTo Next PageTo Previous PageTo Previous Page
Loading...
Need help?
General
