Adding a new user profile to the Q.PROFILES table in CMS

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 68 shows sample SQL that creates unique profiles 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.

Figure 68. Creating a user profile in CMS

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', 'CMS')                                'COMMAND__SYNONYM__D', 'SCHICHT'
                                                   'CMS')

[ Previous Page | Next Page | Contents | Index ]