Products Downloads


French version


 

An access is an access path to a logical entity. A logical entity must therefore be selected before any access operation.

Important: To access the accesses relating to the selected logical entities, display the Accesses only tab using the Accesses option in the Logical entities tab.


Access

To work with and generate accesses, select the Accesses tab of the LDM/PDM screen.


Displayed data

Entity's access

Name of the current entity whose list of accesses is displayed.


Buttons

Next entity

Displays the access list for the next selected entity in the list of the Logical entities tab.

This button is only active if more than one entity is selected and the end of the selection has not been reached.


Lists

Accesses of the entity

List of existing accesses (name and description) for the selected logical entity.

This list is empty when no logical entity is selected in the previous list.

Multiple-selection list.

Note: This list will be empty if no logical entities are selected in the Logical entities tab. Use the Logical entities tab's Accesses option to display the selected entities' accesses.


With correction environments, a check mark can precede each access name.

A red check mark shows that the access is being held by the default correction.
A black check mark shows that the access is being held by a correction other than the default correction.


Context-sensitive menu

The following options are accessible at all times via the context-sensitive menu.
In addition, there may be buttons to perform the same actions on the right-hand side of the window, depending on the settings in the Create/Modify a software engineer dialog box's Preferences tab.

 

Create

This option opens a dialog box which is used to create an access for a logical entity.

This option is only active if the tab was opened via the Accesses option of the Logical entities tab.


Modify

This option opens a dialog box which is used to display or modify the general characteristics of the selected access.

This option is not active when no entity is selected in the list of logical entities.


Delete

This option opens a message box requesting confirmation before deleting the selected accesses.

When the deletion is validated, the list of accesses is updated accordingly.

This option is not active when no access is selected in the list.


Print

This option prints the characteristics of the selected access.

The printing job is submitted to the Job manager.

This option is not active when no access is selected in the list.


Access

This option opens a dialog box which is used to display or modify the access path of the selected access.

This option is not active when no access is selected in the list.


Sel/Om (selections/omissions)

This option opens a dialog box which is used to display, create or modify the record selection-omissions on the selected access.

This option is not active when no access is selected in the list.


Generation

List

Generation

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.

Btrieve

Generation of the Physical Data Model in the form of Btrieve files for Windows.

AS/400 SQL

Generation of the Physical Data Model in the form of AS/400 SQL tables.

DB2

Generation of the Physical Data Model in the form of DB2 UDB 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.

Access

Generation of the Physical Data Model in the form of Access SQL tables.

MySQL

Generation of the Physical Data Model in the form of MySQL SQL tables.

PostgreSQL

Generation of the Physical Data Model in the form of PostgreSQL SQL 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 Native AS/400.


Generic script

The file will be generated as a generic script file.

This button only appears if the generation type is not Native AS/400.


SQL script

The file will be generated as an SQL script file.

This button only appears if the generation concerns an SQL database.


Data entry

File

Name of the generated script file.

Data entry is only possible if the generation type is not Native AS/400 and a script radio button is selected.

The file is generated on the client machine (generic scripts) or on the machine that runs the job manager (SQL scripts).


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 Native AS/400 and a script radio button is selected.


Format the script

Checked

Generation of a formatted script using a syntax compatible with the DBMS concerned.

Not checked

Generation of a script in which each query is expressed on a single line, with no separators (script compatible with previous Adelia generations).

The SQL scripts can be generated in a readable indented form - with a query separator – that can be directly interpreted by the standard execution tools corresponding to the DBMS selected (sqlplus for Oracle, Query Browser SQL Server, etc.). Adelia tools can correctly interpret these scripts also (see the Database management tool topic) by analyzing the data provided in the script header comment.

Default value: checked.


Buttons

Details

This button opens a dialog box that lets you display or edit a access's specific generation characteristics.

It is only active if one or more accesses are selected in the list.


Generate

This button starts the Physical Data Model generation for each selected access.

It is only active if one or more accesses are selected in the list.


↑ Top of page

  • Aucune étiquette