Designing the Data Structure › Transforming the Data Model › Setting Technical Design Properties › Setting Permitted Value Default Enforcement

Setting Permitted Value Default Enforcement

The technical design property options for permitted value default enforcement are listed in the following list.

• Reads-Enabled—Use this option if you want the permitted value enforcement for read statements for all of the tables in the database(s) to be handled by the DBMS.

  By enabling the DBMS to control the permitted value enforcement, you are requiring all applications (CA Gen or not) that will be reading tables in the generated database to adhere to the same permitted value rules.

  If you allow the database to handle the permitted value violations, there will be no action taken for the reads within the CA Gen application.

• Reads-Disabled—Use this option if you want the permitted value enforcement to be handled at the database level and you want CA Gen to do the enforcement.

  This is a good selection if there are no permitted values in the database, or if you do not want the DBMS to enforce the permitted values for READ statements.

• Creates/Updates-DBMS—Use this option if you want the permitted value enforcement for row creates and updates for all tables in the database(s) to be handled by the DBMS.

  By enabling the DBMS to control the permitted value enforcement, you are requiring all applications (CA Gen or not) that will be creating or updating rows in any of the tables in the generated database to adhere to the same permitted values.

  If you select this option, an SQL return code will be returned to the CA Gen application within the create statement (when permitted value violation exception) and you will handle it in the procedure logic. See the chapter titled “Designing the Procedure Logic” to learn more about this technique.

• Creates/Updates-CA Gen—Use this option if you want CA Gen to handle the permitted value enforcement.

  This is a good selection if there are no permitted values in the table, or if you do not want the DBMS to enforce the permitted values for create and update statements.