Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Creating synonyms for selected tables by importing DML

Use the following procedure to import DML to create a task ID that creates synonyms for selected tables and derives synonym names from the literal SYN_.

To create synonyms for selected tables

 

Warning

Note

You can also perform this task by using the CM/PILOT DML_STRUCTURE_CHG script. For more information, see Changing-data-structures-by-using-DML.

  1. In an ISPF editor, type the DML statement to match the one shown in the following figure and provide the information that is unique to your site.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

    Success

    Tip

    You can copy the DML statement to create synonyms for selected tables from member ACMDMLU3 in the HLQ.BMCCNTL data set.

    LIKE  SYNONYM
    JOIN SYSIBM.SYSTABLES
    SET
     NAME = 'SYN_'
     CONCAT SUBSTR(SYSIBM.SYSTABLES,NAME,1,12),
            CREATOR            =    'NEWSYN',
            TBCREATOR          =    SYSIBM.SYSTABLES.CREATOR,
            TBNAME             =    SYSIBM.SYSTABLES.NAME
    WHERE
     SYNONYMS.CREATOR               =  'RDACRJ'          AND
     SYNONYMS.NAME                  =  'SY_T_PRODUCT01'  AND
     LENGTH(SYSIBM.SYSTABLES.NAME) <=  12                AND
     SYSIBM.SYSTABLES.CREATOR       =  'ALUQA'
    ;

    In the preceding figure, the DML has been edited to join to the SYSIBM.SYSTABLES. The SET clause uses the SUBSTR function to use only the first 12 characters of the TABLE name. The WHERE clause has a LENGTH specification. The LENGTH check ensures that only tables whose names have an additional four characters added to the beginning of the name for the synonym are utilized.

  2. Import the DML file.Now that the DML file has been imported, you can analyze a work ID and execute a worklist.




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1