Symbols

! 118

:< debugger command 16

$ (dollar) variable 28

$$ variable 28

$$$ variable 28

:> debugger command 16

> , SQL operator 198

[...] syntax in Common SQL 197

A

:a debugger command 20

abort restart 13

action lists 71

defining 72

examples 76

undefining 72

adding actions to action lists 74

add-special-free-action function 107

add-sql-stream function 204

add-symbol-profiler function 111

advice

after 51

around 51

before 51

example of use 55

facility 49

for macros 53

for methods 53

main chapter 49 , 59

removing 52

after advice 51

:after keyword 38

:all debugger command 18

:all keyword 146

all , SQL operator 198

:allocation keyword 42

allocation-in-gen-num macro 97 , 101

ANSI

Common Lisp 123 , 189

SQL mode 176 , 206

ANSI_QUOTES

SQL mode 206

any , SQL operator 198

arguments

command line 254

around advice 51

ASCII 248

attach-ssl function 231

attach-ssl function 236

attribute-type function 192

augmented-string type 244

avoid-gc function 102

B

:b debugger command 16

backtrace 15

quick backtrace 15

verbose backtrace 16

:backtrace keyword 39

base slot 193

base-char type 243

base-string type 244

before advice 51

:before keyword 37

:bindings keyword 25

:bq debugger command 16

:break keyword 39

:break-on-exit keyword 39

Byte Order Mark 250

C

:c debugger command 20

C functions

malloc 96

memalign 96

realloc 96

cache-table-queries function 187

call-next-advice function 52

catch frame, examining 14

:catchers keyword 25

:caused-by keyword 146

:cc debugger command 18

change-process-priority function 135

character type 243

character types 243

check-fragmentation function 100 , 102

classes

database 177

lob-stream 211 , 215 , 220

socket-stream 231 , 236

ssl-closed 241

ssl-condition 241

ssl-error 241

ssl-failure 241

ssl-x509-lookup 241

standard-db-class 192

standard-db-object 192

clean-down function 95 , 106

clean-generation-0 function 101

collect-generation-2 function 99 , 101

collect-highest-generation function 101

command line 254

command line arguments

-build 255

-display 255

-env 255

-environment 255

-IIOPhost 256

-IIOPnumeric 256

-init 255

-multiprocessing 255

-no-restart-function 256

-ORBport 256

--relocate-image 256

-siteinit 254

commit function 186 , 188 , 213

Common Lisp

systems. See system

Common SQL

[...] syntax 197

case of names 205

database classes 177

database connection 178

database encoding 206

date fields 191 , 210

encoding 180

errors 204

Functional DDL 192

Functional DML 184

functional interface 184

I/O recording 203

initialization 176

iteration 196

main chapter 173

Object Oriented DDL 193

Object Oriented DML 195

object-oriented interface 192

ODBC compliance 175

programmatic interface 201

result types 185 , 209

supported databases 175

symbolic syntax 196

transaction handling 180 , 188 , 209

utilities 203

Common SQL errors

sql-connection-error 204

sql-database-data-error 204

sql-database-error 204

sql-fatal-error 204

sql-temporary-error 204

sql-timeout-error 204

sql-user-error 204

compilation-speed 82

compiler

comparison with interpreter 79

control 82

levels of safety 83

main chapter 79

optimization of 82 - 86

workings of 81

compile-system function 144

configuring the printer 119

connect function 178 , 179 , 180 , 205

connected-databases function 179

connecting to a database

MySQL 180

ODBC 180

Oracle 179

PostgreSQL 183

continue restart 13

copy-to-weak-simple-vector function 107

count-gen-num-allocation function 105

create-index function 192

create-table function 192

create-view function 192

create-view-from-class function 193

creation of process 134

current frame 16

current process 134

*current-process* variable 134

customization

main chapter 115

of editor 116

D

database

classes in Common SQL 177

connection in Common SQL 178

encoding in Common SQL 206

table names 205

database class 177

database-name function 179

databases

supported 175

dates

in Common SQL 191 , 210

DDL 192 , 193

debug 82

debugger

commands 14

control variables 23

invoking from the tracer 39

main chapter 11

debugger commands

:< 16

:> 16

:a 20

:all 18

:b 16

:bq 16

:c 20

:cc 18

:ed 18

:error 18

:get 19

:his 19

:l 17

