
! 89
:< debugger command 10
$ (dollar) variable 22
$$ variable 22
$$$ variable 22
:> debugger command 10
[...] syntax in SQL 150
:a debugger command 14
abort restart 7
action lists 53
defining 54
examples 58
undefining 54
adding actions to action lists 56
add-special-free-action function 79
add-sql-stream function 158
add-symbol-profiler function 82
after 45
around 45
before 45
example of use 49
facility 43
for macros 47
for methods 47
main chapter 43
removing 46
after advice 45
:after keyword 32
:all debugger command 12
:all keyword 102
all , SQL operator 151
:allocation keyword 36
allocation-in-gen-num function 79
allocation-in-gen-num macro 74
any , SQL operator 151
around advice 45
ASCII 174
attribute-type function 142
avoid-gc function 79
:b debugger command 10
backtrace 9
quick backtrace 9
verbose backtrace 10
:backtrace keyword 33
base slot 145
before advice 45
:before keyword 31
:bindings keyword 18
:bq debugger command 10
:break keyword 33
:break-on-exit keyword 33
Byte Order Mark 176
:c debugger command 14
call-next-advice function 46
catch frame, examining 8
:catchers keyword 18
:caused-by keyword 102
:cc debugger command 12
character types 171
check-fragmentation function 77 , 79
database 131
standard-db-class 144
standard-db-object 144
clean-generation-0 function 79
collect-generation-2 function 77 , 79
collect-highest-generation function 79
commit function 137
commit function 139
systems. See system
compilation-speed 64
comparison with interpreter 61
control 64
levels of safety 65
main chapter 61
workings of 63
compile-system function 100
connect function 133
connected-databases function 132
*connect-if-exists* variable 133
continue restart 7
create-index function 143
create-table function 143
create-view function 144
create-view-from-class function 145
creation of process 92
current frame 10
current process 92
*current-process* variable 92
main chapter 87
of editor 88
classes in SQL 131
connection in SQL 132
database class 131
database-name function 134
debug 64
commands 8
control variables 17
invoking from the tracer 33
main chapter 5
:< 10
:> 10
:a 14
:all 12
:b 10
:bq 10
:c 14
:cc 12
:ed 12
:error 12
:get 13
:his 13
:l 11
:lambda 12
:lf 13
:n 11
:p 10
:redo 12
:res 15
:ret 15
:top 15
:use 13
:v 11
*debug-io* variable 17
*debug-print-length* variable 17
*debug-print-level* variable 17
declaim macro 69
*default-database* variable 131 , 132
*default-database-type* variable 132
:default-pathname keyword 101
define-action macro 56
define-action-list macro 54
definition specs 39
error handling with 110
defparser macro 107
functions defined by 109
defsystem macro 101 , 101 - 105
examples of use 104
def-view-class macro 144 , 145
delete-instance-records generic function 149
delete-records function 137
delete-records function 138
delete-sql-stream function 158
describe function 21
*describe-length* variable 23
*describe-level* special variable 22
describe-object generic function 22
*describe-print-length* variable 22
*describe-print-level* variable 22
for action lists 57
disable-sql-reader-syntax function 156
disconnect function 133
$ (dollar) variable 22
$$ variable 22
$$$ variable 22
:dont-know keyword 11
do-query macro 140
drop-index function 144
drop-table function 143
drop-view function 144
drop-view-from-class function 146
:ed debugger command 12
customizing 88
ef-spec 174
enable-sql-reader-syntax function 135 , 156
:entrycond keyword 34
:error debugger command 12
in parser generator 110
errors in SQL 158
EUC-JP 174
:eval-after keyword 32
:eval-before keyword 32
for action lists 56
execute-command function 140
execution functions 53
execution profiling 81
examining 8
:exitcond keyword 34
expand-generation-1 function 79
external format specification 174
External formats 174
description 61
FDDL 142
FDML 147
load-on-demand 89
find-database function 134
find-object-size function 78
find-process-from-name function 92
fixnum-safety 64
flag-not-special-free-action function 79
flag-special-free-action function 79
float 64
float calculations, optimizing 65
evaluating when tracing 31 - 33
frame, examining 8
free-important-locks function 95
function, altering with advice 43
Functional DDL 142
Functional DML 135
functional interface in SQL 134
add-special-free-action 79
add-sql-stream 158
add-symbol-profiler 82
allocation-in-gen-num 79
arguments for traced 31
attribute-type 142
avoid-gc 79
call-next-advice 46
clean-generation-0 79
collect-highest-generation 79
compile-system 100
connect 133
connected-databases 132
create-index 143
create-table 143
create-view 144
create-view-from-class 145
database-name 134
delete-sql-stream 158
describe 21
disable-sql-reader-syntax 156
disconnect 133
drop-index 144
drop-table 143
drop-view 144
drop-view-from-class 146
enable-sql-reader-syntax 135 , 156
execute-command 140
expand-generation-1 79
find-database 134
find-object-size 78
find-process-from-name 92
flag-not-special-free-action 79
flag-special-free-action 79
free-important-locks 95
gc-if-needed 79
get-default-generation 79
get-gc-parameters 79
initialize-database-type 131 , 132
initialize-multiprocessing 93
insert-records 137
inspect 22
list-all-processes 92
list-attributes 142
list-classes 147
list-sql-streams 158
locally-disable-sql-reader-syntax 156
locally-enable-sql-reader-syntax 156
make-lock 95
map-query 140
normal-gc 79
print-actions 57
print-profile-list 83
print-query 136
process-allow-scheduling 92
process-arrest-reasons 92
process-break 93
process-interrupt 93
process-kill 93
process-lock 96
process-name 92
process-priority 93
process-run-function 92
process-run-reasons 92
process-unlock 96
process-wait-function 93
process-wait-with-timeout 92 , 93
ps 92
query 140
remove-special-free-action 79
remove-symbol-profiler 82
reset-profiler 82
restore-sql-reader-syntax-state 156
results for traced 32
room 78
set-debugger-options 18
set-default-generation 74 , 79
set-gc-parameters 73 , 75 , 76 , 79
set-minimum-free-space 76 , 79
set-profiler-threshold 82
set-up-profiler 82
sql 154
sql-expression 153
sql-operation 153
sql-operator 154
sql-recording-p 157
sql-stream 158
start-sql-recording 157
status 134
stop-sql-recording 157
sweep-all-objects 79
switch-static-allocation 73
symbol-to-string 110
toggle-source-debugging 70
total-allocation 78
tracing inside 37
try-compact-in-generation 77 , 79
try-move-in-generation 77 , 79
without-interrupts 93
without-preemption 93
fundamental-character-input-stream class 162
fundamental-character-output-stream class 162
garbage collection, see also storage management
main chapter 71
gc-if-needed function 79
definition 72
generation 2 77
delete-instance-records 149
describe-object 22
input-stream-p 164
output-stream-p 164
stream-clear-input 165
stream-element-type 163
stream-line-column 167
stream-listen 166
stream-read-char 164
stream-start-line-p 168
stream-unread-char 165
stream-write-char 166
update-record-from-slot 148
update-record-from-slots 148
update-records-from-instance 148
:get debugger command 13
get-default-generation function 79
get-gc-parameters function 79
non-terminal 108
resolving ambiguities 109
graphics ports 2
> , SQL operator 151
group-by , SQL operator 151
handler frame, examining 8
:handler keyword 18
having , SQL operator 151
:hidden keyword 18
*hidden-packages* variable 17
:his debugger command 13
hook functions 53
i18n 171
of SQL 131
initialize-database-type function 131
initialize-database-type function 132
*initialized-database-types* variable 132
initialize-multiprocessing function 93
*initial-processes* variable 92
input-stream-p generic function 164
insert-records function 137
:inside keyword 37
inspect function 22
main chapter 21
teletype 21
*inspect-print-length* variable 23
*inspect-print-level* variable 23
in-static-area macro 73
between parser generator and lexical analyser 111
SQL initialization 131
Internationalization 171
differences from compiler 61
interruptable 64
intersection , SQL operator 151
main chapter 1
:invisible keyword 19
ISO8859-1 174
:after 32
:all 102
:allocation 36
:backtrace 33
:before 31
:bindings 18
:break 33
:break-on-exit 33
:catchers 18
:caused-by 102
:default-pathname 101
:dont-know 11
:entrycond 34
:eval-after 32
:eval-before 32
:exitcond 34
:handler 18
:hidden 18
:inside 37
:invisible 19
:maximum-buffer-size 73
:maximum-overflow 76
:members 101
:minimum-buffer-size 73
:minimum-overflow 76
:new-generation-size 77
:non-symbol 18
:package 101
:previous 103
:process 36
:requires 103
:restarts 18
:rules 102
:source-only 102
:step 34
:trace-output 35
:when 36
:l debugger command 11
:lambda debugger command 12
Latin-1 174
levels of safety, see compiler
:lf debugger command 13
lightweight processes 91
lightweight processes in LispWorks 91
customizing 87
lightweight processes in 91
processes 91
list-all-processes function 92
list-attributes function 142
list-classes function 147
list-sql-streams function 158
list-tables macro 142
load-on-demand 89
locally-disable-sql-reader-syntax function 156
locally-enable-sql-reader-syntax function 156
locks 95
loop macro 140
extensions in Common SQL 149
loop , extensions in Common SQL 141
advice 47
allocation-in-gen-num 74
declaim 69
define-action 56
define-action-list 54
do-query 140
in-static-area 73
list-tables 142
loop 140
undefine-action 56
undefine-action-list 55
with-heavy-allocation 79
with-lock 96
without-interrupts 79
make-lock function 95
map-query function 140
mark 74
and sweep 74
mark-and-sweep function 72 , 79
:maximum-buffer-size keyword 73
*maximum-ordinary-windows* variable 88
:maximum-overflow keyword 76
*max-trace-indent* variable 39
:members keyword 101
memory allocation during tracing 36
garbage collection strategy 75
image reduction 79
mark and sweep 74
overflow 76
timing in 78
advice 47
tracing 39
:minimum-buffer-size keyword 73
:minimum-for-sweep keyword 75 , 76
:minimum-overflow keyword 76
minus , SQL operator 151
modifying a database 137
locks 95
:n debugger command 11
:new-generation-size keyword 77
:non-symbol keyword 18
non-terminal in grammar 108
normal-gc function 79
not , SQL operator 151
object-oriented interface in SQL 144
static 73
Object Oriented DDL in SQL 145
Object Oriented DML in SQL 147
OODDL 145
OODML 147
of compiler 64
optimization declarations 64
optimize 64
trace 35
output-stream-p generic function 164
:p debugger command 10
hiding 17
:package keyword 101
parser generator main chapter 107
parser, error handling 110
:previous keyword 103
print-actions function 57
*print-binding-frames* variable 18
*print-catch-frames* variable 18
*print-handler-frames* variable 18
*print-non-symbol-frames* variable 18
*print-open-frames* variable 18
print-profile-list function 83
print-query function 136
*print-restart-frames* variable 18
creation 92
current 92
in LispWorks 91
:process keyword 36
process-allow-scheduling function 92
process-arrest-reasons function 92
process-break function 93
*process-initial-bindings* variable 92
process-interrupt function 93
process-kill function 93
process-lock function 96
process-name function 92
process-priority function 93
process-run-function function 92
process-run-reasons function 92
process-unlock function 96
process-wait-function function 93
process-wait-with-timeout function 92 , 93
interpretation of results 83
main chapter 81
pitfalls 84
setting up 82
*profile-symbol-list* variable 82
execution 81
program 81
program profiling 81
ps function 92
redo 89
:redo debugger command 12
remove-advice function 46 , 52
remove-special-free-action function 79
remove-symbol-profiler function 82
removing actions from action lists 56
:requires keyword 103
:res debugger command 15
reset-profiler function 82
restart 7
restart frame, examining 8
:restarts keyword 18
restore-sql-reader-syntax-state function 156
:ret debugger command 15
room function 78
:rules keyword 102
safety 64
segmentation violation in compiled code 68
select function 147
select function 135
select , SQL operator 151
set-debugger-options function 18
set-default-generation function 74 , 79
set-gc-parameters function 73 , 75 , 76 , 79
set-minimum-free-space function 76 , 79
set-profiler-threshold function 82
set-promotion-count function 75 , 79
set-up-profiler function 82
Shift JIS 175
show paths from Editor command 70
:source-only keyword 102
space 64
*describe-level* 22
speed 64
[...] syntax 150
database classes 131
database connection 132
errors 158
Functional DDL 142
Functional DML 135
functional interface 134
I/O recording 157
interface initialization 131
iteration 149
main chapter 129
Object Oriented DDL 145
Object Oriented DML 147
object-oriented interface 144
programmatic interface 153
symbolic syntax 149
transaction handling 138
utilities 155
sql-database-error 158
sql-error 158
sql-reader-error 158
sql-type-check-error 159
sql-type-coercion-error 159
sql function 154
sql-database-error error 158
sql-error error 158
sql-expression function 153
sql-operation function 153
sql-operator function 154
sql-reader-error error 158
sql-recording-p function 157
sql-stream function 158
sql-type-check-error error 159
sql-type-coercion-error error 159
square bracket syntax 150
examining 8
standard-db-class class 144
standard-db-object class 144
*standard-output* variable 136
start-sql-recording function 157
allocation in memory management 73
status function 134
:step keyword 34
stepper, entering when tracing 34
stop-sql-recording function 157
main chapter 71
stream-clear-input generic function 165
stream-element-type generic function 163
stream-line-column generic function 167
stream-listen generic function 166
stream-read-char generic function 164
defining new 162
directionality 163
input 164
instantiating 168
output 166
user defined 161
stream-start-line-p generic function 168
stream-unread-char generic function 165
stream-write-char generic function 166
string construction 173
string types 172
sweep 74
sweep-all-objects function 79
switch-static-allocation function 73
*symbol-alloc-gen-num* variable 74 , 79
symbolic query syntax 149
symbolic syntax in SQL 149
symbol-to-string function 110
syntax, in SQL 149
members of 101
plan 102
teletype inspector 21
toggle-source-debugging function 70
inspector 21
:top debugger command 15
total-allocation function 78
main chapter 29
*traced-arglist* variable 31 , 32 , 34 , 40
*traced-results* variable 32 , 40
*trace-indent-width* variable 40
*trace-level* variable 40
:trace-output keyword 35
*trace-output* variable 40
*trace-print-circle* variable 40
*trace-print-length* variable 22 , 40
*trace-print-level* variable 22 , 40
*trace-print-pretty* variable 41
:after option 32
:allocation option 36
:before option 31
:break option 33
:break-on-exit option 33
definition specs 39
directing output 35
entering the stepper 34
:entrycond option 34
:eval-after option 32
:eval-before option 32
example of use 29
:exitcond option 34
functions, tracing inside 37
information displayed 30
:inside option 37
invoking the debugger 33
memory allocation 36
methods, tracing 39
:process option 36
restricting to a process 36
:step option 34
traced function, arguments for 31
:trace-output option 35
trced functions, results for 32
transaction handling 138
try-compact-in-generation function 77
try-move-in-generation function 77
UCS-2 174
undefine-action macro 56
undefine-action-list macro 55
Unicode 171
union , SQL operator 151
update-record-from-slot generic function 148
update-record-from-slots generic function 148
update-records function 137 , 138
update-records-from-instance generic function 148
:use debugger command 13
user defined stream 161
UTF-8 174
utilities in SQL 155
:v debugger command 11
$ (dollar) 22
$$ 22
$$$ 22
*connect-if-exists* 133
*current-process* 92
*debug-io* 17
*debug-print-length* 17
*debug-print-level* 17
*default-database-type* 132
*describe-length* 23
*describe-print-length* 22
*describe-print-level* 22
*hidden-packages* 17
*initialized-database-types* 132
*initial-processes* 92
*inspect-print-length* 23
*inspect-print-level* 23
*maximum-ordinary-windows* 88
*max-trace-indent* 39
*print-binding-frames* 18
*print-catch-frames* 18
*print-handler-frames* 18
*print-non-symbol-frames* 18
*print-open-frames* 18
*print-restart-frames* 18
*process-initial-bindings* 92
*profile-symbol-list* 82
*standard-output* 136
*symbol-alloc-gen-num* 74 , 79
*traced-arglist* 31 , 32 , 34 , 40
*trace-indent-width* 40
*trace-level* 40
*trace-output* 40
*trace-print-circle* 40
*trace-print-pretty* 41
for action lists 57
verbose backtrace 10
virtual (ordinary) slots 145
:when keyword 36
with-heavy-allocation macro 79
with-lock macro 96
without-interrupts function 93
without-interrupts macro 79
without-preemption function 93
with-transaction macro 137
with-transaction macro 139