The Database option

Use the Database option to work with databases and transactions.

Use the Database option to:
  • Create a database or select a database.

    The database that you work with is called the current database.

  • Retrieve and display information about a database, such as available dbspaces and the text of routines.
  • Delete an existing database or close the current database.
  • Commit or rollback transactions.

You can access only databases that are on the current database server. To select a database server as current, you can specify a database server when you start DB-Access, you can use the Connection menu, or you can run a CONNECT statement from the SQL menu. If you do not explicitly select a database server, DB-Access uses the default database server that the $INFORMIXSERVER environment variable specifies as the current database.

If you select or create a database when another database is already open, DB-Access closes that database before it makes your selection the current or new database.

The DATABASE menu displays the following options.
Option Purpose
Select Makes a database the current database
Create Builds a new database and makes that database the current database
Info Displays information about the current database
Drop Removes a database from the system. You cannot delete the current database.
cLose Closes the current database
Exit Exits the DATABASE menu and returns you to the main menu

Copyright© 2018 HCL Technologies Limited