CLSQL


This part gives a reference to the symbols exported from the CLSQL package. These symbols constitute the normal user-interface of CLSQL. Currently, the symbols of the CommonSQL-API are not documented here.

Table of Contents

SQL-CONDITION - the super-type of all CLSQL-specific conditions
SQL-ERROR - the super-type of all CLSQL-specific errors
SQL-WARNING - the super-type of all CLSQL-specific warnings
CLSQL-USER-ERROR - condition representing errors because of invalid parameters from the library user.
SQL-CONNECTION-ERROR - condition representing errors during connection
SQL-DATABASE-ERROR - condition representing errors during query or command execution
*DEFAULT-DATABASE-TYPE* - The default database type to use
*INITIALIZED-DATABASE-TYPES* - List of all initialized database types
INITIALIZE-DATABASE-TYPE - Initializes a database type
*CONNECT-IF-EXISTS* - Default value for the if-exists parameter of connect.
CONNECTED-DATABASES - Return the list of active database objects.
*DEFAULT-DATABASE* - The default database object to use
DATABASE - The super-type of all CLSQL databases
CLOSED-DATABASE - The class representing all closed CLSQL databases
DATABASE-NAME - Get the name of a database object
FIND-DATABASE - Locate a database object through it's name.
CONNECT - create a connection to a database
DISCONNECT - close a database connection
DISCONNECT-POOLED - closes all pooled database connections
CREATE-DATABASE - create a database
DESTROY-DATABASE - destroys a database
PROBE-DATABASE - tests for existence of a database
DATABASE-NAME-FROM-SPEC - Return the database name string corresponding to the given connection specification.
EXECUTE-COMMAND - Execute an SQL command which returns no values.
QUERY - Execute an SQL query and return the tuples as a list
MAP-QUERY - Map a function over all the tuples from a query
DO-QUERY - Iterate over all the tuples of a query
LOOP-FOR-AS-TUPLES - Iterate over all the tuples of a query via a loop clause