13 The SQL Package

This chapter describes the symbols available in the sql package. On Windows and Linux, this package is only applicable to the Enterprise version of LispWorks. Symbols from this package can be used to provide your Common Lisp applications with SQL functionality. You should use this chapter in conjunction with the relevant chapter in the LispWorks User Guide .

add-sql-stream

attribute-type

commit

connect

*connect-if-exists*

connected-databases

create-index

create-table

create-view

create-view-from-class

database-name

*default-database*

*default-database-type*

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

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

restore-sql-reader-syntax-state

rollback

select

sql

sql-expression

sql-operation

sql-operator

sql-recording-p

sql-stream

start-sql-recording

status

stop-sql-recording

table-exists-p

update-records

update-records-from-instance

update-record-from-slot

update-record-from-slots

with-transaction