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 146

:allocation 42

:backtrace 39

:before 37

:bindings 25

:break 39

:break-on-exit 39

:catchers 25

:caused-by 146

:default-pathname 145

:dont-know 17

:entrycond 40

:eval-after 38

:eval-before 38

:exitcond 40

:handler 25

:hidden 25

:inside 43

:invisible 25

:maximum-buffer-size 96

:maximum-overflow 99

:members 145

:minimum-buffer-size 96

:minimum-for-sweep 98 , 99

:minimum-overflow 99

:new-generation-size 99

:non-symbol 25

:package 145

:previous 147

:process 42

:requires 147

:restarts 25

:rules 146

:source-only 146

:step 40

:trace-output 41

:when 42

L

:l debugger command 17

:lambda debugger command 18

Latin-1 248

levels of safety, see compiler

:lf debugger command 19

lightweight processes 133

*line-arguments-list* variable 254

lisp-image-name function 254

LispWorks

customizing 115

lightweight processes in 133

processes 133

quitting 9 , 77

saving 8

starting 7 , 77

list-all-processes function 134

list-attributes function 192

list-attribute-types function 192

list-classes function 195

list-sql-streams function 204

list-tables function 192

load-on-demand 119

lob-stream class 211 , 215 , 220

lob-stream-lob-locator function 215

locally-disable-sql-reader-syntax function 203

locally-enable-sql-reader-syntax function 203

locks 138

long-site-name function 253

loop macro

extensions in Common SQL 196

loop , extensions in Common SQL 189

M

macros

advice 53

allocation-in-gen-num 97 , 101

declaim 87

defadvice 50 , 53 , 58

define-action 74

define-action-list 72

defparser 151 , 153

defstruct 119

defsystem 145 , 145 - 149

def-view-class 192 , 193

delete-advice 52 , 58

do-query 189 , 212

extended-time 105 , 106 , 113

in-static-area 96

simple-do-query 189 , 212

undefine-action 74

undefine-action-list 73

with-heavy-allocation 102

with-lock 139

without-interrupts 102 , 135

with-transaction 186 , 188

make-array function 107

make-hash-table function 107

make-lock function 138

make-ssl-ctx function 236 , 237

make-symbol function 106

make-timer function 139

malloc C function 96

map-query function 189 , 212

mark 97

and sweep 97

mark-and-sweep function 95 , 102

marking-gc function 105 , 106

:maximum-buffer-size keyword 96

*maximum-ordinary-windows* variable 117

:maximum-overflow keyword 99

*max-trace-indent* variable 45

memalign C function 96

:members keyword 145

memory allocation during tracing 42

memory management 256

garbage collection strategy 98

image reduction 106

mark and sweep 97

overflow 99

timing in 105 , 106

Metaobject Protocol 121

method

advice 53

methods

tracing 45

:minimum-buffer-size keyword 96

:minimum-for-sweep keyword 98 , 99

:minimum-overflow keyword 99

minus , SQL operator 198

mod 2^32 arithmetic 88

modifying a database 186

MOP

AMOP compatibility 121

multi-processing

locks 138

MySQL

connecting 180

MySQL client library 182

Mac OS X 182

*mysql-library-directories* variable 182

*mysql-library-path* variable 182

N

:n debugger command 17

:new-generation-size keyword 99

:non-symbol keyword 25

non-terminal in grammar 152

normal-gc function 102

not , SQL operator 198

O

object

object-oriented interface in Common SQL 192

static 96

Object Oriented DDL in Common SQL 193

Object Oriented DML in Common SQL 195

ODBC

connecting 180

OODDL 193

OODML 195

open-tcp-stream function 231 , 236

operating system 253

optimization

fast 32-bit arithmetic 88

floating point 89

foreign slot access 91

of compiler 82

tail call 90

optimization declarations 82

optimize 82

optimize qualities 83 - 85

Oracle

connecting 179

Oracle Call Interface

in Common SQL 179

ora-lob-append function 219

ora-lob-assign function 218

ora-lob-char-set-form function 217

ora-lob-close function 219

