Configuring Database Generation
To configure generation of a database:
1. Open the database properties dialog box.
2. Click the drop-down list then Options > Generation.
As for configuration of a target, the parameters proposed vary as a function of the DBMS and an explanatory message indicates the use of each parameter.
You can specify the following parameters:
• The Trigger Name parameters define the names of three types of trigger.
• Error Ref Value: user error number for the current DBMS.
• Val. Default Value: activates/deactivates generation of DEFAULT orders for columns.
• Quoted Identifier: activates/deactivates generation of quotes around SQL identifiers (SQL name).
• Mode Generation Inc: this parameter applies to incremental generation and can take values "Alter" and "Drop/Create".
• "Alter" does not authorize deletion of objects (tables, indexes, etc.) at the level of generated scripts. Only those instructions that can be executed using the ALTER command are generated. For physical parameters, deletion is still authorized (this is the case notably for partitions).
• "Drop/Create" authorizes object deletion. If an update cannot execute via the ALTER command, the object is deleted then recreated.
By default, the parameter takes value "Alter".
• Script Distribution: indicates if the result of generation should be created in a unique file or in one file per object or in one file per object type.
• SQL Script: name of the file generated when this is a unique file. By default, this sub-folder is called REFEXT. You can customize at DBMS level. The arrow at extreme right of the field allows you to reinitialize the parameter.
You can also reinitialize all parameters of the object concerned. This action should be carried out with care.• Script Directory: relative generation folder.
• The various Ext parameters allow you to specify extensions of each file generated for tables, datagroups, views, etc.
• Conversion: format of generated files (ANSI Windows or ASCII MS-DOS).
• CREATE CLUSTER: activates/deactivates generation of CREATE CLUSTER orders.
• CREATE TABLE: activates/deactivates generation of CREATE TABLE orders.
• CREATE TABLESPACE: activates/deactivates generation of CREATE TABLESPACE orders.
• PRIMARY KEY: activates/deactivates generation of PRIMARY KEY orders.
• FOREIGN KEY: activates/deactivates generation of FOREIGN KEY orders.
• CREATE INDEX: activates/deactivates generation of CREATE INDEX orders.
• CREATE PROCEDURE: activates/deactivates generation of stored procedures.
• CREATE INDEX PK: activates/deactivates generation of CREATE INDEX orders for primary key indexes.
• CREATE INDEX[UNIQUE]: activates/deactivates generation of CREATE INDEX orders for unique indexes.
• CREATE VIEW: activates/deactivates generation of logical views.
• CREATE SEQUENCE: activates/deactivates generation of CREATE SEQUENCE orders.
• CREATE SYNONYM: activates/deactivates generation of CREATE SYNONYM orders.
• CREATE TRIGGER: activates/deactivates generation of triggers.
• Comments: activates/deactivates generation of HOPEX comments in SQL script.
• UNIQUE: activates/deactivates generation of UNIQUE orders.
• UNIQUE[PK]: activates/deactivates generation of UNIQUE orders for primary keys.
• PRIMARY KEY syntax: PRIMARY KEY orders are generated in CREATE TABLE order or in an ALTER TABLE order.
• Position FOREIGN KEY: generation of FOREIGN KEY orders after each CREATE TABLE or grouped at end of script.
• COMMENT ON TABLE: comments on tables (0:no comment, 1:one line, Total:all text)
• COMMENT ON COLUMN: comments on columns (0:no comment, 1:one line, Total:all text)
Generation of comments is only possible for target systems that accept these (Oracle, DB2,...).• The various Add-Ons parameters activate/deactivate generation of add-ons on tables, datagroups, etc.
• Tbspace of Tables: by default, tables are generated in the SYSTEM tablespace.
• Tbspace of Indexes: by default, tables are generated in the SYSTEM tablespace.