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 144 assigns to every user of base (English) QMF a table named COMMAND__SYNONYMS.

UPDATE Q.PROFILES
  SET SYNONYMS='Q.COMMAND__SYNONYMS'
  WHERE TRANSLATION='ENGLISH' and ENVIRONMENT='TSO'