Products Downloads


French version


 

Access

To generate logical entities, click the Entity generation from the context-sensitive menu in one of the following dialog boxes:

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.
For AS/400 generation, the data is saved in the HS#QTEMP library.
For Btrieve generation, the data is stored in a file whose name will be indicated if a problem occurs (in order to allow data retrieval).

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.

 

↑ Top of page

  • Aucune étiquette