Manuel D’UtilisationTable des matièresContents5About Query for iSeries Use11Who should read the Query for iSeries Use book11Part 1. Introduction to Query for iSeries13Chapter 1. What is Query for iSeries?15Query for iSeries fundamentals15Files, fields, and record formats in Query for iSeries15Double-byte character set (DBCS) fields in Query for iSeries16UCS2 level 1 character set support in Query for iSeries16Data definition languages and utilities support in Query for iSeries16Query for iSeries definitions17Libraries in Query for iSeries17Major functions of Query for iSeries17Chapter 2. General operating information for Query for iSeries19Practicing with Query for iSeries19Getting started with Query for iSeries19When you are finished working with Query for iSeries19Telling Query for iSeries what you want19Using prompts and default values in Query for iSeries19Using Query for iSeries function keys20Checking the results before printing the Query for iSeries report20Printing what you see on your Query for iSeries display21Using lists in Query for iSeries21Displaying a Query for iSeries list21Selecting items in a Query for iSeries list22Special library names in Query for iSeries22Using Query for iSeries commands23Using the Query Utilities menu23Using the Work with Queries display24Choosing a single Query for iSeries task24Specifying a Query for iSeries query and its library25Choosing multiple Query for iSeries tasks25Working with a list of Query for iSeries queries26Selecting a Query for iSeries query name from a list26Using Query for iSeries list subsets26Positioning a list of Query for iSeries queries27Using F11 to display additional information about Query for iSeries queries27Selecting a library for your Query for iSeries queries28Other considerations when you are trying to locate or use a particular Query for iSeries query29Displaying the format of constants in Query for iSeries29Query for iSeries profile information30Handling Query for iSeries messages and errors30Changing your Query for iSeries queries30Part 2. Defining and using Query for iSeries query definitions33Chapter 3. Creating a Query for iSeries query definition39Starting Query for iSeries query definition39Selecting definition steps when defining a Query for iSeries query40Selecting options for a Query for iSeries query definition41Moving through the Query for iSeries definition displays42When you return to the Query for iSeries Define the Query display42Considerations for creating Query for iSeries queries42Selecting files, records, and fields for Query for iSeries42Suggested sequence of tasks for creating Query for iSeries queries43Chapter 4. Specifying and selecting files for a Query for iSeries query45Specifying file selections for a Query for iSeries query45Choosing a file for a Query for iSeries query46Choosing a library for a Query for iSeries query46Choosing a member or record format for a Query for iSeries query47Selecting multiple files for a Query for iSeries query47Using file IDs for a Query for iSeries query48Confirming your options for a Query for iSeries query48Removing a option for a Query for iSeries query48Handling errors on the Query for iSeries Specify File Selections display48Selecting files on the Query for iSeries Select File display49Selecting file members on the Query for iSeries Select Member display51Selecting record formats on the Query for iSeries Select Record Format display52Displaying all files selected on the Query for iSeries Display File Selections display53Joining files in a Query for iSeries query54Types of joins in a Query for iSeries query55How to join files in a Query for iSeries query55Rules for joining files in a Query for iSeries query56Examples of joining files in a Query for iSeries query58Example: Selecting matched records from all selected files in a Query for iSeries query59Example: Selecting matched records using a primary file in a Query for iSeries query60Example: Selecting unmatched primary file records in a Query for iSeries query60Sequencing secondary files for a primary join in a Query for iSeries query61Example: Sequencing secondary files in a Query for iSeries query61Displaying all join tests in a Query for iSeries query65Handling missing fields in a Query for iSeries query66Handling missing fields during file selection process of a Query for iSeries query67Handling missing fields when starting to change or display a Query for iSeries query67Chapter 5. Defining result fields in Query for iSeries69Creating results fields in Query for iSeries69Query for iSeries result field name70Query for iSeries expressions70Query for iSeries numeric expressions71Query for iSeries character expressions72Query for iSeries concatenation operation72Query for iSeries character functions73SUBSTR Query for iSeries function73DIGITS Query for iSeries function74VALUE Query for iSeries function74VARCHAR Query for iSeries function75VARGRAPHIC Query for iSeries function77Date, time, and timestamp expressions in Query for iSeries78Query for iSeries date79Query for iSeries time79Query for iSeries timestamp80Displaying constants format in Query for iSeries81Date, time, and timestamp arithmetic operations in Query for iSeries81Date arithmetic operation in Query for iSeries82Subtracting dates in Query for iSeries82Incrementing and decrementing dates in Query for iSeries83Converting a numeric field to a date field in Query for iSeries83Working with numeric dates in Query for iSeries83Time arithmetic operation in Query for iSeries85Incrementing and decrementing times in Query for iSeries85Timestamp arithmetic operation in Query for iSeries85Durations in Query for iSeries85Labeled duration in Query for iSeries85Date duration in Query for iSeries85Time duration in Query for iSeries85Timestamp duration in Query for iSeries86Date, time, and timestamp functions in Query for iSeries86CHAR Query for iSeries function86DATE Query for iSeries function87DAY Query for iSeries function87DAYS Query for iSeries function88HOUR Query for iSeries function88MICROSECOND Query for iSeries function89MINUTE Query for iSeries function89MONTH Query for iSeries function90SECOND Query for iSeries function90TIME Query for iSeries function91TIMESTAMP Query for iSeries function91YEAR Query for iSeries function92Additional date, time, and timestamp functions in Query for iSeries92Converting date formats in Query for iSeries92Converting date for output to a database file in Query for iSeries92Converting date for output to a display or printer in Query for iSeries93Example 1—Converting from MMDDYY to YYDDD format in Query for iSeries93Example 2—Converting from MMDDYY to YYDDD format in Query for iSeries93Example 3—Converting from YYDDD to MMDDYY format in Query for iSeries94Example 4—Converting from MMDDYY to YYDD format in Query for iSeries94General considerations when creating an expression in Query for iSeries95Column headings in Query for iSeries97Length and decimal positions in Query for iSeries97Example of defining a result field in Query for iSeries98Adding or removing result fields in Query for iSeries98Chapter 6. Selecting and sequencing fields in Query for iSeries99Letting Query for iSeries select and sequence fields99Selecting fields and specifying their sequence in Query for iSeries99Chapter 7. Selecting records in Query for iSeries103Letting Query for iSeries select records103Selecting the records you want in Query for iSeries103Comparison fields in Query for iSeries104Comparison values in Query for iSeries105Fields as values in Query for iSeries106Character constants as values in Query for iSeries106Numeric constants as values in Query for iSeries106Date, time, timestamp constants as values in Query for iSeries107Null values in Query for iSeries107Comparison tests in Query for iSeries107Date, time, or timestamp comparisons in Query for iSeries108Testing for equal (EQ) and not equal (NE) in Query for iSeries108Testing for IS Null (IS) and ISNOT Null (ISNOT) in Query for iSeries108Testing for greater (GT or GE), less (LT or LE), and range (RANGE) in Query for iSeries108Testing for values in a list (LIST NLIST) in Query for iSeries109Testing for values that are similar (LIKE NLIKE) in Query for iSeries110Testing for DBCS LIKE (like) and NLIKE (not like) in Query for iSeries111Using more than one comparison test in Query for iSeries113Adding and removing comparisons in Query for iSeries115Chapter 8. Selecting sort fields in Query for iSeries117Letting Query for iSeries determine the order of records for you117Selecting the sort fields you want to use in Query for iSeries117Additional sort considerations in Query for iSeries120Chapter 9. Selecting a collating sequence in Query for iSeries123Letting Query for iSeries select a collating sequence123Setting your default collating sequence in Query for iSeries123Purpose of a collating sequence in Query for iSeries123Collating sequence and CCSIDs in Query for iSeries124How a collating sequence affects Query for iSeries124Selecting a Query for iSeries collating sequence125Using the hexadecimal collating sequence in Query for iSeries125Using the language collating sequence for your country in Query for iSeries126Defining your own collating sequence in Query for iSeries127Selecting a translation table in Query for iSeries128Selecting a system sort sequence in Query for iSeries129Chapter 10. Specifying report column formatting in Query for iSeries131Formatting the columns of the Query for iSeriesquery report131Column spacing in Query for iSeries reports131Column headings in Query for iSeries reports131Length and decimal positions in Query for iSeries reports132Omitting fields from a Query for iSeries report133Editing numeric fields in Query for iSeries reports134Defining numeric field editing in Query for iSeries reports134Describing numeric field editing in Query for iSeries reports136Decimal point in Query for iSeries reports137Thousands separator in Query for iSeries reports137Show negative sign in Query for iSeries reports137Left negative sign in Query for iSeries reports137Right negative sign in Query for iSeries reports138Show currency symbol in Query for iSeries reports138Left currency symbol in Query for iSeries reports138Right currency symbol in Query for iSeries reports138Print zero value in Query for iSeries reports139Replace leading zeros in Query for iSeries reports139Replace with option in Query for iSeries reports139Single leading zero in Query for iSeries reports139Describing date/time field editing display in Query for iSeries reports139Date/time separator in Query for iSeries reports140Specifying an edit code in Query for iSeries reports141Edit code in Query for iSeries reports141Optional edit code modifier in Query for iSeries reports143Specifying edit words143Edit word in Query for iSeries reports143Edit word for summary total in Query for iSeries reports145Chapter 11. Specifying report summary functions in Query for iSeries reports147Types of summary functions in Query for iSeries reports147Summarizing columns in Query for iSeries reports149Location of column summary values in Query for iSeries reports149Chapter 12. Defining Query for iSeries report breaks151Defining a Query for iSeries report break151Defining report break formatting in Query for iSeries reports155Skip to new page in Query for iSeries reports155Suppress summaries in Query for iSeries reports155Break text in Query for iSeries reports156Chapter 13. Selecting output type and output form in Query for iSeries reports157Selecting the output type and form you want in Query for iSeries reports157Form of output of Query for iSeries reports158Line wrapping in Query for iSeries reports158Wrapping width in Query for iSeries reports159Record on one page in Query for iSeries reports159Displaying wrapping widths in Query for iSeries reports159Defining output to the printer in Query for iSeries reports160Printer device in Query for iSeries reports161Form size in Query for iSeries reports161Start line in Query for iSeries reports162End line in Query for iSeries reports162Line spacing in Query for iSeries reports162Print definition in Query for iSeries reports162Specifying spooled output overrides in Query for iSeries reports162Defining the printout cover page of Query for iSeries reports164Defining the page headings and footings in Query for iSeries reports165Defining output of Query for iSeries reports to a database file166Using an existing output file definition in Query for iSeries reports167Building a new output file definition in Query for iSeries reports168Specifying an output database file for Query for iSeries reports169Summary-only output of a Query for iSeries report to a database file172Using an output database file created by Query for iSeries173Chapter 14. Specifying Query for iSeries processing options175Purpose of Query for iSeries processing options175Rounding numeric field values during Query for iSeries processing176Ignoring decimal data errors during Query for iSeries processing176Ignoring character substitution warnings during Query for iSeries processing177Using collating sequence for all character comparisons during Query for iSeries processing177Chapter 15. Exiting and running a Query for iSeries query179Ending a Query for iSeries query definition179Saving a Query for iSeries query definition179Storing the Query for iSeries query definition179Describing the Query for iSeries query definition180Giving authority to others to your Query for iSeries query180Running a Query for iSeries query181Using function key F5 when running a Query for iSeries query181Running a Query for iSeries query from the Query for iSeries menu181Running a Query for iSeries query from the Exit This Query display181Running a Query for iSeries query from the Work with Queries display182Running a Query for iSeries query using the RUNQRY command183Chapter 16. Working with Query for iSeries query definitions185Changing a Query for iSeries query definition185Starting changes by copying a Query for iSeries query definition185Changes you can make to a Query for iSeries query185Considerations for changing Query for iSeries queries188Changing your collating sequence on Query for iSeries queries188Copying a Query for iSeries query definition189Renaming a Query for iSeries query definition190Deleting a Query for iSeries query definition190Displaying a Query for iSeries query definition191Printing a Query for iSeries query definition192Information printed for a Query for iSeries query definition193Example of printed record format information for a Query for iSeries query definition194Part 3. Advanced information about Query for iSeries197Chapter 17. Additional information about Query for iSeries for programmers199Files with different record formats in Query for iSeries199File sharing considerations in Query for iSeries199Overriding database files in Query for iSeries199DBCS considerations when defining result fields in Query for iSeries199Joining files in Query for iSeries200Using *ALL in Query for iSeries200Using fields other than sort fields for report breaks in Query for iSeries200Result field length and decimal positions in Query for iSeries200Tips for dealing with presentation length and decimal positions in Query for iSeries200Length and decimal positions used for internal numeric calculations in Query for iSeries201Addition and subtraction in Query for iSeries201Multiplication in Query for iSeries201Division in Query for iSeries201Example: Increasing the decimal precision for result fields in Query for iSeries202Selecting records (ignoring field case) in Query for iSeries203Part 4. Appendixes205Appendix A. Differences between Query for iSeries and Query/36207Conceptual Differences207Operational Differences207Command differences between System/36 and Query for iSeries commands209Migration differences between System/36 and Query for iSeries definitions209Appendix B. Practice exercise for Query for iSeries query211Query for iSeries query exercise: Creating an IDDU definition211Query for iSeries query exercise: Creating a database file215Query for iSeries query exercise: Entering data215Query for iSeries query exercise: Creating and running a query218Query for iSeries query exercise: Creating a query219Query for iSeries query exercise: Changing a query223Query for iSeries query exercise: Creating an advanced query227Appendix C. Query for iSeries performance tips and techniques243Introduction to Query for iSeries query processing243Keyed sequence access paths in Query for iSeries243Select/omit access paths in Query for iSeries244Considerations for creating access paths in Query for iSeries244Access plans in Query for iSeries244Updating access plans in Query for iSeries245File definitions and data in Query for iSeries245File definitions in Query for iSeries245File data considerations for Query for iSeries246Defining queries for Query for iSeries246Query for iSeries performance when designing or changing queries246Define result fields in Query for iSeries247Select and sequence fields in Query for iSeries247Select records in Query for iSeries247Select sort fields in Query for iSeries248Select collating sequence in Query for iSeries249Specify report summary functions in Query for iSeries249Select output type and output form in Query for iSeries249Specify processing options in Query for iSeries250Using join operations in Query for iSeries250Performance tips for join operations in Query for iSeries251Miscellaneous tips and techniques for Query for iSeries252Batch processing for Query for iSeries252Query for iSeries performance tuning253Query for iSeries migration considerations N to N-1253Query for iSeries status messages253Query for iSeries debug mode messages254Appendix D. Preventing users from running Query for iSeries queries interactively255Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries257CCSID marking in Query for iSeries259CCSIDs and collating sequences in Query for iSeries260Query for iSeries language sequences261CCSID conversions for Query for iSeries options and functions261Displaying a Query for iSeries query261Changing a Query for iSeries query262Getting a list of objects with text in Query for iSeries262Defining a Query for iSeries query262Defining a collating sequence in Query for iSeries262Getting a list of formats or members with text in Query for iSeries263Saving a Query for iSeries query definition263Running a Query for iSeries query263Running a default query in Query for iSeries263Selecting records at run time in Query for iSeries263CCSIDs and Query for iSeries query definition items264CCSID and file selections in Query for iSeries264CCSID and join tests in Query for iSeries264CCSID and result field expressions in Query for iSeries264CCSID and result field column headings in Query for iSeries265CCSID and sort fields in Query for iSeries265CCSID and record selection tests in Query for iSeries265CCSID and summary functions in Query for iSeries265CCSID and column formatting and editing in Query for iSeries265CCSID and report breaks in Query for iSeries265CCSID and break and final text in Query for iSeries265CCSID and cover page, page headings and footings in Query for iSeries265CCSID compatibility considerations in Query for iSeries266Bibliography271Notices273Trademarks274Index275Taille: 1,3 MoPages: 294Language: EnglishOuvrir le manuel
