CDL file

A CDL file contains the CDL commands that show the differences between two sets of data structures. The file is a record of the changes that would be made if you import the file to a work ID, run Analysis, and then run Execution to update a version of the data structures.

The CDL is contained in an 80-column sequential data set or a PDS member. Every CDL file begins with the -TIME, -ORGN, and -DEST commands followed by zero or more -CDL commands. Each -CDL command contains a CDL statement. The Change-Definition-Language section contains a complete description of the CDL statements, as well as information about the format of the CDL file.

Important

By default, Db2 assigns values to certain attributes of Db2 objects. When CDL is generated by comparing a DDL file to another data structure, Compare uses those system defaults if the attributes are not included in the DDL. In a production environment, however, these defaults might not be acceptable. When you evaluate the CDL statements, you should be aware of situations in which you have modified your system to use values other than Db2 defaults and situations in which Compare used a default value. To make or suppress changes to the data structures, you can apply the change rules or apply suppress-type change rules in an outbound migrate profile.

A CDL file can also contain header, detailed, and summary report information as comments. The comments include all of the ALTER statements for both old and new values. Comments are indicated by an asterisk and eight dashes (* - - - - - - - -). The comparison report information can help you evaluate the effects of applying the CDL that a comparison generates. The comments are included in the CDL when the REPORT (DETAIL) keyword and parameter are included in the ALUIN input stream.

Important

The comparison report information reflects the state of the objects before any change rules that are defined in an outbound migrate profile (with the CDLCHANGERULES keyword) are applied.

You can edit a CDL file with the standard ISPF editor or with any other text editor.

Important

Auxiliary objects and nonauxiliary objects are listed in the same section of the file. For example, auxiliary table space and nonauxiliary table space commands are listed in the table space commands section.


Related topic

Results-of-a-comparison


 

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