IBM ISERIES SC41-5210-04 User Manual
Erserver
Table of contents
Document Outline
- Contents
- About Query for iSeries Use
- Part 1. Introduction to Query for iSeries
- Chapter 1. What is Query for iSeries?
- Chapter 2. General operating information for Query for iSeries
- Practicing with Query for iSeries
- Getting started 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
- Part 2. Defining and using Query for iSeries query definitions
- Chapter 3. Creating a Query for iSeries query definition
- Chapter 4. Specifying and selecting files for a Query for iSeries query
- Specifying file selections for a Query for iSeries query
- Choosing a file for a Query for iSeries query
- Choosing a library for a Query for iSeries query
- Choosing a member or record format for a Query for iSeries query
- Selecting multiple files for a Query for iSeries query
- Confirming your options for a Query for iSeries query
- Handling errors on the Query for iSeries Specify File Selections display
- 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
- Specifying file selections for 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
- CHAR Query for iSeries function
- DATE Query for iSeries function
- DAY Query for iSeries function
- DAYS Query for iSeries function
- HOUR Query for iSeries function
- MICROSECOND Query for iSeries function
- MINUTE Query for iSeries function
- MONTH Query for iSeries function
- SECOND Query for iSeries function
- TIME Query for iSeries function
- TIMESTAMP Query for iSeries function
- YEAR Query for iSeries function
- Additional date, time, and timestamp functions in Query for iSeries
- Converting date formats 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
- Adding or removing result fields in Query for iSeries
- Chapter 6. Selecting and sequencing fields 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
- Comparison fields in Query for iSeries
- Comparison values in Query for iSeries
- Comparison tests in Query for iSeries
- Date, time, or timestamp comparisons in Query for iSeries
- Testing for equal (EQ) and not equal (NE) in Query for iSeries
- Testing for IS Null (IS) and ISNOT Null (ISNOT) in Query for iSeries
- Testing for greater (GT or GE), less (LT or LE), and range (RANGE) in Query for iSeries
- Testing for values in a list (LIST NLIST) in Query for iSeries
- Testing for values that are similar (LIKE NLIKE) in Query for iSeries
- Testing for DBCS LIKE (like) and NLIKE (not like) in Query for iSeries
- Using more than one comparison test in Query for iSeries
- Adding and removing comparisons in Query for iSeries
- Chapter 8. Selecting sort fields in Query for iSeries
- Chapter 9. Selecting a collating sequence in Query for iSeries
- 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
- Defining numeric field editing in Query for iSeries reports
- Describing numeric field editing in Query for iSeries reports
- Decimal point in Query for iSeries reports
- Thousands separator in Query for iSeries reports
- Show negative sign in Query for iSeries reports
- Left negative sign in Query for iSeries reports
- Right negative sign in Query for iSeries reports
- Show currency symbol in Query for iSeries reports
- Left currency symbol in Query for iSeries reports
- Right currency symbol in Query for iSeries reports
- Print zero value in Query for iSeries reports
- Replace leading zeros in Query for iSeries reports
- Replace with option in Query for iSeries reports
- Single leading zero in Query for iSeries reports
- Describing date/time field editing display in Query for iSeries reports
- Specifying an edit code in Query for iSeries reports
- Specifying edit words
- Chapter 11. Specifying report summary functions in Query for iSeries reports
- Chapter 12. Defining Query for iSeries report breaks
- 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
- Form of output of Query for iSeries reports
- Line wrapping in Query for iSeries reports
- Wrapping width in Query for iSeries reports
- Record on one page in Query for iSeries reports
- Displaying wrapping widths in Query for iSeries reports
- Defining output to the printer in Query for iSeries reports
- Printer device in Query for iSeries reports
- Form size in Query for iSeries reports
- Start line in Query for iSeries reports
- End line in Query for iSeries reports
- Line spacing in Query for iSeries reports
- Print definition in Query for iSeries reports
- Specifying spooled output overrides in Query for iSeries reports
- Defining the printout cover page of Query for iSeries reports
- Defining the page headings and footings in Query for iSeries reports
- Defining output of Query for iSeries reports to a database file
- Using an existing output file definition in Query for iSeries reports
- Building a new output file definition in Query for iSeries reports
- Using an output database file created by Query for iSeries
- Selecting the output type and form you want in Query for iSeries reports
- Chapter 14. Specifying Query for iSeries processing options
- Chapter 15. Exiting and running a Query for iSeries query
- Ending a Query for iSeries query definition
- Running a Query for iSeries query
- Using function key F5 when running a Query for iSeries query
- Running a Query for iSeries query from the Query for iSeries menu
- Running a Query for iSeries query from the Exit This Query display
- Running a Query for iSeries query from the Work with Queries display
- Running a Query for iSeries query using the RUNQRY command
- Chapter 16. Working with Query for iSeries query definitions
- 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 fields other than sort fields for report breaks in Query for iSeries
- Result field length and decimal positions in Query for iSeries
- Tips for dealing with presentation length and decimal positions in Query for iSeries
- Length and decimal positions used for internal numeric calculations in Query for iSeries
- Example: Increasing the decimal precision for result fields in Query for iSeries
- Selecting records (ignoring field case) in Query for iSeries
- Part 4. Appendixes
- Appendix A. Differences between Query for iSeries and Query/36
- 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: 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
- Defining queries for Query for iSeries
- Query for iSeries performance when designing or changing queries
- Define result fields in Query for iSeries
- Select and sequence fields in Query for iSeries
- Select records in Query for iSeries
- Select sort fields in Query for iSeries
- Select collating sequence in Query for iSeries
- Specify report summary functions in Query for iSeries
- Select output type and output form in Query for iSeries
- Specify processing options in Query for iSeries
- Using 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
- CCSID conversions for Query for iSeries options and functions
- Displaying a Query for iSeries query
- Changing a Query for iSeries query
- Getting a list of objects with text in Query for iSeries
- Defining a Query for iSeries query
- Defining a collating sequence in Query for iSeries
- Getting a list of formats or members with text in Query for iSeries
- Saving a Query for iSeries query definition
- Running a Query for iSeries query
- Running a default query in Query for iSeries
- Selecting records at run time in Query for iSeries
- CCSIDs and Query for iSeries query definition items
- CCSID and file selections in Query for iSeries
- CCSID and join tests in Query for iSeries
- CCSID and result field expressions in Query for iSeries
- CCSID and result field column headings in Query for iSeries
- CCSID and sort fields in Query for iSeries
- CCSID and record selection tests in Query for iSeries
- CCSID and summary functions in Query for iSeries
- CCSID and column formatting and editing in Query for iSeries
- CCSID and report breaks in Query for iSeries
- CCSID and break and final text in Query for iSeries
- CCSID and cover page, page headings and footings in Query for iSeries
- CCSID compatibility considerations in Query for iSeries
- Bibliography
- Notices
- Index