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.
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. |
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.