Updating after a renaming process

As of UDS/SQL V2.9 it is possible to update databases after a renaming process. But in contrast to typical updatings of databases, in this case you have to regenerate subschemas, because BMEND doesn't write the changes into the COSSD file. You may use the following command sequence for this purpose:

/START-UDS-BMEND

//UPDATE-DATABASE ... (see "Apply AFIMs to a database (UPDATE-DATABASE)")

/

/START-UDS-DDL

DELETE SUBSCHEMA subschema-name OF SCHEMA schema-name
SOURCE IS subschema-source

END

/

/START-UDS-BGSSIA

REGENERATE SUBSCHEMA subschema-name OF SCHEMA schema-name
END

The following figure shows the process of an update with renaming:

Figure 4: Updating with renaming