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.
| 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. |