14 The SQL Package

This chapter describes the symbols available in the SQL package which implements Common SQL. You should use this chapter in conjunction with the corresponding chapter in the LispWorks User Guide .

On Windows, Linux and Mac OS, Common SQL is included only in LispWorks Enterprise Edition.

add-sql-stream

attribute-type

cache-table-queries

*cache-table-queries-default*

commit

connect

*connect-if-exists*

connected-databases

create-index

create-table

create-view

create-view-from-class

database-name

*default-database*

*default-database-type*

*default-update-objects-max-len*

def-view-class

delete-instance-records

delete-records

delete-sql-stream

disable-sql-reader-syntax

disconnect

do-query

drop-index

drop-table

drop-view

drop-view-from-class

enable-sql-reader-syntax

execute-command

find-database

initialize-database-type

*initialized-database-types*

insert-records

instance-refreshed

list-attribute-types

list-attributes

list-classes

list-sql-streams

list-tables

locally-disable-sql-reader-syntax

locally-enable-sql-reader-syntax

loop

map-query

print-query

query

reconnect

restore-sql-reader-syntax-state

rollback

select

sql

sql-connection-error

sql-database-data-error

sql-database-error

sql-expression

*sql-enlarge-static*

sql-fatal-error

*sql-libraries*

*sql-loading-verbose*

sql-operation

sql-operator

sql-recording-p

sql-stream

sql-temporary-error

sql-timeout-error

sql-user-error

standard-db-object

start-sql-recording

status

stop-sql-recording

table-exists-p

update-instance-from-records

update-objects-joins

update-records

update-records-from-instance

update-record-from-slot

update-slot-from-record

with-transaction