Adding a new user profile to the Q.PROFILES table in CICS/VSE

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. Use the TRANSLATION column of Q.PROFILES to distinguish between an English and an NLF environment.

Figure 72. Creating a user profile in CICSVSE

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