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
    • Files, fields, and record formats in Query for iSeries
      • Double-byte character set (DBCS) fields in Query for iSeries
      • UCS2 level 1 character set support in Query for iSeries
      • Data definition languages and utilities support in Query for iSeries
    • Query for iSeries definitions
    • Libraries in Query for iSeries
  • 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 prompts and default values in Query for iSeries
    • Using Query for iSeries function keys
      • Checking the results before printing the Query for iSeries report
      • Printing what you see on your Query for iSeries display
    • Using lists in Query for iSeries
      • Displaying a Query for iSeries list
      • Selecting items in a Query for iSeries list
      • Special library names in Query for iSeries
  • Using Query for iSeries commands
  • Using the Query Utilities menu
  • Using the Work with Queries display
    • Choosing a single Query for iSeries task
      • Specifying a Query for iSeries query and its library
    • Choosing multiple Query for iSeries tasks
    • Working with a list of Query for iSeries queries
      • Selecting a Query for iSeries query name from a list
      • Using Query for iSeries list subsets
      • Positioning a list of Query for iSeries queries
      • Using F11 to display additional information about Query for iSeries queries
    • Selecting a library for your Query for iSeries queries
      • Other considerations when you are trying to locate or use a particular Query for iSeries query
  • 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
    • Selecting options for a Query for iSeries query definition
    • Moving through the Query for iSeries definition displays
    • When you return to the Query for iSeries Define the Query display
  • 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
    • 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
      • Using file IDs for a Query for iSeries query
    • Confirming your options for a Query for iSeries query
      • Removing a option 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
    • Types of joins in a Query for iSeries query
    • How to join files in a Query for iSeries query
    • Rules for joining files in a Query for iSeries query
    • Examples of joining files in a Query for iSeries query
      • Example: Selecting matched records from all selected files in a Query for iSeries query
      • Example: Selecting matched records using a primary file in a Query for iSeries query
      • Example: Selecting unmatched primary file records in a Query for iSeries query
    • Sequencing secondary files for a primary join in a Query for iSeries query
      • Example: Sequencing secondary 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
    • Query for iSeries result field name
    • Query for iSeries expressions
    • Query for iSeries numeric expressions
    • Query for iSeries character expressions
      • Query for iSeries concatenation operation
    • Query for iSeries character functions
      • SUBSTR Query for iSeries function
      • DIGITS Query for iSeries function
      • VALUE Query for iSeries function
      • VARCHAR Query for iSeries function
      • VARGRAPHIC Query for iSeries function
    • Date, time, and timestamp expressions in Query for iSeries
      • Query for iSeries date
      • Query for iSeries time
      • Query for iSeries timestamp
    • Displaying constants format in Query for iSeries
  • Date, time, and timestamp arithmetic operations in Query for iSeries
    • Date arithmetic operation in Query for iSeries
      • Subtracting dates in Query for iSeries
      • Incrementing and decrementing dates in Query for iSeries
      • Converting a numeric field to a date field in Query for iSeries
      • Working with numeric dates in Query for iSeries
    • Time arithmetic operation in Query for iSeries
      • Incrementing and decrementing times in Query for iSeries
      • Timestamp arithmetic operation in Query for iSeries
    • Durations in Query for iSeries
      • Labeled duration in Query for iSeries
      • Date duration in Query for iSeries
      • Time duration in Query for iSeries
      • Timestamp duration 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
    • 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
      • Example 1—Converting from MMDDYY to YYDDD format in Query for iSeries
      • Example 2—Converting from MMDDYY to YYDDD format in Query for iSeries
      • Example 3—Converting from YYDDD to MMDDYY format in Query for iSeries
      • Example 4—Converting from MMDDYY to YYDD format 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
    • Comparison fields in Query for iSeries
    • Comparison values in Query for iSeries
      • Fields as values in Query for iSeries
      • Character constants as values in Query for iSeries
      • Numeric constants as values in Query for iSeries
      • Date, time, timestamp constants as values in Query for iSeries
      • Null 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
  • 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
    • Using the hexadecimal collating sequence in Query for iSeries
    • Using the language collating sequence for your country in Query for iSeries
    • Defining your own collating sequence in Query for iSeries
    • Selecting a translation table in Query for iSeries
    • Selecting a system sort sequence in Query for iSeries
• Chapter 10. Specifying report column formatting in Query for iSeries
  • Formatting the columns of the Query for iSeriesquery report
    • Column spacing in Query for iSeries reports
    • Column headings in Query for iSeries reports
    • Length and decimal positions in Query for iSeries reports
    • Omitting fields from a Query for iSeries 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
      • Date/time separator in Query for iSeries reports
    • Specifying an edit code in Query for iSeries reports
      • Edit code in Query for iSeries reports
      • Optional edit code modifier in Query for iSeries reports
    • Specifying edit words
      • Edit word in Query for iSeries reports
      • Edit word for summary total 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
    • Skip to new page in Query for iSeries reports
    • Suppress summaries in Query for iSeries reports
    • Break text 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
    • 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
      • Specifying an output database file for Query for iSeries reports
      • Summary-only output of a Query for iSeries report to a database file
    • Using an output database file created by Query for iSeries
• 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
      • Storing the Query for iSeries query definition
      • Describing the Query for iSeries query definition
      • Giving authority to others to your Query for iSeries query
  • 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
  • Changing a Query for iSeries query definition
    • Starting changes by copying a Query for iSeries query definition
    • Changes you can make to a Query for iSeries query
    • Considerations for changing Query for iSeries queries
      • Changing your collating sequence on Query for iSeries queries
  • 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
    • 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
      • Addition and subtraction in Query for iSeries
      • Multiplication in Query for iSeries
      • Division 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
  • 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
    • Keyed sequence access paths in Query for iSeries
    • Select/omit access paths in Query for iSeries
      • Considerations for creating access paths in Query for iSeries
    • Access plans in Query for iSeries
      • Updating access plans in Query for iSeries
  • 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
    • 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
    • Performance tips for join operations in Query for iSeries
  • Miscellaneous tips and techniques for Query for iSeries
    • Batch processing for Query for iSeries
    • Query for iSeries performance tuning
    • Query for iSeries migration considerations N to N-1
  • 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
    • 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
  • Trademarks
• Index