Generating DDL for the objects in a base version

You can generate DDL from a base version that is stored in Change Management.

Procedure

Display a list of base versions by using any of the following methods:
- Enter the VE line command on a change to display a list of versions that are associated with the change (Admin option CM, 1, 1), and then issue the VE line command.
- Enter the VE line command on a version scope to display a list of base versions that were created from the version scope (Admin option CM, 4, 2), and then issue VE line command.
- Use Admin tool option CM, 4, 1 to display a list of versions.

Specify the DDL line command on the CM Versions panel to generate DDL for the objects in the base version, as shown in the following example:

ADB2C41 n ------------------ CM - Versions ------------------- Row 1 to 1 of 1 
Command ===>                                                  Scroll ===> CSR  
                                                                               
Line commands:                                                                 
 CH - Changes  PR - Promote  VS - Version scope  DEL - Delete  U - Update      
 PT - Toggle protected status  I - Details on version  DDL - Generate DDL      
 ? - Show all line commands
                                                                              
Sel          ID T Owner    Name                           Comment              
              * * *        *                              *                    
--- ----------- - -------- ------------------------------ -------------------- 
           3035 D DEMBIN2  SAMPLE                                              
DDL        3037 B DEMBIN2  PRE-RUN 01                                           
           3038 B DEMBIN2  POST-RUN 01                                          
******************************* END OF DB2 DATA *******************************

This DDL line command is valid only for base versions (type=B) and not delta versions (type=D).

The CM Base Version DDL panel (ADB2C41E) is displayed with the base version owner and name fields filled in.

ADB2C41E  ---------------- CM - Base Version DDL -----------------------------
Command ===>                                                                   
                                                                               
Specify the following options:                                                 
Base version:  
  Owner  . . . . . . . . . DEMBIN2  >            (? to lookup)                 
  Name . . . . . . . . . . PRE-RUN 01                     >  (? to lookup)     
  
SQL output data set:        
  Prefix for data sets . . DEMBIN2  
  Data set name  . . . . . BACKUP.DDL.PRERUN01