Converting synonyms to aliases by importing DML

To convert synonyms to aliases by importing 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.

   Tip

   You can copy the DML statement to convert synonyms to aliases from member ACMDMLUG in the HLQ.BMCCNTL data set.

   -- The example DML in this file will convert SYNONYMS to ALIASES.               
   -- This DML will create ALIASES for all the SYNONYMS having creator             
   -- of ZCMD111D.  Then it will delete the SYNONYMS. After you                    
   -- edit the DML statement, you can use CHANGE MANAGER to import it.             
   --                                                                              
   -- WARNING: If the SYNONYMS are used in or refer to other objects,              
   -- such as VIEWS, TRIGGERS, or MATERIALIZED QUERY TABLES, the DML               
   -- will drop these other objects. The DML will not re-create the                
   -- dropped objects. Before you run this DML, create a full-recovery             
   -- baseline of any objects that the DML will drop.                              
   --                                                                              
   UPDATE SYNONYMS                                                                 
   SET CONVERT_TO_ALIAS = 'Y'                                                      
   WHERE                                                                           
   CREATOR = 'ZCMD111D'
   ;

   Important

   The SET CONVERT_TO_ALIAS clause also works with LIKE and MIGRATE statements.

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