Access
To generate logical entities, click the Entity generation from the context-sensitive menu in one of the following dialog boxes:
Maintenance manager, Results (1 and 2) or Storage tab.
Define a correction, in the Correction manager.
Database manager
Lists
Database manager
Type of the database which is to be generated.
Possible values:
AS/400 native |
Generation of the Physical Data Model in the form of AS/400 files. |
AS/400 SQL |
Generation of the Physical Data Model in the form of AS/400 SQL tables. |
Btrieve |
Generation of the Physical Data Model in the form of Btrieve files for Windows. |
DB2 |
Generation of the Physical Data Model in the form of DB2/Windows SQL tables. |
Oracle |
Generation of the Physical Data Model in the form of SQL Oracle tables. |
SQL Server |
Generation of the Physical Data Model in the form of SQL Server tables. |
Note: The values presented in the list depend on the licence you own, and on the setup defined in the environment attributes.
Radio buttons
Database
The file will be generated directly in the database.
This button only appears if the generation type is not AS/400.
Generic script
The file will be generated as a generic script file.
This button only appears if the generation type is not AS/400.
SQL script
The file will be generated as an SQL script file.
This button only appears if the generation type is DB2, Oracle or SQL Server.
Data entry
File
Name of the generated script file.
Data entry is only possible if the generation type is not AS/400 and either the "Generic script" or "SQL script" radio button is selected.
Check boxes
Create new file
Checked |
Creates a new script file. |
Not checked |
Adds the DB queries to the existing script file. |
This check box is only active if the generation type is not AS/400 and either the "Generic script" or "SQL script" radio button is selected.
Generation parameters
Check boxes
Generation with key
Checked |
Generation of physical files with key. |
Not checked |
Generation of physical files without key. |
The generation of a physical file without key implies the generation of a logical file whose name is specified when defining the logical entity.
Default: box not checked.
Save data
This check box starts the generation of the Physical Data Model while saving the data of the existing Physical Data Model.
Checked |
Generation with the saving of existing data. |
Not checked |
Generation without saving of existing data. |
Generate integrity constraints
Checked |
Generates the integrity constraints. Click the Generate button to display a window that lets you select the operations to be performed with the integrity constraints. |
Not checked |
Only the entity is generated. |
This check box is only visible when an SQL generation mode is selected.
By default: unchecked.
Buttons
Generation parameters
This button opens a dialog box which is used to modify the generation parameters of logical entities.
It is active only if the generated database type is "AS/400 native" or "Btrieve"; see the "Work with databases" section above.
_______________
Lists
Logical entities
List of all the logical entities in the current application area.
Extended-selection list.
For each logical entity, the following is mentioned:
Entity
Name of the logical entity.
Physical
Name of the physical file which will be generated.
Logical
Name of the logical file generated when the Generation with key box is not checked.
Description
Description of the entity.
Buttons
Details
This button opens a dialog box which is used to display or modify the specific generation characteristics of a logical entity.
It is not active when no logical entity is selected in the list.
Generate
This button starts the Physical Data Model generation for each entity selected in the list.
It is not active when no logical entity is selected in the list.
Enter
This button closes the dialog box.
Keyboard shortcut: Esc.