The SET PROFILE command changes values in your QMF profile. These values influence the behavior of your QMF session.
|TSO with ISPF||TSO without ISPF||CICS®|
- Specifies whether commands and other input are converted to uppercase.
- Converts all input to uppercase.
- Converts input to uppercase, except for the following:
- 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 (which use REXX)
- 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
Use this option if you use the QMF CONNECT command in TSO and your site uses mixed-case passwords for RACF®. Otherwise, QMF converts the password to uppercase, causing the CONNECT command to fail.
- 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 data set or something in the database.
- Enables the display of confirmation panels, which
provide an opportunity to cancel the command before it runs.
When you run a query that contains multiple SQL statements that change the database, a single confirmation panel is displayed. The answer you provide in response to this prompt applies to changes that will be made by all SQL statements in the query.
- Disables the display of confirmation panels.
- 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
The following examples show the results of using the DECIMAL option when formatting the value 7654321 with two decimal places:
- Uses a period (.) for the decimal point and a comma (,) for the thousands separators.
- Uses a comma (,) for the decimal point and a period (.) for the thousands separators.
- Uses a comma (,) for the decimal point and a space for the thousands separators.
- 7 654 321,00
- Specifies the default query language for the query panel.
- Structured Query Language
- Prompted Query
- Specifies the default length of a printed page. The unit of length
is one line.
- Specifies the maximum number of lines between page breaks. The number must be an integer from 1 to 999.
- Specifies continuous printing, without page breaks.
- MODEL is left for compatibility with previous releases. MODEL may not be updated by the SET PROFILE command.
- Specifies the default output destination for the QMF PRINT command and the Print function
key in QMF Analytics for TSO.
- Specifies a printer destination. This must be the nickname of a GDDM printer.
- Specifies a file destination. This value must be indicated by
a string of 0 to 8 blanks enclosed in single quotation marks (' ').
The physical destination for the print output is determined by your QMF environment and tailoring by your administrator:
- In TSO, the output goes to the data set or device allocated to the QMF file DSQPRINT.
- In CICS, the output goes to a CICS queue specified by the QUEUENAME option of the PRINT command or its default.
Use a string of blanks for the printer option when you have started QMF for TSO as a stored procedure and you want to receive output back in a result set.
- Specifies the default storage space in the database, where tables created
with the SAVE DATA or IMPORT TABLE command will be placed.
Note that when creating accelerator-only tables, the SPACE profile is not used to define the default database definition. Accelerator-only tables are created in the database defined in the DSQEC_SAV_ACCELDB global variable. The Q.PROFILES.SPACE value is not used when defining accelerator-only tables. Accelerator-only tables are created through the SAVE DATA, IMPORT TABLE and RUN QUERY with the TABLE keyword.
- The name of a valid storage structure for the current database location. This could be a dbspace
name, a database name, a table space name, or a combination of a database and a table space name. To specify implicit creation of table spaces, specify the DATABASE keyword followed by a database name in double quotation marks. For example, when you specify the following value for the SPACE option, the database manager implicitly creates a table space exclusively for each table within the DATABASEA database:
- Specifies the storage structure default, which depends on the database to which you are currently connected. This value must be indicated by a string of 0 to 50 blanks enclosed in single quotation marks.
- Turns the QMF trace facility
on or off.
- Enables trace activity for individual functions and allows you
to specify the level of trace detail you want for each function you
specify. Specify functionlevel as a list of alternating letters (codes that indicate the functions you want to trace) and numbers (level of trace detail you want for each function specified). Codes and levels are shown in following table:
Table 1. Codes for tracing specific QMF functions Code Function traced A Applications C Common services D Driver modules E Front-end processor F Formatter G Graphic translator I Database interface L Messages and commands P Graphics plotter R Radix partition tree U User exitsSpecify the level of trace detail you want for each function by entering one of the following numbers after the code shown in the previous table.
- 0 = No tracing
- 1 = Tracing occurs at entry and exit points as well as for input and output parameters
- 2 = Traces internal data as well as Level-1 data.
For example, a trace code of A2 traces applications at the highest level of detail.
Use one of the following trace codes to trace messages, commands, or both:
- Messages only (L1)
- Messages and QMF commands (L2)
The L trace code can help you find errors in batch-mode procedures.
- Enables trace activity for all functions and all levels.
- Disables trace activity.
When you start QMF for TSO as a Db2® for z/OS® stored procedure, you set the level of trace detail by passing a parameter value on the CALL statement that starts QMF. When QMF has been started in this manner and the trace output has been set to go to any destination other than the default trace data set (DSQDEBUG), trace settings cannot be changed.
- Specifies the default width of a printed page. The unit of width
is one single-byte character.
- 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.
- The changes in effect as a result of the SET PROFILE command remain in effect for the current QMF session. To save these changes in your profile so that they persist from one QMF session to another, use the SAVE PROFILE command after you enter SET PROFILE.
- To change values in the QMF profile without using the SET PROFILE command, enter SHOW PROFILE and change any options on the profile panel.