Contents - Index - Previous - Next

Maintain Database
Purpose of Program
Use this program to view or directly edit data file records. 
CAUTION: be extremely careful when using this program.  It generally is used as a support tool to repair data records.  Whenever possible, you should use the actual programs themselves to work with data, because the programs properly update related files, whereas Maintain Database does not.  
General Program Operation
Maintain Database is located on the main Windows menu.  Click on File, then Maintain Database.
Select the file you want to view or edit from the Files Available window.  See File Names for a listing of files by module. 
Once a file is selected, you can control the order that they are listed by selecting any of the indexes in the Indexes for Selected File window.  As you click on the different indexes you will see the display order change.
The fields in the file are displayed from left to right.  Most files have far more fields than can be displayed on one screen, so use the scroll bars on the top and bottom of the main display window to view different portions of the file.  
You can limit the fields displayed by clicking on fields in the Fields in Selected File window.  Any fields that are check-marked will display; those with their check-marks cleared will not display.
As you scroll through the records, the current record is marked by an arrow in the narrow column to the left of the main display window.
In the lower left portion of the screen are several icons that help you edit the data records.  The four arrow buttons advance to the first record, the prior record, the next record, and the last record respectively. 
Once you are on a record, you can delete it by clicking on the "minus sign" (delete record) button.  If you do so, you will be asked to confirm if you want to delete the record.
Once you move to any fields and make changes to them, you can click on the "check-mark" (post edit) button and your changes will be saved.  If you make changes and then decide not to save them, click on the "X" (cancel edit) button and the original data will be restored.  
If you make changes to a record and then move to another record, your changes will automatically be saved without having to click on the "check-mark" (post edit) button.
Another useful tool in finding records is the Search button.  Enter any search value in the field to the left of the search button and then click Search.  The program will find the first record that matches the search value within the current index that is highlighted in the Indexes for Selected File window.  Be aware that the search is case-sensitive.
To add a new record, go to the last record in the file and use your down arrow to move to a blank record.  Enter the data and save it in the same manner as when you edit a record.
If you cannot access data
If you are having trouble getting files to display at all, most likely you did not complete your workstation setup completely or you do not have any DDF files created, which are needed for this program to function properly.
The workstation setup program automatically runs a program named MDBFXREG on each workstation.  If for some reason this was not done, you can run MDBFXREG as a stand alone program.  To do so, go to UT-A  Run a DBA Program and type MDBFXREG and press <Enter>. 
To create new DDF files, see UT-J  Generate DDF Files.
Password Security
The use of Maintain Database is confined to system administrators and is not something that would be run by the average user.  Access to this program can be controlled via PS-A  System Users/Passwords.  If you want to deny access to this program, set the Use Maintain Database and Check File Integrity? field on the user logon screen in PS-A to N.