:lambda 18

:lf 19

:n 17

:p 16

:redo 18

:res 21

:ret 21

:top 21

:use 19

:v 17

*debug-io* variable 23

*debug-print-length* variable 23

*debug-print-level* variable 24

declaim macro 87

declare special form 82 , 86

defadvice macro 50 , 53 , 58

*default-action-list-sort-time* variable 75

*default-database* variable 177 , 178

*default-database-type* variable 177

:default-pathname keyword 145

define-action macro 74

define-action-list macro 72

definition specs 45

defparser

error handling with 154

defparser macro 151

functions defined by 153

defstruct macro 119

*defstruct-generates-print-object-method* variable 119

defsystem macro 145 , 145 - 149

examples of use 148

def-view-class macro 192 , 193

delete-advice macro 52 , 58

delete-instance-records generic function 195

delete-records function 186 , 187

delete-sql-stream function 204

describe function 27

*describe-length* variable 29

*describe-level* special variable 28

describe-object generic function 28

*describe-print-length* variable 28

*describe-print-level* variable 28

destroy-ssl function 239

destroy-ssl-ctx function 239

detach-ssl function 238

diagnostic utilities

for action lists 75

disable-sql-reader-syntax function 203

disconnect function 179

DML 184 , 195

$ (dollar) variable 28

$$ variable 28

$$$ variable 28

:dont-know keyword 17

do-query macro 189 , 212

drop-index function 192

drop-table function 192

drop-view function 192

drop-view-from-class function 193

dspecs

aggregate 63

canonical 60

displaying definitions 68

examples 59

finding definitions 68

grouping definitions 62

new defining forms 61

parts 63

recording definitions 67

E

:ed debugger command 18

editor

customizing 116

editor source code 118

ef-spec 248

enable-sql-reader-syntax function 184 , 203

enlarge-generation function 100 , 102

ensure-ssl function 239

:entrycond keyword 40

:error debugger command 18

error handling

in parser generator 154

errors in Common SQL 204

EUC-JP 249

:eval-after keyword 38

:eval-before keyword 38

evaluating

forms during tracing 37 - 39

except , SQL operator 198

exception handling

for action lists 74

executable 254

execute-command function 190

execution functions 71

execution profiling 109

execution stack

examining 14

:exitcond keyword 40

expand-generation-1 function 101

extended-time macro 105 , 106 , 113

external format specification 248

External formats 248

F

fasl (fast load)

description 79

FDDL 192

FDML 195

files

load-on-demand 119

find-database function 179

find-object-size function 101

find-process-from-name function 134

fixnum-safety 82

flag-not-special-free-action function 107

flag-special-free-action function 107

float 82

float calculations, optimizing 89

foreign types

p-oci-env 216

p-oci-file 216

p-oci-lob-locator 216

p-oci-svc-ctx 216

ssl-ctx-pointer 233

ssl-pointer 233

foreign-slot-value function 91

forms

evaluating when tracing 37 - 39

frame, examining 14

free-important-locks function 138

function, altering with advice 49

function , SQL operator 201

Functional DDL 192

Functional DML 184

functional interface in Common SQL 184

functions

add-special-free-action 107

add-sql-stream 204

add-symbol-profiler 111

arguments for traced 37

attach-ssl 231 , 236

attribute-type 192

avoid-gc 102

cache-table-queries 187

call-next-advice 52

change-process-priority 135

check-fragmentation 100 , 102

clean-down 95 , 106

clean-generation-0 101

collect-generation-2 99 , 101

collect-highest-generation 101

commit 186 , 188 , 213

compile-system 144

connect 178 , 179 , 180 , 205

connected-databases 179

copy-to-weak-simple-vector 107

count-gen-num-allocation 105

create-index 192

create-table 192

create-view 192

create-view-from-class 193

database-name 179

delete-records 186 , 187

delete-sql-stream 204

describe 27

destroy-ssl 239

destroy-ssl-ctx 239

detach-ssl 238

disable-sql-reader-syntax 203

disconnect 179

drop-index 192

drop-table 192

drop-view 192

drop-view-from-class 193

enable-sql-reader-syntax 184 , 203

enlarge-generation 100 , 102

ensure-ssl 239

execute-command 190

expand-generation-1 101

find-database 179

find-object-size 101

find-process-from-name 134

flag-not-special-free-action 107

