47 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 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, AIX and Mac OS X, 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

*connect-if-exists*

connected-databases

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

encode-db-standard-date

*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-timestamp

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

lob-stream

locally-disable-sql-reader-syntax

locally-enable-sql-reader-syntax

loop

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-into-plain-file

ora-lob-read-foreign-buffer

ora-lob-svc-ctx-handle

ora-lob-trim

ora-lob-write-buffer

ora-lob-write-from-plain-file

ora-lob-write-foreign-buffer

p-oci-env

p-oci-file

p-oci-lob-locator

p-oci-lob-or-file

p-oci-svc-ctx

prepare-statement

prepared-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-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

*sql-libraries*

*sql-loading-verbose*

sql-operation

sql-operator

sql-recording-p

sql-stream

sql-temporary-error

sql-timeout-error

sql-user-error

sqlite-raw-blob-ref

sqlite-raw-blob-valid-p

sqlite-reopen-blob

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-records

update-records-from-instance

update-record-from-slot

update-slot-from-record

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

with-sqlite-blob

with-transaction

LispWorks User Guide and Reference Manual - 20 Sep 2017