Closing a Database

Home | Previous Page | Next Page The Database Option >

Closing a Database

To close the current database, choose the cLose option from the DATABASE menu and press RETURN. The message Database Closed appears at the bottom of the screen, which indicates that the current database is closed. The database name disappears from the Help line, but the database server name remains.

If you select the cLose option when no database name is on the Help line, DB–Access displays an error message.

If you begin a transaction but do not commit it or roll it back, and then try to close a database with transactions, the TRANSACTION menu appears, as Figure 41 shows.

Figure 41. The TRANSACTION Menu for Databases with Transactions

TRANSACTION:    Commit   Rollback
Commit the current transaction.

------------- demodb@dbserver1 --------------- Press CTRL-W for Help ------

The TRANSACTION menu ensures that you either commit or roll back an active transaction before you close the current database. The following list shows the two menu options:

The default option is Commit.
Press the Y key or RETURN and DB–Access commits the transactions and closes the database.
If you want to roll back the transactions, use an arrow key to move the highlight to the Rollback option.
Press RETURN, and DB–Access rolls back the transactions and closes the database.

Warning:

Select an option carefully. You might commit transactions you do not want if you select Commit, and you will lose any new transactions if you select Rollback.

If you press the Interrupt key, DB–Access displays the DATABASE menu without committing or rolling back the transactions.

The TRANSACTION menu also appears whenever you attempt to open a new database or try to leave the DB–Access menu system without first terminating a transaction. These instances are the only times when you can access the TRANSACTION menu from DB–Access.

Important:

If you begin a transaction in an ANSI-compliant database but do not issue a COMMIT statement or ROLLBACK statement, then try to close the database using a non-menu mode, DB–Access will commit the transaction for you. If you do not want to commit the transaction, issue both a ROLLBACK statement and a CLOSE DATABASE statement from the command line.