14 Common SQL
14.1 Introduction
This chapter describes Common SQL -- the LispWorks interface to SQL. It should be used in conjunction with the relevant chapter of the LispWorks Reference Manual, which contains full reference entries for all the symbols in the SQL package. This chapter is applicable to the Enterprise version of LispWorks only. This chapter covers the following areas:
- Initialization and Connection
- The Functional SQL Interface
- The Object-Oriented (CLOS) SQL Interface
- The Symbolic SQL Syntax
- SQL I/O Recording
- SQL Interface Errors
The LispWorks SQL interface uses the following database terminology:
- Data Definition Language (DDL)
- The language used to specify and interrogate the structure of the database schema.
- Data Manipulation Language (DML)
- The language used for retrieving and modifying data. Also known as query language.
- table
A set of records. Also known as relation.
- attribute
A field of information in the table. Also known as column.
- record
A complete set of attribute values in the table. Also known as tuple, or row.
- view
A display of a table configured to your own needs. Also known as virtual table.