Reading the Q.PROFILES table

Table 41 shows the columns of the Q.PROFILES control table. Each column of the table represents an aspect of a user's QMF session you can customize. The defaults shown are for the English QMF environment.

If you are using an NLF: Default values might be different for the English environment and some NLFs. For example, do not assume that the default for all NLFs is UPPER because the English default is UPPER. The default value for the CASE field in the German NLF is MIXED, and might also vary for other NLFs. For the default values for each NLF, see the translated version of the Q.PROFILE table. (Replace the n symbol with an NLID from Table 1.)

The Q.PROFILES table has the index Q.PROFILEX, with the attributes UNIQUE and CLUSTER. The keyed columns are CREATOR, TRANSLATION, and ENVIRONMENT. No three rows can have identical values for these three columns.

Table 41. Structure of the Q.PROFILES table
Column name Data type and length Nulls allowed Function and possible values for VM
CREATOR CHAR (8) No

Function: Specifies the authorization ID (the user) who owns the profile.

Values: SYSTEM (default), primary or SQL authorization ID, The SYSTEM row is shipped with Q.PROFILES for English and each NLF; users who do not have unique profile rows can use the SYSTEM row.

CASE CHAR (18) Yes

Function: Specifies whether terminal input is converted to uppercase.

Values: UPPER (default), STRING, or MIXED. See the QMF Reference manual for descriptions of these values. CASE might have a different default for NLF users.

DECOPT CHAR (18) Yes

Function:Specifies what separators QMF puts in numeric report columns.

Values:PERIOD (default), COMMA, and FRENCH. See the QMF Reference manual for more information. DECOPT is translated and might have a different default for NLF users.

CONFIRM CHAR (18) Yes

Function: Controls display of confirmation panels.

Values: YES (default) if you want confirmation panels displayed before database changes; NO if you do not.

WIDTH CHAR (18) Yes

Function: Controls number of printed columns per page.

Values: 22 to 999. Default = 132.

LENGTH CHAR (18) Yes

Function: Controls number of printed lines per page.

Values: 1 to 999, or CONT if you want no page breaks. Default = 60.

LANGUAGE CHAR (18) Yes

Function: Controls which query language QMF uses when creating a new query after a RESET QUERY command is issued.

Values: SQL (default), QBE (for Query-by-Example), or PROMPTED (for Prompted Query).

SPACE CHAR (50) Yes

Function: Specifies a dbspace that holds tables created using SAVE DATA and IMPORT commands.

Values: Any valid dbspace name.

TRACE CHAR (18) Yes

Function: Controls the level of detail in trace output.

Values: ALL traces all functions at the most detailed level. A character string of function codes and numbers indicates the level of tracing for individual QMF functions. The default varies depending on the value for DSQSMODE. For example, when DSQSMODE is B, the trace level is L2, otherwise it is NONE. Only the values ALL and NONE are translated in NLFs.

PRINTER CHAR (8) Yes

Function: Controls where printer output is routed.

Values: Use a null (default) or blank value to route print output to a file or printer associated with the DSQPRINT FILEDEF. Use a GDDM nickname to direct output to a GDDM-defined printer.

TRANSLATION CHAR (18) No

Function: Indicates English or NLF environment

Values: English (default) or the name of an NLF. The right-hand column of Table 1 shows the translated names you need to use in this column.

PFKEYS VARCHAR (31) Yes

Function: Indicates the table or view (if any) where user's customized function key definitions are stored.

Values: Any valid DB2 table or view name. If blank or null (default), QMF's default keys are used.

SYNONYMS VARCHAR (31) Yes

Function: Indicates the table or view (if any) where user's customized command definitions are stored.

Values: Any valid DB2 table or view name. If blank or null (default), no customized definitions are used. For NLF users, the IBM-supplied table is named Q.COMMAND__SYNONYM__n, where n is the National Language ID.

RESOURCE__GROUP CHAR (16) Yes

Function: Controls how the governor exit routine limits user's resources or commands.

Values: Any valid resource group name. If blank or null (default), QMF attempts to use the user's SQL authorization ID here, and the user's session is not governed (unless the authorization ID is a valid resource group name).

MODEL CHAR (8) Yes

Function: Specifies the model for data access.

Values: Always use the value REL for this column, indicating relational data.

ENVIRONMENT CHAR (8) Yes

Function: Indicates the operating environment.

Values: This value is null or CMS. If profiles are stored in DB2 for VM, but are being accessed from a DB2 application requestor, the value used for ENVIRONMENT can be TSO or CICS.

[ Previous Page | Next Page | Contents | Index ]