Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
DB-Access User's GuideThe Informix® DB-Access User's Guide describes how to use the DB-Access utility to access, modify, and retrieve information from Informix® database servers.
The full-screen menu interfaceThe DB-Access full-screen menu interface guides you through running SQL statements.
The Database optionUse the Database option to work with databases and transactions.
Close a databaseTo close the current database, use the cLose option from the DATABASE menu.

Close a database

To close the current database, use the cLose option from the DATABASE menu.

If you begin a transaction but do not commit it or roll it back, and then you try to close a database with transactions, the TRANSACTION menu opens. The TRANSACTION menu ensures that you either commit or roll back an active transaction before you close the current database.

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

The TRANSACTION menu also opens whenever you attempt to open a new database or try to leave the DB-Access menu system without first terminating a transaction.

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 commits 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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.