IBM ISERIES SC41-5210-04

294 pages

To Next Page

To Next Page

To Previous Page

To Previous Page

Loading...

iSeries

Query for iSeries Use

Version 5

SC41-5210-04

ER s e r v e r



Table of Contents

Default Chapter5
- Table of Contents5
About Query for Iseries Use11
- Who Should Read the Query for Iseries Use Book11
Part 1. Introduction to Query for Iseries13
Chapter 1. What Is Query for Iseries15
- Query for Iseries Fundamentals15
- Major Functions of Query for Iseries17
Chapter 2. General Operating Information for Query for Iseries19
- Practicing with Query for Iseries19
- Getting Started with Query for Iseries19
  - When You Are Finished Working with Query for Iseries19
- Telling Query for Iseries What You Want19
- Using Query for Iseries Commands23
- Using the Query Utilities Menu23
- Using the Work with Queries Display24
- Displaying the Format of Constants in Query for Iseries29
  - Other Considerations When You Are Trying to Locate or Use a Particular Query for Iseries Query29
- Query for Iseries Profile Information30
- Handling Query for Iseries Messages and Errors30
  - Changing Your Query for Iseries Queries30
Part 2. Defining and Using Query for Iseries Query Definitions33
Chapter 3. Creating a Query for Iseries Query Definition39
- Starting Query for Iseries Query Definition39
- Selecting Definition Steps When Defining a Query for Iseries Query40
- Considerations for Creating Query for Iseries Queries42
  - Selecting Files, Records, and Fields for Query for Iseries42
  - Suggested Sequence of Tasks for Creating Query for Iseries Queries43
Chapter 4. Specifying and Selecting Files for a Query for Iseries Query45
- Specifying File Selections for a Query for Iseries Query45
- Selecting File Members on the Query for Iseries Select Member Display51
- Selecting Record Formats on the Query for Iseries Select Record Format Display52
- Displaying All Files Selected on the Query for Iseries Display File Selections Display53
- Joining Files in a Query for Iseries Query54
- Displaying All Join Tests in a Query for Iseries Query65
- Handling Missing Fields in a Query for Iseries Query66
  - Handling Missing Fields During File Selection Process of a Query for Iseries Query67
  - Handling Missing Fields When Starting to Change or Display a Query for Iseries Query67
Chapter 5. Defining Result Fields in Query for Iseries69
- Creating Results Fields in Query for Iseries69
- Date, Time, and Timestamp Arithmetic Operations in Query for Iseries81
- Date, Time, and Timestamp Functions in Query for Iseries86
- Converting Date Formats in Query for Iseries92
- General Considerations When Creating an Expression in Query for Iseries95
- Column Headings in Query for Iseries97
- Length and Decimal Positions in Query for Iseries97
  - Example of Defining a Result Field in Query for Iseries98
- Adding or Removing Result Fields in Query for Iseries98
Chapter 6. Selecting and Sequencing Fields in Query for Iseries99
- Letting Query for Iseries Select and Sequence Fields99
- Selecting Fields and Specifying Their Sequence in Query for Iseries99
Chapter 7. Selecting Records in Query for Iseries103
- Letting Query for Iseries Select Records103
- Selecting the Records You Want in Query for Iseries103
Chapter 8. Selecting Sort Fields in Query for Iseries117
- Letting Query for Iseries Determine the Order of Records for You117
- Selecting the Sort Fields You Want to Use in Query for Iseries117
  - Additional Sort Considerations in Query for Iseries120
Chapter 9. Selecting a Collating Sequence in Query for Iseries123
- Letting Query for Iseries Select a Collating Sequence123
  - Setting Your Default Collating Sequence in Query for Iseries123
- Purpose of a Collating Sequence in Query for Iseries123
  - Collating Sequence and Ccsids in Query for Iseries124
