Enhancements to Existing Features › Support CM Promotion of DDL Objects (Not Switched from DDS)

Support CM Promotion of DDL Objects (Not Switched from DDS)

CA 2E and CM now allow you to promote DDL-based objects. CM does not support "promotion with compile" for SQL-based access paths. The only way to promote them is with "promotion with moving as a 3GL object." The new DDL to the DDL promotion functionality follows this same process.

During the promotion request creation, the DDL table takes the YSQLPF object code and the DDL indexes take the YSQLLF object code.

Note: The new DDL to DDL promotion functionality is available only with CA 2E Release 8.7 and Implementer 11.0. Upgrade your existing product setup to CA 2E Release 8.7 and Implementer 11.0 to take advantage of the new functionality.

Limitation:

• If the database is implemented with YSQLVNM = *SQL, irrespective of generation mode as *SQL/*DDL, the promotion of "physical file"/"table" access paths is not successful.

The following documentation deliverables are updated for this feature:

• Compatibility Matrix

Note: For more information on the CM promotion of DDL-based objects, see the Implementer 11.0 documentation.