flag-special-free-action 107

foreign-slot-value 91

free-important-locks 138

gc-generation 105 , 106

gc-if-needed 102

gen-num-segments-fragmentation-state 105

gensym 106

get-default-generation 101

get-folder-path 261

get-gc-parameters 102

get-user-profile-directory 262

initialize-database-type 177

initialize-multiprocessing 136

insert-records 186 , 212

inspect 28

int32- 88

int32+ 88

lisp-image-name 254

list-all-processes 134

list-attributes 192

list-attribute-types 192

list-classes 195

list-sql-streams 204

list-tables 192

lob-stream-lob-locator 215

locally-disable-sql-reader-syntax 203

locally-enable-sql-reader-syntax 203

long-site-name 253

make-array 107

make-hash-table 107

make-lock 138

make-ssl-ctx 236 , 237

make-symbol 106

make-timer 139

map-query 189 , 212

mark-and-sweep 95 , 102

marking-gc 105 , 106

normal-gc 102

open-tcp-stream 231 , 236

ora-lob-append 219

ora-lob-assign 218

ora-lob-char-set-form 217

ora-lob-close 219

ora-lob-copy 219

ora-lob-create-empty 212 , 218

ora-lob-create-temporary 220

ora-lob-disable-buffering 220

ora-lob-element-type 217

ora-lob-enable-buffering 220

ora-lob-env-handle 215

ora-lob-erase 219

ora-lob-file-close 219

ora-lob-file-close-all 219

ora-lob-file-open 219

ora-lob-file-set-name 219

ora-lob-flush-buffer 220

ora-lob-free 218

ora-lob-free-temporary 220

ora-lob-get-buffer 216 , 220

ora-lob-get-chunk-size 218

ora-lob-get-length 218

ora-lob-internal-lob-p 217 , 218

ora-lob-is-equal 218

ora-lob-is-open 218

ora-lob-is-temporary 218 , 220

ora-lob-load-from-file 219

ora-lob-lob-locator 215

ora-lob-locator-is-init 218

ora-lob-open 219

ora-lob-read-buffer 217 , 220

ora-lob-read-foreign-buffer 216 , 217 , 220

ora-lob-read-into-plain-file 220

ora-lob-svc-ctx-handle 215

ora-lob-trim 219

ora-lob-write-buffer 217 , 220

ora-lob-write-foreign-buffer 216 , 217 , 220

ora-lob-write-from-plain-file 220

pem-read 232

print-actions 75

print-profile-list 111

print-query 186

process-allow-scheduling 134

process-arrest-reasons 135

process-break 135

process-interrupt 135

process-kill 135

process-lock 139

process-name 134

process-priority 135

process-run-function 134

process-run-reasons 135

process-unlock 139

process-wait 134 , 135

process-wait-function 135

process-wait-with-timeout 134 , 135

proclaim 82 , 86

product-registry-path 260

ps 134

query 190 , 211

quit 10

read-dhparms 232

reconnect 179

remove-advice 52 , 58

remove-special-free-action 107

remove-symbol-profiler 111

reset-profiler 111

restore-sql-reader-syntax-state 203

results for traced 38

rollback 186 , 188 , 213

room 101 , 105 , 258

room-values 258

save-image 258

save-universal-from-script 259

schedule-timer 139

select 184 , 195 , 211 , 213

set-array-weak 107

set-automatic-gc-callback 105

set-blocking-gen-num 105

set-debugger-options 24

set-default-generation 97 , 101

set-default-segment-size 106

set-delay-promotion 106

set-gc-parameters 95 , 98 , 102

set-gen-num-gc-threshold 105

set-hash-table-weak 107

set-maximum-segment-size 104 , 105

set-minimum-free-space 98 , 101

set-profiler-threshold 111

set-promotion-count 98 , 101

set-spare-keeping-policy 106

set-ssl-ctx-dh 232

set-ssl-ctx-options 232

set-ssl-ctx-password-callback 232

set-ssl-library-path 241

set-up-profiler 110

short-site-name 253

socket-stream-ctx 232

socket-stream-ssl 232

software-type 253

software-version 253

sql 202

sql-expression 201

sql-operation 201

sql-operator 201

sql-recording-p 204

sql-stream 204

ssl-add-client-ca 234

ssl-clear-num-renegotiations 234

ssl-ctrl 233

