Enhancements to Existing Features › Allow LVLCHK(*YES) for SQL/DDL indexes having RCDFMT keyword

Allow LVLCHK(*YES) for SQL/DDL indexes having RCDFMT keyword

When creating SQL/DDL database files with the RCDFMT keyword in CA 2E, we can now create all SQL/DDL artifacts with LVLCHK(*YES). SQL/DDL tables and views are created with LVLCHK(*YES) by default, irrespective of the RCDFMT keyword. However, SQL/DDL indexes are created with LVLCHK(*NO) when the RCDFMT keyword is generated. A new model value YLVLCHK has been introduced to enable SQL/DDL indexes also to be generated with LVLCHK(*YES). This ensures that the file is protected from data corruption from RLA-type access, if the database changes.

The following documentation deliverables were updated for this feature:

• Administration Guide
• Building Access Paths Guide
• Building Applications Guide