Contents

The QMF Library

About This Book

Prerequisite knowledge

How to send your comments

QMF command environments

Entering commands

On the command line

With a function key

On a prompt panel

From a procedure

From an application

Using remote data access

Confirmation panels

Canceling commands

How to read syntax diagrams

Command parameters

Error conditions

Warning conditions

Connect in OS/390

Connect in CICS

PRINT in CMS and TSO

Variable values for the RUN command

System considerations

QMF Program Parameters

SQL Keywords and Functions Used in QMF Queries

BETWEEN x AND y

Insert some column values in a row

Copy rows from one table to another

Select a string of characters: LIKE '%abc%'

Ignore characters: LIKE '_a_'

NOT with NULL, LIKE, IN, and BETWEEN

Sorting sequence

Order by more than one column

Order columns by column number

Select every column from a table

Select columns from a table

Add descriptive columns

Equality and inequality symbols in a WHERE clause

Calculated results

SQL scalar functions

Date/time functions

Conversion functions

String functions

Forms, Reports, and Charts

Using QMF forms

Creating reports in QMF

Display a report without any data

Symbols used in reports to indicate errors

Quick reference to form panels for reports

Creating charts in QMF

Summary of Editing Expressions

Specifying column attributes

Printing considerations

FORM.CONDITIONS

Mistakes on form panels

Error conditions

Warning conditions

Checking for and correcting mistakes

Form and data incompatibility

Using REXX with QMF forms

Using calculated values in reports

How QMF and REXX Iiteract

When expressions are evaluated by REXX

Report calculation expression examples

ACROSS Usage Code

Aggregation Usage Codes

BREAK Usage Codes

CALCid Usage Code

GROUP Usage Code

OMIT Usage Code

Date and Time Usage Codes

Edit Codes for Character Data

Edit Codes for Graphic Data

Edit Codes for Numeric Data

Edit Codes for Date Data

Edit Codes for Time Data

Edit Codes for Timestamp Data

User-Defined Edit Codes

Considerations for Aggregation Functions and Edit Codes

Variables Used in Forms

Naming conventions

Names with double-byte characters

Commas instead of decimal points

QMF temporary storage areas

Report completion and the incomplete data prompt

Changing QMF's response to long-running queries

Avoiding using nulls as data when editing a QMF object

Methods of writing queries

Query-by-example (QBE)

Procedures with logic

Linear procedures

System initialization procedure

Printing QMF objects

Reports, tables, profiles, procedures, SQL queries, and QBE queries

Prompted queries and forms

The table editor

Field-sensitive help

Remote data access

Distributed unit of work access (DB2 for OS/390 only)

Remote unit of work access

The governor interrupt

Appendix A. QMF Sample Tables

Appendix B. QMF Global Variable Tables

DSQ global variables for profile-related state information

DSQ global variables for state information not related to the profile

DSQ global variables associated with CICS

DSQ global variables related to a message produced by the previous command

DSQ global variables associated with table editor

DSQ global variables that control how information is displayed on the screen

DSQ global variables that control how commands and procedures are executed

DSQ Global Variables That Show Results of CONVERT QUERY

DSQ Global Variables That Show RUN QUERY Error Message Information

Appendix C. QMF Functions that Require Specific Support

QMF functions not available in CICS

Appendix D. Notices

Glossary of Terms and Acronyms

APPC Publications

CICS Publications

COBOL Publications

DATABASE 2 Publications

DCF Publications

DRDA Publications

DXT Publications

Graphical Data Display Manager (GDDM) Publications

HLASM Publications

ISPF/PDF Publications

OS/390 Publications

PL/I Publications

REXX Publications

ServiceLink Publications

VM Publications

VSE Publications

[ Previous Page | Next Page | Contents | Index ]