ACCOMMODATION OF DATA DEFINITION STATEMENTS IN THE SHARING OF DYNAMIC SQL STATEMENTS

摘要

An SQL relational database management system which determines the shareable status of an executable object (section) in an SQL cache. The shareable status is defined for a section in an SQL cache by the system maintaining an identification list which has reference t o database entities which are affected by a DDL statement in the current unit of work. When an SQL statement is compiled, the compiler generates a list of dependencies, which list is compared with t he identification list. If the SQL statement data dependencies are on the identification list, the SQL statement will be treated as non-shareable until the completion of the current unit of work.