Adding a new user profile to the Q.PROFILES table

You can use SQL INSERT queries or the QMF Table Editor (described in the Using QMF manual) to add new user profiles to the Q.PROFILES table. Figure 64 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 64 are examples of profile values you can use.

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 64 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 the QMF Reference manual .

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.