ora-lob-copy function 219

ora-lob-create-empty function 212 , 218

ora-lob-create-temporary function 220

ora-lob-disable-buffering function 220

ora-lob-element-type function 217

ora-lob-enable-buffering function 220

ora-lob-env-handle function 215

ora-lob-erase function 219

ora-lob-file-close function 219

ora-lob-file-close-all function 219

ora-lob-file-open function 219

ora-lob-file-set-name function 219

ora-lob-flush-buffer function 220

ora-lob-free function 218

ora-lob-free-temporary function 220

ora-lob-get-buffer function 216 , 220

ora-lob-get-chunk-size function 218

ora-lob-get-length function 218

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

ora-lob-is-equal function 218

ora-lob-is-open function 218

ora-lob-is-temporary function 218 , 220

ora-lob-load-from-file function 219

ora-lob-lob-locator function 215

ora-lob-locator-is-init function 218

ora-lob-open function 219

ora-lob-read-buffer function 217 , 220

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

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

ora-lob-svc-ctx-handle function 215

ora-lob-trim function 219

ora-lob-write-buffer function 217 , 220

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

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

output

trace 41

output-stream-p generic function 224

P

:p debugger command 16

package

hiding 24

:package keyword 145

packages

allocation of 106

parser generator main chapter 151

parser, error handling 154

patches

saving an image with 9

pem-read function 232

platform 253

p-oci-env foreign type 216

p-oci-file foreign type 216

p-oci-lob-locator foreign type 216

p-oci-svc-ctx foreign type 216

PostgreSQL

connecting 183

PostScript Printer Description files 119

PPD files 120

:previous keyword 147

print-actions function 75

*print-binding-frames* variable 24

*print-catch-frames* variable 24

printer

configuring 119

*print-handler-frames* variable 24

*print-non-symbol-frames* variable 24

print-object generic function 119

*print-open-frames* variable 24

print-profile-list function 111

print-query function 186

*print-restart-frames* variable 24

process

creation 134

current 134

in LispWorks 133

scheduling 135

process exit status 258

:process keyword 42

process-allow-scheduling function 134

process-arrest-reasons function 135

process-break function 135

processes

allocation of 107

*process-initial-bindings* variable 134

process-interrupt function 135

process-kill function 135

process-lock function 139

process-name function 134

process-priority function 135

process-run-function function 134

process-run-reasons function 135

process-unlock function 139

process-wait function 134 , 135

process-wait-function function 135

process-wait-with-timeout function 134 , 135

proclaim function 82 , 86

product-registry-path function 260

profile time 110

profiler

interpretation of results 111

main chapter 109

pitfalls 112

setting up 110

*profile-symbol-list* variable 111

profiling

execution 109

program 109

program profiling 109

ps function 134

Q

query function 190 , 211

quick backtrace 15

quit function 10

quitting LispWorks 9 , 77

R

raw 32-bit arithmetic 88

read-dhparms function 232

real time 110

realloc C function 96

reconnect function 179

redo 118

:redo debugger command 18

remove-advice function 52 , 58

remove-special-free-action function 107

remove-symbol-profiler function 111

removing actions from action lists 74

:requires keyword 147

:res debugger command 21

reset-profiler function 111

restart 13

restart frame, examining 14

:restarts keyword 25

restore-sql-reader-syntax-state function 203

:ret debugger command 21

rollback function 186 , 188 , 213

room function 101 , 105 , 258

room-values function 258

:rules keyword 146

S

safety 82

save-image function 258

save-universal-from-script function 259

schedule-timer function 139

scheduling of processes 135

segmentation violation in compiled code 85

select function 184 , 195 , 211 , 213

select , SQL operator 198

set-array-weak function 107

set-automatic-gc-callback function 105

set-blocking-gen-num function 105

set-debugger-options function 24

set-default-generation function 97 , 101

set-default-segment-size function 106

set-delay-promotion function 106

set-gc-parameters function 95 , 98 , 102

set-gen-num-gc-threshold function 105

set-hash-table-weak function 107

set-maximum-segment-size function 104 , 105

