DB2 graphic  QMF Version 8

Adding a new user profile to the Q.PROFILES table

You can use SQL INSERT queries or the QMF Table Editor (described in Using DB2 QMF ) to add new user profiles to the Q.PROFILES table. Figure 18 shows sample SQL that creates unique profiles in the TSO environment for users with SQL authorization IDs of JONES (base QMF, or English) and SCHMIDT (German NLF). Use the TRANSLATION column of Q.PROFILES to distinguish between an English and an NLF environment.

The values shown in Figure 18 are examples of profile values you can use.

Figure 18. Creating a user profile on TSO
Base QMF (English)                            German NLF
 
INSERT INTO Q.PROFILES                             INSERT INTO Q.PROFILES
(CREATOR, LANGUAGE, SPACE, TRANSLATION,            (CREATOR, LANGUAGE, SPACE, TRANSLATION,
PFKEYS, SYNONYMS, RESOURCE__GROUP,                  PFKEYS, SYNONYMS, RESOURCE__GROUP,
ENVIRONMENT)                                       ENVIRONMENT)
VALUES ('JONES', 'PROMPTED', 'SAVEIT'              VALUES ('SCHMIDT', 'MENUE', 'STUT2BER'
'ENGLISH', 'PFKEYS', 'COMMAND__SYNONYMS'            'DEUTSCH', 'DEUTASTEN'
'NONPRIME', 'TSO')                                'COMMAND__SYNONYM__D', 'SCHICHT'
                                                   'TSO')
 

Note: Always specify a TRANSLATION value when inserting a row into Q.PROFILES, or the TRANSLATION value defaults to a null value and the profile row is automatically ignored. Figure 18 shows only a subset of all possible profile values. Use Reading the Q.PROFILES table for guidance in specifying additional values.

To enroll several users, set up a template query that describes a standard profile and that uses a substitution variable value for any value that commonly changes (such as the value for the CREATOR column) with each new user you enroll. For more information on using substitution variables, see DB2 QMF Reference.

If you are using an NLF: You can establish different profiles for the same user according to the national language environment. A user can have a profile with one set of values in one national language, and a profile with a different set of values in another national language.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004