Create Script Facility

By default, Uniface handles referential integrity. For some databases, it is possible for the database itself to handle referential integrity checking.

To support this, Uniface provides the Create Script facility, a command line interface that generates scripts for maintaining referential integrity in the DBMS. The scripts map relationships defined in the application model to declarative constraints and database triggers in the database.

Using the IDE command line switch /genSql, you can generate scripts to:

• Generate declarative constraints and database triggers.
• Drop declarative referential integrity constraints and database triggers.
• Check relationships in the database for violations of referential integrity.

For more information, see /genSql.

DBMS connectors that support referential integrity in the database use a connector option to disable or enable Uniface referential integrity. The name of this option is DBMS-specific and the default state depends on the DBMS connector used. See the relevant documentation for the options available for your DBMS connector.

Related Topics