IBM SC41-5210-04 manual Appendix B. Practice exercise for Query for iSeries query

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	. . . . . .	.	.	199
Query for iSeries query exercise: Creating a database file	. . . . . .	.	.	203
Query for iSeries query exercise: Entering data	. . . . . .	.	.	203
Query for iSeries query exercise: Creating and running a query	. . . . . .	.	.	206
Query for iSeries query exercise: Creating a query	. . . . . .	.	.	207
Query for iSeries query exercise: Changing a query	. . . . . .	.	.	211
Query for iSeries query exercise: Creating an advanced query	. . . . . .	.	.	215
Appendix C. Query for iSeries performance tips and techniques	. . . . . .	.	.	231
Introduction to Query for iSeries query processing	. . . . . .	.	.	231
Keyed sequence access paths in Query for iSeries	. . . . . .	.	.	231
Select/omit access paths in Query for iSeries	. . . . . .	.	.	232
Access plans in Query for iSeries	. . . . . .	.	.	232
File definitions and data in Query for iSeries	. . . . . .	.	.	233
File definitions in Query for iSeries	. . . . . .	.	.	233
File data considerations for Query for iSeries	. . . . . .	.	.	234
Defining queries for Query for iSeries	. . . . . .	.	.	234
Query for iSeries performance when designing or changing queries . . . .	. . . . . .	.	.	234
Define result fields in Query for iSeries	. . . . . .	.	.	235
Select and sequence fields in Query for iSeries	. . . . . .	.	.	235
Select records in Query for iSeries	. . . . . .	.	.	235
Select sort fields in Query for iSeries	. . . . . .	.	.	236
Select collating sequence in Query for iSeries	. . . . . .	.	.	237
Specify report summary functions in Query for iSeries	. . . . . .	.	.	237
Select output type and output form in Query for iSeries	. . . . . .	.	.	237
Specify processing options in Query for iSeries	. . . . . .	.	.	238
Using join operations in Query for iSeries	. . . . . .	.	.	238
Performance tips for join operations in Query for iSeries	. . . . . .	.	.	239
Miscellaneous tips and techniques for Query for iSeries	. . . . . .	.	.	240
Batch processing for Query for iSeries	. . . . . .	.	.	240
Query for iSeries performance tuning	. . . . . .	.	.	241
Query for iSeries migration considerations N to N-1	. . . . . .	.	.	241
Query for iSeries status messages	. . . . . .	.	.	241
Query for iSeries debug mode messages	. . . . . .	.	.	242

Appendix D. Preventing users from running Query for iSeries queries interactively. . . . . . 243

Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries . .	. . . . . .	.	245
CCSID marking in Query for iSeries	. . . . . .	.	247
CCSIDs and collating sequences in Query for iSeries	. . . . . .	.	248
Query for iSeries language sequences	. . . . . .	.	249
CCSID conversions for Query for iSeries options and functions	. . . . . .	.	249
Displaying a Query for iSeries query	. . . . . .	.	249
Changing a Query for iSeries query	. . . . . .	.	250
Getting a list of objects with text in Query for iSeries	. . . . . .	.	250
Defining a Query for iSeries query	. . . . . .	.	250
Defining a collating sequence in Query for iSeries	. . . . . .	.	250
Getting a list of formats or members with text in Query for iSeries	. . . . . .	.	251
Saving a Query for iSeries query definition	. . . . . .	.	251

Contents vii