Description

CASE

Specifies whether commands and input entered into objects are converted to uppercase.

UPPER

Convert all input to uppercase.

STRING

Convert input to uppercase, except for:

• Characters enclosed in single or double quotation marks
• Comments in SQL or QBE queries and procedures
• Column headings, page headings and footings, break headings, or detail headings
• Data entered in the Table Editor
• All text in procedures with logic (REXX)

MIXED

Does not convert input to uppercase. Input is used just as it is typed. When this value is used, all operators in QBE queries, all reserved words, and all QMF commands must be entered in uppercase. Column names in QBE queries must be entered in uppercase unless they are written using lowercase in the database.

CONFIRM

Specifies the default action for confirmation prompting with QMF commands that support the CONFIRM option. This default applies when the commands do not specify the CONFIRM option.

Confirmation prompting provides an opportunity to cancel an irrevocable command action before it takes place. Irrevocable command actions include changing, replacing or purging an object, such as a file, a data set, or something in the database.

YES

Confirmation prompting is enabled as the default for your QMF session.

NO

Confirmation prompting is disabled as the default for your QMF session.

DECIMAL

Specifies how to punctuate decimal numbers in a report. This option controls the formatting characteristics of the decimal point and the thousands separators for numeric values formatted with the decimal edit codes.

PERIOD

Use a period (.) for the decimal point and comma (,) for the thousands separators.

COMMA

Use a comma (,) for the decimal point and period (.) for the thousands separators.

FRENCH

Use a comma (,) for the decimal point and space ( ) for the thousands separators.

LANGUAGE

Specifies the default query language for the query panel.

SQL

Structured Query Language

QBE

Query By Example

PROMPTED

Prompted Query

LENGTH

Specifies the default length of a printed page. The unit of length is one line.

integer

Specifies the maximum number of lines between page breaks. The number must be an integer from 1 to 999.

CONT

Specifies continuous printing, without page breaks.

MODEL

Specifies the data model used for queries.

REL

Relational data model.

PRINTER

Specifies the default output destination of the QMF PRINT command.

printername

Specifies a printer destination. This must be the nickname of a GDDM printer.

blankstring

Specifies a file destination. This value must be indicated by a string of 0 to 8 blanks enclosed in single quotes (' ').

The physical destination for the print output is determined by your QMF environment and tailoring by your QMF administrator:

• In TSO or CMS, to the dataset, file or device allocated to the QMF file DSQPRINT.
• In CICS, a CICS queue specified by the QUEUENAME option of the PRINT command or its default.

SPACE

Specifies the default storage space in the database to place tables created with the SAVE DATA command.

spacename

The name of a valid storage structure for the current database location. This could be a dbspace name, a database name, a tablespace name or a combination of database and tablespace name.

blankstring

Specifies the storage structure default will be determined by the database at the current location. This value must be indicated by a string of 0 to 50 blanks enclosed in single quotes (' ').

TRACE

Turns the QMF Trace Facility on or off.

functionlevel

Enable trace activity for individual functions and levels.

Specify functionlevel as a list of alternating letters (function codes) and numbers (trace levels) that tell what functions are to be traced and at what levels. Codes and levels are:

 A  Applications            0  No tracing
 C  Common Services         1  Trace entry and exit points,
 D  Driver Modules             and input/output parameters
 E  Front End Processor     2  Trace internal data as well
 F  Formatter                  as level-1 data
 G  Graphic Translator
 I  Database Interface
 L  Messages and Commands
 P  Graphics Plotter
 R  Radix Partition Tree
 U  User Exits

ALL

Enable trace activity for all functions and all levels.

NONE

Disable trace activity.

For more information on TRACE, refer to the Installing and Managing QMF for you environment.

WIDTH

Specifies the default width of a printed page. The unit of width is one single-byte character.

integer

Specifies the maximum number of characters to be printed on any line. The number must be an integer from 22 to 999.

Lines wider than the value specified are cut off on the right, unless the object you are printing is a report. In that case, lines longer than the value specified are formatted on a subsequent page, unless you specified line wrapping on the FORM.OPTIONS panel.