Example script

E Obsolete Database Utilities

Example script

### open database

DATABASE "db,DB" PASSWORD "Secret";

### passwords

ALTER PASSWORD {
 1 "READ";
 2 "WRITE";
}

### permissions

REVOKE ALL
OF ALL
FROM ALL;

GRANT READ
ON ALL
TO 1;

GRANT ALL
ON ALL
TO 2;

### items

CREATE ITEM {
 Call-Id,     D;
 Date,        D (2);
 Code,        X20;
 Description, 4X40;
}

### iitems

CREATE IITEM
 ICall-Id = Call-Id;

CREATE IITEM
 ICode = Code:10;

### set

CREATE SET Calls, D {
  Call-Id;
  Date;
  Code;
  Call-Desc;
}
ALTER SET Calls
{
   ADD INDEX ICall-Id;
   ADD INDEX ICode / "german@fold"; 
}

Interactive usage

The following general rules apply:

If a Push button starts with a number, you can press the equivalent function key as an accelerator. For example [8. Exit] can be triggered with the function key F8.
An underlined character indicates that the associated function can be reached by pressing function key F2 and the underlined character.
An entry in a selection list can be selected by pressing the RETURN key or by pressing the space bar.
There is currently no functionality associated with the help push button.

The Entry dialog

This dialog appears if dbutil is executed in interactive mode. The following dialog elements are present:

Database

The database name and path

Maintenance Password

The database maintenance password

Log

Shows the log window

Open the database

Exit

Exit the program

The Main dialog

The following dialog elements are present:

Log

Shows the log window

Exit

Exit the program. If there are unsaved changes, the exit dialog will appear.

The following functions can be selected from the selection list:

Change maintenance password
Change password or access
Data Items
Index Items
Data sets
Add Data Item to Set
Add Index Item to Set
Print Schema definition
Analyze changes
Apply changes

The Log dialog

The log windows holds a log of the most recent performed operation. If an error is encountered, the log dialog pops up automatically. The following dialog elements are present:

Close the log window

The Exit dialog

The exit dialog pops up, if you are about to leave the program while while your changes have not been saved. The following dialog elements are present:

Save changes

If you select this checkbox and enter a file name in the following field, your changes are saved in a session script.

Exit the program. If selected, your changes are saved to a session script file.

Cancel

Don't exit the program, return to main dialog.

The Maintenance Password dialog

The following dialog elements are present:

Save changes.

Cancel

Discard changes, return to main dialog.

The Password dialog

This shows a list of all database access classes along with the password and an access summary. The first access class is PUBLIC which is used, if no password is provided to DBOPEN or no password is defined for the database. The R gives the number of data sets, this access class has READONLY access t, the W gives the number of data sets, this access class has READ/WRITE access to.

By selecting an access class, the access class properties dialog is opened. The following dialog elements are present:

Cancel

Discard changes, return to main dialog.

The Access class properties dialog

In the Access Class properties dialog, you can change the password or the access rights associated with an access class. The following dialog elements are present:

Password

Change the password associated with access class. If the password is empty, the access class becomes disabled. You cannot assign a password for the PUBLIC access class.

Read/Write

Select this to select or modify the data sets, the current access class has READ/WRITE access to.

Read only

Select this to select or modify the data sets, the current access class has READ ONLY access to.

Log

Shows the log window

Save changes, return to password dialog.

Cancel

Discard changes, return to password dialog.

To change the access rights for the current access class, select the Read/Write or Read Only push buttons. This opens the Data Set Selection dialog. It will display the list of data sets. In front of the data set name is a checkbox. If selected, the specified access is allowed for the current access class. If you select a data set, the access is changed.

The Data Item List dialog

This dialog shows all or a subset of the data items in your data base. By selecting a data item, the Data Item Properties dialog is opened. The following dialog elements are present:

Filter

The value entered in this field is used to select, which data items should be displayed. If this field is not empty, only data matching items are displayed

By Set

If selected, the value of the Filter field is considered a data set name. Only data items present in the selected data set are displayed.

Log

Shows the log window

Create

Opens the Item properties dialog to create a new data item.

Close window, return to main dialog.

The Item Properties dialog

The following dialog elements are present:

Item Name

The data item name

Item Count

Number of elements

Item Type

Select an item type

Size

This is only used if the item is of type String. This is the maximum number of characters this item can hold. Size must be an even value.

Item Format

The item Format. This information can be used by QUERY or other programs to format their output. Please refer to the table "Query Format Numbers" for more information.

Log

Shows the log window

Save changes.

Cancel

Discard changes, return to previous dialog.

The Index Item List dialog

This dialog shows all or a subset of the index items in your data base. By selecting a data item, the Index Item Properties dialog is opened. The following dialog elements are present:

Filter

The value entered in this field is used to select, which index items should be displayed. If this field is not empty, only data matching items are displayed

By Set

If selected, the value of the Filter field is considered a data set name. Only data items present in the selected data set are displayed.

Log

Shows the log window

Create

Opens the Item properties dialog to create a new index item.

Close window, return to main dialog.

The Index Item Properties dialog

The following dialog elements are present:

Name

The index item name

Segment / Item

Data item name for this index segment

Segment / Length

If this is a string item, only a leading part of the item may be used in the index.

Log

Shows the log window

Save changes.

Cancel

Discard changes, return to previous dialog.

The Data Set List dialog

This dialog shows all or a subset of the data sets in your data base. By selecting a data set, the Data Set Properties dialog is opened. The following dialog elements are present:

Filter

The value entered in this field is used to select, which data sets should be displayed. If this field is not empty, only matching data sets are displayed

Log

Shows the log window

Create

Opens the data set properties dialog to create a new data set.

Close window, return to main dialog.

The Data Set Properties dialog

The following dialog elements are present:

Set Name

The data set name

Set Type

Select a set type

Capacity

The data set capacity.

Log

Shows the log window

Save changes.

Cancel

Discard changes, return to previous dialog.

The Data Set Entry dialog

This dialog is opened by selecting one of the following entries from the main dialog after selecting an Data Set from the Data Set Selection Dialog.

Add Data Item to Set
Add Index Item to Set

The dialog display the data or index items for the selected data set. The following dialog elements are present:

Log

Shows the log window

Add Item

Opens the Data Item or Index Item dialog.

Close window, return to main dialog.

The Print Schema Definition dialog

The following dialog elements are present:

Write to file

Output Schema definition to file if selected.

File

File name and path.

Print to HP-UX printer

Output Schema definition to printer if selected

Printer

Printer name (and additional options).

Lines/Page

Number of lines / Page. Use zero to avoid no pagination.

Log

Shows the log window

Create Schema definition.

Cancel

Return to main dialog.

The Analyze dialog

The log windows holds a summary of all pending operations. The following dialog elements are present:

Close the window

The Apply dialog

The exit dialog pops up, if you are about apply your changes to your database. The following dialog elements are present:

Save changes

If you select this checkbox and enter a file name in the following field, your changes are saved in a session script.

Analyze

This pops up the Analyze dialog. If summarizes the pending changes.

Apply changes to your database. If selected, your changes are saved to a session script file.

Cancel

Don't apply changes, return to main dialog.

Eloquence Database Manual - 19 DEC 2002