DB2 graphic  QMF Version 8

Activating the synonyms on z/OS

QMF Version 8.1 allows for the use of long names in the command synonym table. The Q.PROFILES column, SYNONYMS, is now VARCHAR(261) to allow for a 128 byte table owner ID and table name.

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 59:

    Figure 59. 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 59 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.


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