Previous Topic: CMD_SYNONYM (Command Synonym)Next Topic: EXIT_STATE


Task

List all the command synonyms defined for a specific Business System.

SELECT CMDSYN.CMD_SYNONYM
  FROM
  MODEL,
  BUSINESS_SYS BSYS,
  COMMAND CMD,
  CMD_SYNONYM CMDSYN
  WHERE
  MODEL.NAME = 'my model name'
  AND BSYS.MODEL_ID = MODEL.ID
  AND BSYS.NAME = 'my business system name'
  AND CMD.BUSINESS_SYS_ID = BSYS.ID
  AND CMDSYN.COMMAND_ID = CMD.ID
ORDER BY CMDSYN.CMD_SYNONYM;