set-minimum-free-space function 98 , 101

set-profiler-threshold function 111

set-promotion-count function 98 , 101

set-spare-keeping-policy function 106

set-ssl-ctx-dh function 232

set-ssl-ctx-options function 232

set-ssl-ctx-password-callback function 232

set-ssl-library-path function 241

set-up-profiler function 110

Shift JIS 249

short-site-name function 253

Show Paths From Editor command 91

shutdown 77

simple-char type 243

simple-do-query macro 189 , 212

simple-int32-vector type 88

simple-string type 245

socket-stream class 231

socket-stream class 236

socket-stream-ctx function 232

socket-stream-ssl function 232

software-type function 253

software-version function 253

some , SQL operator 198

*source-found-action* variable 117

:source-only keyword 146

space 82

special forms

declare 82 , 86

special variables

*describe-level* 28

speed 82

SQL

database functions 201

direct specification 190

mode 206

stored procedure 190

sql function 202

sql-connection-error error 204

sql-database-data-error error 204

sql-database-error error 204

sql-expression function 201

sql-fatal-error error 204

*sql-libraries* variable 178

*sql-loading-verbose* variable 178 , 187

sql-operation function 201

sql-operator function 201

sql-recording-p function 204

sql-stream function 204

sql-temporary-error error 204

sql-timeout-error error 204

sql-user-error error 204

square bracket syntax 197

ssl-add-client-ca function 234

ssl-clear-num-renegotiations function 234

ssl-closed class 241

ssl-condition class 241

ssl-ctrl function 233

ssl-ctx-add-client-ca function 234

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

ssl-ctx-ctrl function 233

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

ssl-ctx-get-mode function 234

ssl-ctx-get-options function 234

ssl-ctx-get-read-ahead function 235

ssl-ctx-load-verify-locations function 234

ssl-ctx-need-tmp-rsa function 234

ssl-ctx-pointer foreign type 233

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

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

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

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

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

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

ssl-ctx-set-mode function 234

ssl-ctx-set-options function 234

ssl-ctx-set-read-ahead function 235

ssl-ctx-set-tmp-dh function 235

ssl-ctx-set-tmp-rsa function 235

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

ssl-ctx-use-certificate-file function 233

ssl-ctx-use-privatekey-file function 234

ssl-ctx-use-rsaprivatekey-file function 234

ssl-error class 241

ssl-failure class 241

ssl-get-max-cert-list function 235

ssl-get-mode function 234

ssl-get-options function 234

ssl-load-client-ca-file function 234

ssl-need-tmp-rsa function 234

ssl-new function 239

ssl-num-renegotiations function 234

ssl-pointer foreign type 233

ssl-session-reused function 234

ssl-set-accept-state function 237

ssl-set-client-ca-list function 234

ssl-set-connect-state function 237

ssl-set-max-cert-list function 235

ssl-set-mode function 234

ssl-set-options function 234

ssl-set-tmp-dh function 235

ssl-set-tmp-rsa function 235

ssl-total-renegotiations function 234

ssl-use-certificate-file function 233

ssl-use-privatekey-file function 234

ssl-use-rsaprivatekey-file function 234

ssl-x509-lookup class 241

stack

examining 14

stacks

allocation of 107

standard-db-class class 192

standard-db-object class 192

start 77

start LispWorks 7

starting LispWorks 7 , 77

start-sql-recording function 204

startup 77

static object

allocation in memory management 96

status function 179

:step keyword 40

stepper, entering when tracing 40

stop-sql-recording function 204

storage management

main chapter 93

stream-clear-input generic function 225

stream-element-type generic function 223

stream-line-column generic function 227

stream-listen generic function 226

stream-read-char generic function 224

streams

defining new 222

directionality 223

example 222 - 229

input 224

instantiating 228

output 226

user defined 221

stream-start-line-p generic function 228

stream-unread-char generic function 225

stream-write-char generic function 226

string construction 246

string type 244

string types 244

superclass

invalid 124

sweep 97

sweep-all-objects function 107

switch-static-allocation function 95 , 96

