Thursday, February 12, 2015

AS400 Query Tool

DB2 UDB for AS/400 Query Management Programming

Table of Contents

About DB2 UDB for AS/400 Query Management Programming
  • Who Should Use This Book
  • What Query Management Does Not Do
  • AS/400 Operations Navigator
  • Installing Operations Navigator
  • Prerequisite and related information
  • How to send your comments
    • Chapter 1. Introduction
  • Query Management Overview
  • Query Management Enhancements
  • AS/400 and the SAA Environment
  • Collection Use by Query Management
  • Naming Conventions
  • Query Objects
  • System Naming
  • SAA Naming
  • AS/400 Objects
  • Variable Names
  • Other Query Names
  • Security and Authorization
  • Query Management Objects
  • Query Management CL Commands
  • Generic Commands
  • Message Descriptions
    • Chapter 2. Query Capability
  • Creating Queries
  • Creating Queries Example
  • Query Restrictions
  • Variable Substitution
  • Variable Prompting
  • Comments
  • Line Continuations
  • Using Sort Sequence with Queries
    • Chapter 3. Instance Processing
  • Creating a Query Management Instance
  • Running a Query Management Query
  • Global Variable Substitution
  • Creating Query Management Reports
  • Importing a Query or Form Object
  • Exporting a Query or Form Object
  • Importing and Exporting a Query Management Procedure
  • Running a Query Management Procedure
  • Using the Save Data As Command
  • Using SET GLOBAL and GET GLOBAL Commands
  • Introducing Activation Groups
    • Chapter 4. Commands
  • Specifying Commands and Keywords
  • Command Parsing
  • How to Read the Syntax Diagrams
  • COMMIT
  • Examples of the COMMIT Command
  • CONNECT
  • Parameter List
  • Examples of the CONNECT Command under RUW Connection Management
  • Examples of the CONNECT Command under DUW Connection Management
  • DISCONNECT
  • Examples of the DISCONNECT Command
  • ERASE
  • Parameter List
  • Examples of the ERASE command
  • EXIT
  • Examples of the EXIT command
  • EXPORT
  • Parameter List
  • CCSID Considerations
  • Examples of the EXPORT Command
  • GET
  • Examples of the GET Command
  • IMPORT
  • CCSID Considerations
  • Examples of the IMPORT Command
  • PRINT
  • CCSID Considerations
  • Examples of the PRINT Command
  • Printer File Use
  • Print Object Formatting
  • Print Report Formatting
  • RELEASE
  • Examples of the RELEASE Command
  • RUN
  • Run Command Considerations
  • Date Format Use
  • CCSID Use
  • CALL SQL Limitations
  • Examples of the RUN Command
  • SAVE
  • Examples of the SAVE Command
  • Null Value Considerations
  • Referential Constraint Considerations
  • Long Column Name Considerations
  • SET CONNECTION
  • Examples of the SET CONNECTION Command
  • SET GLOBAL
  • Examples of the SET GLOBAL Command
  • Quotation Marks in varname Values
  • Programming Considerations
  • START
  • Extended Parameter List
  • Examples of the START Command
  • Query Management Query Command Procedure
  • Example of the Query Management Command Procedure
  • CL Commands
  • ANZQRY (Analyze Query) Command
  • CRTQMFORM (Create Query Manager Form) Command
  • CRTQMQRY (Create Query Manager Query) Command
  • DLTQMFORM (Delete Query Manager Form) Command
  • DLTQMQRY (Delete Query Manager Query) Command
  • RTVQMFORM (Retrieve Query Manager Form) Command
  • RTVQMQRY (Retrieve Query Manager Query) Command
  • STRQMPRC (Start Query Manager Procedure) Command
  • STRQMQRY (Start Query Manager Query) Command
  • WRKQMFORM (Work with Query Manager Form) Command
  • WRKQMQRY (Work with Query Manager Query) Command
    • Chapter 5. Procedures
  • Creating Procedures
  • Example 1
  • Example 2
  • Steps for Creating a Procedure
  • User Interaction
  • Procedure Interaction
  • Procedure Objects
  • Error Handling
  • Error Categories
    • Chapter 6. Report Forms
  • How Applications Can Use the FORM
  • Creating Forms
  • Creating a Default Form
  • Formatting Terminology
  • DBCS Data
  • COLUMN Fields
  • Data Type
  • Column Heading
  • Usage
  • Indent
  • Width
  • Datatype
  • Edit
  • Seq
  • Run-Time Defaults
  • Column Heading
  • Edit
  • Width
  • PAGE Fields
  • Blank Lines Before Heading/Footing
  • Blank Lines After Heading/Footing
  • Heading Text Lines
  • Line
  • Align
  • Page Heading Text
  • Footing Text Lines
  • Line
  • Align
  • Page Footing Text
  • FINAL TEXT Fields
  • New Page for Final Text
  • Put Final Summary at Line
  • Blank Lines before Text
  • Line
  • Align
  • Final Text Lines
  • BREAK Fields
  • New Page for Break/New Page for Footing
  • Repeat Column Heading
  • Blank Lines before Heading/Footing
  • Blank Lines after Heading/Footing
  • Put Break Summary at Line
  • Break Heading Text Lines
  • Line
  • Align
  • Break Heading Text
  • Break Footing Text Lines
  • Line
  • Align
  • Break Footing Text
  • OPTIONS Fields
  • Detail Line Spacing
  • Outlining for Break Columns
  • Default Break Text
  • Column Wrapped Lines Kept on a Page
  • Column Heading Separators
  • Break Summary Separators
  • Final Summary Separators
    • Chapter 7. Callable Interface
  • Callable Interface Description
  • Interface Communications Area (DSQCOMM)
  • Return Codes
  • Return Variables
  • Command Message Variables
  • Query Message Variables
  • Query Management Command Syntax Extension
  • Extended Variable Support
  • Creating Variables
  • Referencing Variables
  • Variable Names
  • Variable Values
  • Character variables
  • Integer variables
  • Query Management Defined Variables
  • Commitment Control
  • Accessing the Callable Interface with HLL Programs
  • C Language Interface
  • Example DSQCOMMC
  • C Variable Support
  • DSQCIC Function Syntax
  • DSQCICE Function Syntax
  • Interface Communications Area (DSQCOMM)
  • Return Codes
  • Sample C Language Query CI Program
  • COBOL Language Interface
  • DSQCIB Function Syntax
  • DSQCIB Extended Function Syntax
  • Interface Communications Area (DSQCOMM)
  • Return Codes
  • COBOL Query CI Program Example
  • COBOL Query CI Program Example 2
  • RPG Language Interface
  • DSQCIR Function Syntax
  • DSQCIR Extended Function Syntax
  • Interface Communications Area (DSQCOMMR)
  • Return Codes
  • RPG Language Query CI Program: Example 1
  • RPG Language Query CI Program: Example 2
  • Using Subprograms to Access the CI
  • START Subprogram
  • SETC Subprogram
  • SETA Subprogram
  • SETN Subprogram
  • RUNQ Subprogram
  • RUNP Subprogram
  • EXIT Subprogram
    • Chapter 8. Exported and Imported Objects
  • General Object Formats
  • Comments in Externalized Query Management Objects
  • External Formats
  • Panel Format
  • Encoded Format
  • Size of the Encoded Format
  • Records that Make Up the Base Encoded Format
  • Header ("H") Record
  • Value ("V") Records
  • Table Description ("T") Records
  • Table Row ("R") Records
  • End-of-Object ("E") Record
  • Application Data ("*") Record
  • EXPORT and IMPORT File Considerations
  • Ambiguous Date and Time Literals
  • Variable-Length Fields
  • Display Format
  • Encoded Format
  • Importing a Form Object
  • Columns Table Details
  • Exporting a Form Object
  • Record Format Rules
  • Specific Query Object Formats
  • Externalized FORM Format
  • Externalized PROC and QUERY Formats
  • IMPORT Query Considerations for Sort Sequence
  • Error Handling and Warning Conditions
  • Failing Conditions
  • EXPORT QUERY Considerations for Sort Sequence
  • Externalized Query Description
    • Chapter 9. Distributed Relational Database Architecture (DRDA)
  • Remote Unit of Work (RUW)
  • Distributed Unit of Work (DUW)
  • Connection Management Statements
  • Connection Management
  • Conversation Types
  • Read-only Connections
  • Status
  • Connection Management Method Considerations
  • Using the DSQRDBCNNMTH Keyword with START
  • Using the DSQSDBNM Keyword with START
  • DRDA and Activation Groups
  • Considerations
  • Default Activation Group
  • Non-default Activation Group
  • Default and Non-Default Activation Groups
  • Two Non-Default Activation Groups
  • Command Considerations with DRDA
  • SAVE DATA AS
  • Other Query Management Commands
  • Commitment Control
  • ILE C/400 Considerations
  • Understanding Commitment Control for Non-Default Activation Groups
  • Understanding Commitment Control for Default Activation Groups
  • Remote Processing and Long Column Names
    • Chapter 10. Coded Character Set Identifiers (CCSIDs)
  • Import CCSID Processing
  • Export CCSID Processing
  • Print CCSID Processing
  • Sort Sequence CCSID Processing
  • Other Considerations
    • Chapter 11. DB2 for AS/400 Query Management Considerations
  • Override Considerations
  • Tables and Views
  • Tables Referred to on the ERASE TABLE Command
  • Tables and Views Referred to on the SAVE DATA AS Command
  • IMPORT and EXPORT Source Files
  • Query Procedures
  • Miscellaneous Tips and Techniques
  • Printing a Query Management Object
  • Changing STRQMQRY Defaults for QRYDFN Use
  • Displaying Information about Using QRYDFN Objects
  • Defining Queries with Global Variables Using Query/400
  • Using Query/400 with Query Management/400
  • Using Query/400 to Create a QMFORM for an Existing QMQRY
  • Displaying Data from a Single Oversized Record
  • Using Query Management or CL Commands in PDM Options
  • Creating a CL Program for Permanent Conversion of a QRYDFN Object
  • Querying for Field Values
  • Passing Variable Values to a Query
  • Defining a Column with No Column Heading
  • Using Query Management to Format an ISQL-Developed Query
  • Using ISQL Select Report Processing with Referential Constraints
  • Using Text Insertion Variables To Stack Captions on Final Summaries
  • Using Text in Combination with Tabular Layout
  • Converting a Multiple-Level Summary-Only QRYDFN
  • Sorting and Subsetting Break-Level Summary Groups
  • Adding SAA Function
  • SAA Functions That Can Be Added
  • Run-Time Environment
  • Limits to Query Management Processing
  • The Query Management Command
  • SQL Query
  • Externalized Query
  • Externalized Form
  • Instances
  • Global Variables
  • Procedures
  • Release-to-Release Considerations
    • Chapter 12. Using Query/400 Definition Information
  • QRYDFN Conversion
  • Applying DB2/400 Query Management to QRYDFN Objects
  • QRYDFN Conversion Considerations
  • Report Differences
  • Analyzing a QRYDFN
  • Inspecting the Output
  • Applying QRYDFN Option Guidelines
  • Query/400 and DB2 for AS/400 Query Management Differences
  • Creating DB2/400 Query Management Objects from QRYDFN Objects
  • Using the STRQMQRY Command Instead of the RUNQRY Command
  • Conversion Details
    • Chapter 13. Control Language Interface
  • Creating QMQRY and QMFORM Objects
  • Sample CL Program for Numeric Variables
  • Creating QMQRY and QMFORM Objects for Character Variables
  • Sample CL Program for Character Variables
    • Appendix A. DBCS Data
  • What Is DBCS Data?
  • Displayed and Printed DBCS Data
  • Data Types Used with DBCS Data
  • Using DBCS Data in DB2/400 Query Management
  • Using DBCS Data in Input Fields
  • Using DBCS Data in Queries
  • Using DBCS in the FORM
  • How Data Truncation is Handled
  • Saving DBCS Data
  • Using DBCS Global Variables in DB2/400 Query Management Commands
  • CL Commands
  • Exporting DBCS Data
  • Importing DBCS Data
  • Printing DBCS Reports
    • Appendix B. DB2/400 Query Management Interface Example
  • Producing a Report
  • Sample Programs
  • Sample RPG Program
  • Sample COBOL Program
  • Query and Form Source
  • Query and Form Printed Output
    • Appendix C. Use of Quotation Marks and Apostrophes When Setting Global Variables
  • Query Global Variable Pool
  • CL Command
  • Message prompt
  • High-Level Language Programming
  • Using a Query Procedure
  • Methods for Simplification
    • Appendix D. Sort Sequence Examples
  • Sort Example
  • Record Selection Example
  • Report Breaks Example
  • Grouping Example
  • Break Summary Use
    • Chapter 14. Bibliography
  • For the AS/400 System
  • For the SAA Solution
  • For Implementation on the System/370 Computer
  • For Implementation with the OS/2 Licensed Program
    • Index


    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
    Posted by at

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)