Assigning one synonyms 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.

This statement assigns to every user of base (English)QMF a table with the default name, Q.COMMAND_SYNONYMS.

Figure 1. Assigning a single command synonym table to all QMF users

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