Connection and Initialisation


This section describes the CLSQL interface for initialising database interfaces of different types, creating and destroying databases and connecting and disconnecting from databases.

Table of Contents

DATABASE - The super-type of all CLSQL databases
*CONNECT-IF-EXISTS* - Default value for the if-exists parameter of connect.
*DEFAULT-DATABASE* - The default database object to use.
*DEFAULT-DATABASE-TYPE* - The default database type to use
*INITIALIZED-DATABASE-TYPES* - List of all initialized database types
CONNECT - create a connection to a database.
CONNECTED-DATABASES - Return the list of active database objects.
DATABASE-NAME - Get the name of a database object
DATABASE-NAME-FROM-SPEC - Return the database name string corresponding to the given connection specification.
DATABASE-TYPE - Get the type of a database object.
DISCONNECT - close a database connection
DISCONNECT-POOLED - closes all pooled database connections
FIND-DATABASE - >Locate a database object through it's name.
INITIALIZE-DATABASE-TYPE - Initializes a database type
RECONNECT - Re-establishes the connection between a database object and its RDBMS.
STATUS - Print information about connected databases.
CREATE-DATABASE - create a database
DESTROY-DATABASE - destroys a database
PROBE-DATABASE - tests for existence of a database
LIST-DATABASES - List databases matching the supplied connection spec and database type.
WITH-DATABASE - Execute a body of code with a variable bound to a specified database object.
WITH-DEFAULT-DATABASE - Execute a body of code with *default-database* bound to a specified database.