Top of Page

Scroll UpPage Up
Scroll DownPage Down

    Database Views

    Description File Information

    Control File Information

    Data Files Information

    Data View

    Reports

Whilst viewing Data Structures in the Database View you are able to use the Right Click Function to navigate to other parts of the treeview structure.


 

 

Right Click Function

The Right Click function in the Database View is context sensitive and will display options based upon the currently selected item in the left hand treeview.  Generally the right click functionality is only available when a specific data structure has been selected.

 

Options include:-

 

Option Action

Go to Description Information

Changes your selection to the Structure item in the Description File View for the currently selected Structure
Go to Control Information Changes your selection to the Structure item in the Control File View for the currently selected Structure
Go to Data Information Changes your selection to the Structure item in the Data Information View for the currently selected Structure
Go to Data View Changes your selection to the Structure item in the Data View for the currently selected Structure
Record Format This initiates the Record Format dialogue for the currently selected Structure
Key Format This initiates the Key Format dialogue for the currently selected Structure

Expand Tree

This will expand the currently selected item to display  all of the sub items in the treeview
Collapse Tree This will collapse the currently selected item to hide all of the sub items in the treeview
Collapse Parent This will collapse the parent item of the currently selected item to hide all of the sub items of the that parent item

 

 

 

    Description File Information

 

The Description file is the machine readable version of the DASDL file and therefore holds all of the static definition of the database.  This includes the global attributes of the database, structure definitions, data items and attributes.

 

The Description File is primarily used for compiling software which will run against the database.  It does not form part of the running database.

 

Below is a summary of the items that can be found under the Description File in the treeview.

 

Description File

 


 

Icon Item Description
Description File Information This view shows the Database Summary for the Database
Global Attributes This view shows the attributes that have been defined Globally for the database.
Options This view shows the Boolean options which may be set in the database to control the way it globally functions
Parameters This view shows the dynamic parameter values which may be set in the database to control the way it globally functions
Audit Attributes This view shows the definitions of the Audit trail for the database
Software This view shows the definitions of the Software locations of the tailored and non-tailored software of the database.

 

Defaults

Icon Item Description
Defaults Expanding this node will display the default attributes set at database, structure and item levels
Global Defaults This view shows the default values that are used by the database structures in their definitions
Item Defaults This view shows the default values that are used by data items in their definitions.
Dataset Defaults This view shows the default values that are used by the datasets in their definitions.
Set Defaults This view shows the default values that are used by the sets in their definitions

 

Structures

Icon Item Description
Structures When expanded this item displays all of the Data Structures in the database
Structure    The Structure view lists the Dataset and associated Sets that make up the complete structure.  This view shows a Dataset attribute summary for the Dataset
Dataset This view shows a Dataset attribute summary for the Dataset
Set This view shows a Set attribute summary for the Dataset.

 

Data Items

Icon Item Description
Record This view shows a Record attribute summary for the Dataset.  When expanded it lists all of the data items that make up the record in the order they are found in the data.
Key This view shows a Key attribute summary for the Dataset.  When expanded it lists all of the key items and control information that make up the key in the order they are found in the data.
Alpha Data Items  
    Numeric Data Items  
Boolean Data Items  
Real Data Items  
Absolute Address Word  
Key Data  

 

 

 

 

    Control File Information

 

The Control File is the file used by the run time database to hold global and structure information.  The information in the control file is dynamic and will change as the database is active.  The information in the batch file is a snapshot of this dynamic information at the time of capture.

 

Below is a summary of the items that can be found under the Control File in the treeview.

 

Control File

 

 

Icon Item Description
 Control File Information This view shows the Database Summary for the Database
Global Attributes This view shows the attributes that have been defined Globally for the database.
Options This view shows the Boolean options which may be set in the database to control the way if globally functions
Dynamic Parameters This view shows the dynamic parameter values which may be set in the database to control the way it globally functions
Audit Attributes This view shows the definitions of the Audit trail for the database, this includes both primary and secondary audit attributes.
Software This view shows the definitions of the Software locations of the tailored and non-tailored software of the database.
Remote Database This view shows the definitions of the Remote Database settings for the database.
Structures When expanded this item displays all of the Data Structures in the database
Dataset This view shows a Control File attribute summary for the Dataset
Set This view shows a Control File attribute summary for the Set

 

 

    Data Files Information

 

When a data file structure is selected in the left hand treeview data about the structure is displayed on the right hand side.  The data displayed is context sensitive and will show the data suitable to the selection made. By selecting the Data Display option graphics you may view other data about the structure. 

 

Below is a summary of the items that can be found under the Control File in the treeview.

 

Icon Item Description
 Data Files Information This view shows the Database Summary for the Database
Structure    The Structure view lists the Dataset and associated Sets that make up the complete structure.  This view shows a Dataset attribute summary for the Dataset
Dataset This view shows a Dataset attribute summary for the Dataset
View Dataset Data View View Dataset Data View
Set This view shows a Set attribute summary for the Set
View Set Data View View Set Data View

 

               

                        

 

    Data View

The Data View allows you to view the internal formats of the Data Structures.  This is achieved through a combination of captured Batch File data and data captured real time through the Named Pipe interface.

Only one structure may be viewed in the Data View format at one time.  Once you have selected to view a structure in the Data View format you are able to remove the structure by selecting the structure and clicking on the delete button on the toolbar.

Below is a summary of the items that can be found under the Data View in the treeview.

 

Icon Item Description
 Data Files Information This view shows the Database Summary for the Database
Structure    The Structure view lists the Dataset and associated Sets that make up the complete structure.  This view shows a Dataset attribute summary for the Dataset
Dataset This view shows a Dataset attribute summary for the Dataset
Physical View This view shows a Physical attribute summary for the Dataset
Area This view shows a Area attribute summary for the Area
Block This view shows a Block attribute summary for the Block
DK Table This view shows a DK Table summary for the Dataset
DK Table Area This view shows a DK Area summary for the Structure
DK Table Block This view shows a DK Area summary for the Structure
Set This view shows a Set attribute summary for the Set
Table This view shows a Table attribute summary for the Table
Logical This view shows a Set Logical attribute summary for the Table
Root Table This view shows a Table Logical Attribute summary for the Table
Coarse Table This view shows a Table Logical Attribute summary for the Table
Fine Tables This view shows a Table Logical Attribute summary for the Table
Key Entries This view shows a Key Entry attribute summary for the Table
Omega Entry This view shows the Omega Entry for the Table
Empty Tables This view shows a Deleted Table Attribute Summary for the Table