Database Scripts for Online Updates¶

The purpose of this document is to describe the update script standards used in IFS Cloud when doing online updates. This section is intended to offer guidance to developers when writing DDLSOURCE, CLNSOURCE, DMLSOURCE, and XETRIGGER files.

File Types Used During the Update Process¶

DDLSOURCE Files¶

DDLSOURCE files are used when updating schema definition of an entity. These files are executed during any delivery except for fresh installations. These files are created to fix DDL (Data Definition Language) issues in support versions. e.g., adding table columns. Using this file, You are not allowed to do any intrusive changes to the underline database tables. It is not allowed to modify any of the columns in tables or materialized views that are currently being used by the system.

For more information, see DDLSOURCE Files.

DMLSOURCE Files¶

DMLSOURCE files are created to fix DML (Data Manipulation Language) issues in support versions. e.g., inserting or updating data into new columns. However, you should - Never insert new data to a table without using an editioning strategy. - Never update a column which is currently being used by the current edition. Only update newly added columns in the installer edition. - Never delete data without an editioning strategy.

For more information, see DMLSOURCE Files.

CLNSOURCE Files¶

This file is deployed in the clean stage of the installation. This means that these files will be deployed once the new system is up and running. This makes this file the ideal place to clean up any unused objects from the database.

For more information, see CLNSOURCE Files.

XETRIGGER Files¶

This file will be used to define cross edition triggers to propagate data between two editions.

Writing Code for Online Upgrades¶

When writing code for online upgrades, it is critical to ensure that all PL/SQL blocks are safe for execution during live system operations.

INS Files for Online Upgrades¶

INS files used during online upgrades must follow specific requirements including code registration, safe deployment annotations, and data editioning strategies.

Read more in section INS Files for Online Upgrades

SQL Files for Online Upgrades¶

SQL files (post-installation scripts) used during online upgrades must be annotated as safe for online deployment and follow specific patterns.

Read more in section SQL Files for Online Upgrades