*symbol-alloc-gen-num* variable 101 , 106

symbolic query syntax 196

symbolic syntax in Common SQL 196

symbols

allocation of 106

syntax, in Common SQL 196

system

defining 144 - 149

introduction to 143 - 144

members of 145

plan 146

rules 146 - 147

T

tail call 90

tail call merging 90

tail call optimization 90

tail merge 90

tail recursion 90

tail-call 90

teletype inspector 27

text-string type 244

threads

allocation of 107

timers 139

I/O 140

input and output 140

process 139

toggle-source-debugging function 91

tools

inspector 27

:top debugger command 21

total-allocation function 101

trace

main chapter 35

*traced-arglist* variable 37 , 38 , 40 , 46

*traced-results* variable 38 , 46

*trace-indent-width* variable 46

*trace-level* variable 46

:trace-output keyword 41

*trace-output* variable 46

*trace-print-circle* variable 46

*trace-print-length* variable 28 , 46

*trace-print-level* variable 28 , 46

*trace-print-pretty* variable 47

tracer

:after option 38

:allocation option 42

:before option 37

:break option 39

:break-on-exit option 39

commands available 37 - 44

definition specs 45

directing output 41

entering the stepper 40

:entrycond option 40

:eval-after option 38

:eval-before option 38

evaluating forms 37 - 39

example of use 35

:exitcond option 40

functions, tracing inside 43

information displayed 36

:inside option 43

invoking the debugger 39

memory allocation 42

methods, tracing 45

:process option 42

restricting to a process 42

:step option 40

traced function, arguments for 37

traced functions, results for 38

:trace-output option 41

transaction handling

in Common SQL 180 , 188 , 209

try-compact-in-generation function 100 , 102

try-move-in-generation function 100 , 102

types

augmented-string 244

base-char 243

base-string 244

character 243

int32 88

simple-char 243

simple-int32-vector 88

simple-string 245

string 244

text-string 244

U

UCS-2 249

undefine-action macro 74

undefine-action-list macro 73

Unicode 243

union , SQL operator 198

universal binaries 259

update-instance-from-records generic function 195

update-record-from-slot generic function 195

update-records function 186 , 187 , 212

update-records-from-instance generic function 195

update-slot-from-record generic function 195

:use debugger command 19

user defined stream 221

user-homedir-pathname function 260

user-preference function 260

UTF-8 249

utilities in Common SQL 203

V

:v debugger command 17

variables

$ (dollar) 28

$$ 28

$$$ 28

*current-process* 134

*debug-io* 23

*debug-print-length* 23

*debug-print-level* 24

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

*default-database* 177 , 178

*default-database-type* 177

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

*describe-length* 29

*describe-print-length* 28

*describe-print-level* 28

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

*handle-existing-action-list* 74

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

*handle-missing-action-list* 75

*hidden-packages* 24

*initialized-database-types* 178

*initial-processes* 134

*inspect-print-length* 29

*inspect-print-level* 29

*line-arguments-list* 254

*maximum-ordinary-windows* 117

*max-trace-indent* 45

*mysql-library-directories* 182

*mysql-library-path* 182

*print-binding-frames* 24

*print-catch-frames* 24

*print-handler-frames* 24

*print-non-symbol-frames* 24

*print-open-frames* 24

*print-restart-frames* 24

*process-initial-bindings* 134

*profile-symbol-list* 111

*source-found-action* 117

*sql-libraries* 178

*sql-loading-verbose* 178 , 187

*symbol-alloc-gen-num* 101 , 106

*traced-arglist* 37 , 38 , 40 , 46

*traced-results* 38 , 46

*trace-indent-width* 46

*trace-level* 46

*trace-output* 46

*trace-print-circle* 46

*trace-print-length* 28 , 46

*trace-print-level* 28 , 46

*trace-print-pretty* 47

verbose backtrace 16

virtual (ordinary) slots 193

virtual time 110

W

:when keyword 42

with-heavy-allocation macro 102

with-lock macro 139

without-interrupts macro 102 , 135

without-preemption function 135

with-transaction macro 186 , 188