- How a Collating Sequence Affects Query for Iseries124
- Selecting a Query for Iseries Collating Sequence125
Chapter 10. Specifying Report Column Formatting in Query for Iseries131
- Formatting the Columns of the Query for Iseriesquery Report131
- Editing Numeric Fields in Query for Iseries Reports134
Chapter 11. Specifying Report Summary Functions in Query for Iseries Reports147
- Types of Summary Functions in Query for Iseries Reports147
- Location of Column Summary Values in Query for Iseries Reports149
- Summarizing Columns in Query for Iseries Reports149
Chapter 12. Defining Query for Iseries Report Breaks151
- Defining a Query for Iseries Report Break151
- Defining Report Break Formatting in Query for Iseries Reports155
Chapter 13. Selecting Output Type and Output Form in Query for Iseries Reports157
- Selecting the Output Type and Form You Want in Query for Iseries Reports157
Chapter 14. Specifying Query for Iseries Processing Options175
- Purpose of Query for Iseries Processing Options175
- Ignoring Decimal Data Errors During Query for Iseries Processing176
- Rounding Numeric Field Values During Query for Iseries Processing176
- Ignoring Character Substitution Warnings During Query for Iseries Processing177
  - Using Collating Sequence for All Character Comparisons During Query for Iseries Processing177
Chapter 15. Exiting and Running a Query for Iseries Query179
- Ending a Query for Iseries Query Definition179
- Running a Query for Iseries Query181
- Changing a Query for Iseries Query Definition185
Chapter 16. Working with Query for Iseries Query Definitions185
- Copying a Query for Iseries Query Definition189
- Deleting a Query for Iseries Query Definition190
- Renaming a Query for Iseries Query Definition190
- Displaying a Query for Iseries Query Definition191
- Printing a Query for Iseries Query Definition192
  - Information Printed for a Query for Iseries Query Definition193
  - Example of Printed Record Format Information for a Query for Iseries Query Definition194
Part 3. Advanced Information about Query for Iseries197
Chapter 17. Additional Information about Query for Iseries for Programmers199
- DBCS Considerations When Defining Result Fields in Query for Iseries199
- File Sharing Considerations in Query for Iseries199
- Files with Different Record Formats in Query for Iseries199
- Overriding Database Files in Query for Iseries199
- Joining Files in Query for Iseries200
  - Using *ALL in Query for Iseries200
- Result Field Length and Decimal Positions in Query for Iseries200
- Using Fields Other than Sort Fields for Report Breaks in Query for Iseries200
Part 4. Appendixes205
Appendix A. Differences between Query for Iseries and Query/36207
- Conceptual Differences207
- Operational Differences207
- Command Differences between System/36 and Query for Iseries Commands209
- Migration Differences between System/36 and Query for Iseries Definitions209
Appendix B. Practice Exercise for Query for Iseries Query211
- Query for Iseries Query Exercise: Creating an IDDU Definition211
- Query for Iseries Query Exercise: Creating a Database File215
- Query for Iseries Query Exercise: Entering Data215
- Query for Iseries Query Exercise: Creating and Running a Query218
  - Query for Iseries Query Exercise: Creating a Query219
- Query for Iseries Query Exercise: Changing a Query223
- Query for Iseries Query Exercise: Creating an Advanced Query227
Appendix C. Query for Iseries Performance Tips and Techniques243
- Introduction to Query for Iseries Query Processing243
- File Definitions and Data in Query for Iseries245
  - File Definitions in Query for Iseries245
  - File Data Considerations for Query for Iseries246
- Defining Queries for Query for Iseries246
- Using Join Operations in Query for Iseries250
  - Performance Tips for Join Operations in Query for Iseries251
- Miscellaneous Tips and Techniques for Query for Iseries252
- Query for Iseries Status Messages253
- Query for Iseries Debug Mode Messages254
Appendix D. Preventing Users from Running Query for Iseries Queries Interactively255
Appendix E. Coded Character Set Identifiers (Ccsids) in Query for Iseries257
- CCSID Marking in Query for Iseries259
- Ccsids and Collating Sequences in Query for Iseries260
  - Query for Iseries Language Sequences261
- CCSID Conversions for Query for Iseries Options and Functions261
- Ccsids and Query for Iseries Query Definition Items264
- CCSID Compatibility Considerations in Query for Iseries266
Bibliography271
Notices273
- Trademarks274
- Index275

Related product manuals

IBM iSeries 810

IBM iSeries 820

IBM iSeries 800

IBM iSeries 270

Preview: IBM iSeries Series

IBM iSeries Series

Preview: IBM i Series

Preview: IBM System x3200 M3

IBM System x3200 M3

Preview: IBM System x3250 M4

IBM System x3250 M4

Preview: IBM System x3650 M4 Type 7915

IBM System x3650 M4 Type 7915