IBM ISERIES SC41-5210-04 - Manual (Page 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. . . . . . . . . . . . . . . . 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