IBM ISERIES SC41-5210-04 User Manual

Erserver

Advertising

Table of contents

Document Outline

Contents
About Query for iSeries Use
- Who should read the Query for iSeries Use book
Part 1. Introduction to Query for iSeries
Chapter 1. What is Query for iSeries?
- Query for iSeries fundamentals
- Major functions of Query for iSeries
Chapter 2. General operating information for Query for iSeries
- Practicing with Query for iSeries
- Getting started with Query for iSeries
  - When you are finished working with Query for iSeries
- Telling Query for iSeries what you want
- Using Query for iSeries commands
- Using the Query Utilities menu
- Using the Work with Queries display
- Displaying the format of constants in Query for iSeries
- Query for iSeries profile information
- Handling Query for iSeries messages and errors
  - Changing your Query for iSeries queries
Part 2. Defining and using Query for iSeries query definitions
Chapter 3. Creating a Query for iSeries query definition
- Starting Query for iSeries query definition
- Selecting definition steps when defining a Query for iSeries query
- Considerations for creating Query for iSeries queries
  - Selecting files, records, and fields for Query for iSeries
  - Suggested sequence of tasks for creating Query for iSeries queries
Chapter 4. Specifying and selecting files for a Query for iSeries query
- Specifying file selections for a Query for iSeries query
- Selecting files on the Query for iSeries Select File display
- Selecting file members on the Query for iSeries Select Member display
- Selecting record formats on the Query for iSeries Select Record Format display
- Displaying all files selected on the Query for iSeries Display File Selections display
- Joining files in a Query for iSeries query
- Displaying all join tests in a Query for iSeries query
- Handling missing fields in a Query for iSeries query
  - Handling missing fields during file selection process of a Query for iSeries query
  - Handling missing fields when starting to change or display a Query for iSeries query
Chapter 5. Defining result fields in Query for iSeries
- Creating results fields in Query for iSeries
- Date, time, and timestamp arithmetic operations in Query for iSeries
- Date, time, and timestamp functions in Query for iSeries
- Converting date formats in Query for iSeries
  - Converting date for output to a database file in Query for iSeries
  - Converting date for output to a display or printer in Query for iSeries
- General considerations when creating an expression in Query for iSeries
- Column headings in Query for iSeries
- Length and decimal positions in Query for iSeries
  - Example of defining a result field in Query for iSeries
- Adding or removing result fields in Query for iSeries
Chapter 6. Selecting and sequencing fields in Query for iSeries
- Letting Query for iSeries select and sequence fields
- Selecting fields and specifying their sequence in Query for iSeries
Chapter 7. Selecting records in Query for iSeries
- Letting Query for iSeries select records
- Selecting the records you want in Query for iSeries
Chapter 8. Selecting sort fields in Query for iSeries
- Letting Query for iSeries determine the order of records for you
- Selecting the sort fields you want to use in Query for iSeries
  - Additional sort considerations in Query for iSeries
Chapter 9. Selecting a collating sequence in Query for iSeries
- Letting Query for iSeries select a collating sequence
  - Setting your default collating sequence in Query for iSeries
- Purpose of a collating sequence in Query for iSeries
  - Collating sequence and CCSIDs in Query for iSeries
- How a collating sequence affects Query for iSeries
- Selecting a Query for iSeries collating sequence
Chapter 10. Specifying report column formatting in Query for iSeries
- Formatting the columns of the Query for iSeriesquery report
- Editing numeric fields in Query for iSeries reports
Chapter 11. Specifying report summary functions in Query for iSeries reports
- Types of summary functions in Query for iSeries reports
- Summarizing columns in Query for iSeries reports
- Location of column summary values in Query for iSeries reports
Chapter 12. Defining Query for iSeries report breaks
- Defining a Query for iSeries report break
- Defining report break formatting in Query for iSeries reports
Chapter 13. Selecting output type and output form in Query for iSeries reports
- Selecting the output type and form you want in Query for iSeries reports
Chapter 14. Specifying Query for iSeries processing options
- Purpose of Query for iSeries processing options
- Rounding numeric field values during Query for iSeries processing
- Ignoring decimal data errors during Query for iSeries processing
- Ignoring character substitution warnings during Query for iSeries processing
  - Using collating sequence for all character comparisons during Query for iSeries processing
Chapter 15. Exiting and running a Query for iSeries query
- Ending a Query for iSeries query definition
  - Saving a Query for iSeries query definition
- Running a Query for iSeries query
Chapter 16. Working with Query for iSeries query definitions
- Changing a Query for iSeries query definition
- Copying a Query for iSeries query definition
- Renaming a Query for iSeries query definition
- Deleting a Query for iSeries query definition
- Displaying a Query for iSeries query definition
- Printing a Query for iSeries query definition
  - Information printed for a Query for iSeries query definition
  - Example of printed record format information for a Query for iSeries query definition
Part 3. Advanced information about Query for iSeries
Chapter 17. Additional information about Query for iSeries for programmers
- Files with different record formats in Query for iSeries
- File sharing considerations in Query for iSeries
- Overriding database files in Query for iSeries
- DBCS considerations when defining result fields in Query for iSeries
- Joining files in Query for iSeries
  - Using *ALL in Query for iSeries
- Using fields other than sort fields for report breaks in Query for iSeries
- Result field length and decimal positions in Query for iSeries
Part 4. Appendixes
Appendix A. Differences between Query for iSeries and Query/36
- Conceptual Differences
- Operational Differences
- Command differences between System/36 and Query for iSeries commands
- Migration differences between System/36 and Query for iSeries definitions
Appendix B. Practice exercise for Query for iSeries query
- Query for iSeries query exercise: Creating an IDDU definition
- Query for iSeries query exercise: Creating a database file
- Query for iSeries query exercise: Entering data
- Query for iSeries query exercise: Creating and running a query
  - Query for iSeries query exercise: Creating a query
- Query for iSeries query exercise: Changing a query
- Query for iSeries query exercise: Creating an advanced query
Appendix C. Query for iSeries performance tips and techniques
- Introduction to Query for iSeries query processing
- File definitions and data in Query for iSeries
  - File definitions in Query for iSeries
  - File data considerations for Query for iSeries
- Defining queries for Query for iSeries
- Using join operations in Query for iSeries
  - Performance tips for join operations in Query for iSeries
- Miscellaneous tips and techniques for Query for iSeries
- Query for iSeries status messages
- Query for iSeries debug mode messages
Appendix D. Preventing users from running Query for iSeries queries interactively
Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries
- CCSID marking in Query for iSeries
- CCSIDs and collating sequences in Query for iSeries
  - Query for iSeries language sequences
- CCSID conversions for Query for iSeries options and functions
- CCSIDs and Query for iSeries query definition items
- CCSID compatibility considerations in Query for iSeries
Bibliography
Notices
- Trademarks
Index

Popular Brands

Popular manuals