Приложение 1

Структура меню программы dbaccess

Меню верхнего уровня программы dbaccess:

DBACCESS: Query-language Connection Database Table Session Exit

----------------------- vms@shmspark ----------- Press CTRL-W for Help --------

Query-language	Use SQL query language
Connection	Connect or disconnect from a database environment
Database	Select, Create, Info, Drop or Close a database
Table	Create, Alter, or Drop a database table
Session	Retrieve information about the current DBAccess session
Exit	Exit DBACCESS

Меню Query-language

SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit

----------------------- vms@shmspark ----------- Press CTRL-W for Help --------

New	Enter new SQL statements using SQL editor
Run	Run the current SQL statements
Modify	Modify the current SQL statements using the SQL editor
Use-editor	Modify the current SQL statements using a user-specified editor
Output	Run and send query results to a printer, file, or pipe
Choose	Choose a command file as the current SQL statements
Save	Save the current command in a command file
Info	Gives information on tables in the database
Drop	Drop an SQL command file
Exit	Return to the DBAccess Menu

Меню Connection

CONNECTION: Connect Disconnect Exit

----------------------- vms@shmspark ----------- Press CTRL-W for Help --------

Connect	Connect to a database environment.
Disconnect	Disconnect from the current database environment
Exit	Returns to the DBAccess Menu.

Меню Database

DATABASE: Select Create Info Drop cLose Exit

----------------------- vms@shmspark ----------- Press CTRL-W for Help --------

Select	Select a database to work with
Create	Create a new database
Info	Retrieve information about a database
Drop	Drop a database
cLose	Close the current database
Exit	Return to the DBACCESS menu

]Меню Table

TABLE: Create Alter Info Drop Exit

----------------------- vms@shmspark ----------- Press CTRL-W for Help --------

Create	Create a new table
Alter	Alter the structure of existing table
Info	Display information about the tables in the current database
Drop	Drop a table
Exit	Return to the DBACCESS menu