The APPDS Manager
This utility is a X Window based application that can be launched from any console command prompt by executing the command string appds.
The APPDS manager widow is composed of three sections,Figure 1.0 . Along the top of the window is the first section, the main menu bar. Within the main menu bar are three menu items: Session, Edit and Help. Below the main menu bar the APPDS table list section. In this section the APPDS tables fro the current session are listed and the table count is displayed. The last section displays information about the current APPDS service.
Figure 1.0 APPDS Manager main window
Figure 1.1 Session Menu plane
The "Refresh Table List"menu option signals the APPDS Manager to poll the APPDS facility to get the latest table information. This should be done periodically since the APPDS Manager does not do it automatically. The next menu option "Change APPDS Service" provides the capability to change the current APPDS service. After selecting this option the APPDS service selection window will pop-up. The third menu option is "View APPDS Log". Selecting this option causes the APPDS Manager log window to be displayed. The last option in the session menu "End Session" terminates the current APPDS Manager session.
APPDS Service Selection Window
Figure 1.1.1 Service selection window
APPDS Manager Log
Figure 1.1.2 APPDS Manager Log window
Figure 1.2 Edit Menu plane
New Table Window
Figure 1.2.1 New Table Window
The Table Name parameter defines the name for the new table. It must be a text string that is 1 to 25 characters long. Also the text string cannot contain any white space or end in an underscore followed by a number. The Table Name parameter is case-insensitive and for consistency the APPDS facility converts all table names to upper case internally. A table name must be supplied to create a new table. Below is a table showing Valid and Invalid table names.
The next user definable parameter is the Table Lock which allows a user to enable or disable application level setting of table interaction mode. Table locking is enabled or disabled by selecting the corresponding toggle button. When the "Enabled" toggle is chosen the user's name will automatically be placed into the table lock owner field. For new tables table locking is set to "Disabled" and setting is not required.
The next three parameters Overwrite, Access mode and Read/Writemode allow the user to set the default table interaction mode. Initially the APPDS manager sets the parameters as follows:
Following the Read/Write mode is the Last Access logger controls. This parameter allows for the turning on and off of last table access logging. When the ON toggle is selected the date and time of the last table access is saved. The default setting for this paramter is OFF.
The Maximum records parameters defines the maximum number of records that can be stored in the table. Valid values for this field are number between 1 and 99999. For new tables the APPDS manager set the initial value to 100.
The last user define-able parameter is the Record Structure. The record structure defines what data types are in a table record and is a direct translation of the users "C" structure. Record structure definition is performed via the Record Structure Editor,Figure 1.2.3, which is displayed by selecting the "Modify Record Structure" button from the New Table window. After the record structure has been defined it can be modified again by reselecting the "Modify Record Structure" button.
The system define parameters displayed in the New Table window include:
These parameters cannot be directly modified by the user and are set by the APPDS manager. The Record Count parameter displays the total number of records currently in the table, since the table has yet to be create a 0 should be displayed. The two Record Size parameters display the size in bytes of the defined record structure. These two parameters are update every time the record structure is modified. The last system defined parameter, Data Table Count, displays the total number of database tables needed to store the record structure. This parameter is zero until the APPDS table is create.
To create a table the Table Name and Record Structure must be provided. Once these two requirements have been met, the "Create Table" button can be selected to send a request to the database to create the new APPDS table. If the request failed an error dialog box will be displayed, otherwise a success dialog will display and the new table name will appear in the APPDS table list. The user can exit the New Table window without creating a APPDS table by selecting the "Cancel" button.
Record Structure Editor
Figure 1.2.3 Record Structure Editor Window
The menu bar contains one menu, Edit. The Edit menu plane is composed of three menu options: "Insert", "Shuffle" and "Delete". The "Insert" option is a pull-right menu that allows the user to insert data types into the structure definition. New data types are inserted into the structure definition based on the following criteria: if the selection cursor is active, i.e. an item is selected from the list, any new data types are inserted before the selection cursor, otherwise new data items are appended to the list. The "Insert" menu plane contains the following data types:
The first data type in the "Insert" menu plane, "Array", is itself another pull-right menu plane. This menu plane contains the same data type that the "Insert" menu plane does, with the exception of the array type. When a fixed size data type is selected it is inserted at the end of the data type list. For variable length data types, Array, Character and Binary, a dialog window is displayed for the user to enter the type length. The limits for the variable length data types are as follows:
The next menu option, in the Edit menu plane, "Shuffle" provides the ability to move data types up and down in the data type list. To use this feature the a data type needs to be selected from the data type list and then from the "Shuffle" menu either the "Up" or "Down" option can be selected. The last Edit option "Delete" allows the user to remove a data type from the list. Below is an example of what the "C" structure my_struct will look like in the Record Structure Editor.
Figure 1.2.4 "C" structure to APPDS record structure
Once the record structure has been defined the user can save the changes and close the editor by selecting the "Ok" button or close the editor and discard any modifications by selecting the "Cancel" button. Upon closing of this window, if the record structure definition has as its first element an array the Keyed access mode toggle button in the New Table window will be disabled.
View APPDS Table
For more information about these parameters refer to Table Parameters section. When a change is made to any of these table parameters the APPDS table window will display the "Commit Changes" and "Cancel" buttons along the bottom of the window. To save changes and close the APPDS table window select the "Commit Changes" button, otherwise select the "Cancel" to abort all changes and close the window. If parameters changes are not made then select the "Close" to close the window.
Figure 1.2.2 APPDS Table Information
Delete APPDS Table
Purge APPDS Table
Last modified: Fri Feb 12 13:20:30 CST 1999