Using Handles with Operations

Go Up to Declaring Multiple Databases

In multi-database programs, database handles must be specified in ­CONNECT statements to identify which databases among several to open and prepare for use in subsequent transactions.

Database handles can also be used with DISCONNECT, COMMIT RELEASE, and ROLLBACK RELEASE to specify a subset of open databases to close.

To open and prepare a database with CONNECT, see Opening a Database. To close a database with DISCONNECT, COMMIT RELEASE, or ­ROLLBACK RELEASE, see Closing a Database. To learn more about using database handles in transactions, see Accessing an Open Database.