Filter
Top Products
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