Closing Databases
Go Up to Application Requirements
Once a database is no longer needed, you should close it before the program ends. If you do not, subsequent attempts to use the database may fail or result in database corruption. There are two ways to close a database:
- Use the
DISCONNECT
statement to detach a database and close files. - Use the
RELEASE
option withCOMMIT
orROLLBACK
in a program.
DISCONNECT
, COMMIT RELEASE
, and ROLLBACK RELEASE
perform the following tasks:
- Close open database files.
- Close remote database connections.
- Release the memory that holds database descriptions and InterBase engine-compiled requests.
- Note: Closing databases with
DISCONNECT
is preferred for compatibility with the SQL-92 standard.
For a complete discussion of closing databases, see Working with Databases.