DB2 graphic  QMF Version 8

Assigning one synonym table to all users

The more command synonym tables you create for individual users, the more time you spend on maintenance. One way to reduce maintenance is to create a single command synonym table and assign it to every user. The query in Figure 60 assigns to every user of base (English) QMF a table named COMMAND__SYNONYMS.

Figure 60. Assigning a single command synonym table to all QMF users
UPDATE Q.PROFILES
  SET SYNONYMS='Q.COMMAND__SYNONYMS'
  WHERE TRANSLATION='ENGLISH' and ENVIRONMENT='TSO'


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