Entering command synonym definitions into the table

After you create a command synonym table, use an SQL INSERT statement similar to the one in Figure 132 to enter your synonyms into the table. You can also use the Table Editor to update the table, as explained in Using QMF.

INSERT INTO COMMAND_SYNONYMS (VERB,OBJECT,SYNONYM_DEFINITION)
  VALUES('COMPUTE', 'MONTHLY_SALES', 'RUN PROC JONES.SALES_FIGURES')

After it is activated according to the procedure in Activating the synonyms, the synonym COMPUTE MONTHLY_SALES runs a QMF linear procedure called SALES_FIGURES, owned by user JONES.

The query in Figure 133 shows an example of a synonym that has no entry in the object column:

INSERT INTO COMMAND_SYNONYMS (VERB,SYNONYM_DEFINITION)
  VALUES('EXECUTE','RUN QUERY')

After it is activated, the synonym EXECUTE runs the query currently in the QMF temporary storage area.

The synonyms in Figures Figure 132 and Figure 133 follow guidelines that allow QMF to process each synonym correctly. The rest of this section explains these guidelines, which you need to follow to ensure that QMF correctly processes your entries for the VERB, OBJECT, and SYNONYM_DEFINITION columns in the table.