ssl-ctx-add-client-ca 234

ssl-ctx-add-extra-chain-cert 235

ssl-ctx-ctrl 233

ssl-ctx-get-max-cert-list 235

ssl-ctx-get-mode 234

ssl-ctx-get-options 234

ssl-ctx-get-read-ahead 235

ssl-ctx-load-verify-locations 234

ssl-ctx-need-tmp-rsa 234

ssl-ctx-sess-get-cache-mode 235

ssl-ctx-sess-get-cache-size 235

ssl-ctx-sess-set-cache-mode 235

ssl-ctx-sess-set-cache-size 235

ssl-ctx-set-client-ca-list 234

ssl-ctx-set-max-cert-list 235

ssl-ctx-set-mode 234

ssl-ctx-set-options 234

ssl-ctx-set-read-ahead 235

ssl-ctx-set-tmp-dh 235

ssl-ctx-set-tmp-rsa 235

ssl-ctx-use-certificate-chain-file 233

ssl-ctx-use-certificate-file 233

ssl-ctx-use-privatekey-file 234

ssl-ctx-use-rsaprivatekey-file 234

ssl-get-max-cert-list 235

ssl-get-mode 234

ssl-get-options 234

ssl-load-client-ca-file 234

ssl-need-tmp-rsa 234

ssl-new 239

ssl-num-renegotiations 234

ssl-session-reused 234

ssl-set-accept-state 237

ssl-set-client-ca-list 234

ssl-set-connect-state 237

ssl-set-max-cert-list 235

ssl-set-mode 234

ssl-set-options 234

ssl-set-tmp-dh 235

ssl-set-tmp-rsa 235

ssl-total-renegotiations 234

ssl-use-certificate-file 233

ssl-use-privatekey-file 234

ssl-use-rsaprivatekey-file 234

start-sql-recording 204

status 179

stop-sql-recording 204

sweep-all-objects 107

switch-static-allocation 95 , 96

toggle-source-debugging 91

total-allocation 101

tracing inside 43

try-compact-in-generation 100 , 102

try-move-in-generation 100 , 102

update-records 186 , 187 , 212

user-homedir-pathname 260

user-preference 260

without-preemption 135

fundamental-character-input-stream class 222

fundamental-character-output-stream class 222

G

garbage collection, see also storage management

main chapter 93

gc-generation function 105 , 106

gc-if-needed function 102

generation

definition 94

generation 2 99

generic functions

delete-instance-records 195

describe-object 28

input-stream-p 224

instance-refreshed 195

output-stream-p 224

print-object 119

stream-clear-input 225

stream-element-type 223

stream-line-column 227

stream-listen 226

stream-read-char 224

stream-start-line-p 228

stream-unread-char 225

stream-write-char 226

update-instance-from-records 195

update-record-from-slot 195

update-records-from-instance 195

update-slot-from-record 195

gen-num-segments-fragmentation-state function 105

gensym function 106

:get debugger command 19

get-default-generation function 101

get-folder-path function 261

get-gc-parameters function 102

get-user-profile-directory function 262

grammar

non-terminal 152

resolving ambiguities 153

graphics ports 2

> , SQL operator 198

H

*handle-existing-action-in-action-list* variable 74

*handle-existing-action-list* variable 74

*handle-missing-action-in-action-list* variable 75

*handle-missing-action-list* variable 75

handler frame, examining 14

:handler keyword 25

:hidden keyword 25

*hidden-packages* variable 24

:his debugger command 19

hook functions 71

I

i18n 243

image size 256

initialization

of Common SQL 176

initialize-database-type function 177

*initialized-database-types* variable 178

initialize-multiprocessing function 136

*initial-processes* variable 134

input-stream-p generic function 224

insert-records function 186 , 212

:inside keyword 43

inspect function 28

inspector

main chapter 27

teletype 27

*inspect-print-length* variable 29

*inspect-print-level* variable 29

instance-refreshed generic function 195

in-static-area macro 96

int32- function 88

int32 type 88

int32+ function 88

interface

between parser generator and lexical analyser 154

Common SQL initialization 176

Internationalization 243

interpreter

differences from compiler 79

interruptable 82

intersect , SQL operator 198

introduction

main chapter 1

invalid superclass 124

:invisible keyword 25

ISO8859-1 248

J

JIS 249

join slot 193

K

keywords

:after 38

:all