Name: IBM ISERIES SC41-5210-04
Brand: IBM
Rating: 5 (1 reviews)

To Next Page

To Previous Page

After you have confirmed the fields you want by pressing the Enter key a second time without making any

changes to your sequence choices, Query completes this step and takes you back to the Define the Query

display so that you can continue with other query tasks. If you previously selected more options on the

Define the Query display, Query shows you the first display for the next option.

90 Query for iSeries Use V5R2

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

IBM ISERIES SC41-5210-04 User Manual

Table of Contents

Questions and Answers:

IBM ISERIES SC41-5210-04 Specifications

Related product manuals

Brand	IBM
Model	ISERIES SC41-5210-04
Category	Server
Language	English