Activating the synonyms on OS/390

To activate the command synonym table for your users:

1. Update the SYNONYMS field of the user's profile with the proper command synonym table name.

   For example, to assign the COMMAND__SYNONYMS table to the user JONES in the English language and the table GUMMOW.XYZ to the user SCHMIDT in the German NLF environment, use the query in Figure 142:

   Figure 142. Activating a user's QMF command synonyms

   Base QMF (English)

   German NLF

   UPDATE Q.PROFILES

   UPDATE Q.PROFILES

   SET SYNONYMS='COMMAND__SYNONYMS'

   SET SYNONYMS='GUMMOW.XYZ'

   WHERE CREATOR='JONES'

   WHERE CREATOR='SCHMIDT'

   AND TRANSLATION='ENGLISH'

   AND TRANSLATION='DEUTSCH'

   AND ENVIRONMENT='TSO'

   AND ENVIRONMENT='TSO'

   Important: Always specify a value for TRANSLATION when you are updating Q.PROFILES, or you might change more rows than you intend.

   The query in Figure 142 applies to users who are already enrolled in QMF. You can use a similar query to update the SYSTEM profile. If you are enrolling a new user, use an INSERT query.

2. Grant the SQL SELECT privilege to PUBLIC so that assigned users can access the synonyms. For example:

   GRANT SELECT ON COMMAND__SYNONYMS TO PUBLIC

   If you are using a view of a synonym table rather than the table itself, grant SELECT on only the view to prevent users from accessing synonyms not meant for their use. Views are discussed in Minimizing maintenance of command synonym tables.

3. Instruct users to end the current QMF session and start another to activate the new synonyms.