45 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 23 Common SQL. In particular that chapter contains more information about the Oracle LOB interface (that is, those functions with names beginning sql:ora-lob-).

On Microsoft Windows, Linux, x86/x64 Solaris, FreeBSD and macOS, Common SQL is included only in LispWorks Enterprise Edition.

accepts-n-syntax

add-sql-stream

attribute-type

cache-table-queries

*cache-table-queries-default*

commit

connect

connected-databases

*connect-if-exists*

copy-from-sqlite-raw-blob

create-index

create-table

create-view

create-view-from-class

database-name

decode-to-db-standard-date

decode-to-db-standard-timestamp

*default-database*

*default-database-type*

*default-update-objects-max-len*

def-view-class

delete-instance-records

delete-records

delete-sql-stream

destroy-prepared-statement

disable-sql-reader-syntax

disconnect

do-query

drop-index

drop-table

drop-view

drop-view-from-class

enable-sql-reader-syntax

encode-db-standard-date

encode-db-standard-timestamp

execute-command

find-database

initialize-database-type

*initialized-database-types*

insert-records

instance-refreshed

list-attributes

list-attribute-types

list-classes

list-sql-streams

list-tables

lob-stream

locally-disable-sql-reader-syntax

locally-enable-sql-reader-syntax

map-query

*mysql-library-directories*

*mysql-library-path*

*mysql-library-sub-directories*

ora-lob-append

ora-lob-assign

ora-lob-char-set-form

ora-lob-char-set-id

ora-lob-close

ora-lob-copy

ora-lob-create-empty

ora-lob-create-temporary

ora-lob-disable-buffering

ora-lob-element-type

ora-lob-enable-buffering

ora-lob-env-handle

ora-lob-erase

ora-lob-file-close

ora-lob-file-close-all

ora-lob-file-exists

ora-lob-file-get-name

ora-lob-file-is-open

ora-lob-file-open

ora-lob-file-set-name

ora-lob-flush-buffer

ora-lob-free

ora-lob-free-temporary

ora-lob-get-buffer

ora-lob-get-chunk-size

ora-lob-get-length

ora-lob-internal-lob-p

ora-lob-is-equal

ora-lob-is-open

ora-lob-is-temporary

ora-lob-load-from-file

ora-lob-lob-locator

ora-lob-locator-is-init

ora-lob-open

ora-lob-read-buffer

ora-lob-read-foreign-buffer

ora-lob-read-into-plain-file

ora-lob-svc-ctx-handle

ora-lob-trim

ora-lob-write-buffer

ora-lob-write-foreign-buffer

ora-lob-write-from-plain-file

p-oci-env

p-oci-file

p-oci-lob-locator

p-oci-lob-or-file

p-oci-svc-ctx

prepared-statement

prepared-statement-set-and-execute

prepared-statement-set-and-execute*

prepared-statement-set-and-query

prepared-statement-set-and-query*

prepare-statement

print-query

query

reconnect

replace-from-sqlite-blob

replace-from-sqlite-raw-blob

replace-into-sqlite-blob

restore-sql-reader-syntax-state

rollback

select

set-prepared-statement-variables

simple-do-query

sql

sql-connection-error

sql-database-data-error

sql-database-error

*sql-enlarge-static*

sql-expression

sql-expression-object

sql-failed-to-connect-error

sql-fatal-error

sqlite-blob

sqlite-blob-length

sqlite-blob-p

sqlite-close-blob

sqlite-last-insert-rowid

sqlite-open-blob

sqlite-raw-blob

sqlite-raw-blob-length

sqlite-raw-blob-p

sqlite-raw-blob-ref

sqlite-raw-blob-valid-p

sqlite-reopen-blob

*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

string-needs-n-prefix

string-prefix-with-n-if-needed

table-exists-p

update-instance-from-records

update-objects-joins

update-record-from-slot

update-records

update-records-from-instance

update-slot-from-record

*use-n-syntax-for-non-ascii-strings*

with-prepared-statement

with-sqlite-blob

with-transaction