2 <!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.2//EN"
3 "http://www.oasis-open.org/docbook/xml/4.2/docbookx.dtd" [
4 <!ENTITY % myents SYSTEM "entities.inc">
8 <!-- Functional Data Definition Language -->
9 <reference id="ref-fddl">
10 <title>Functional Data Definition Language (FDDL)</title>
17 <refentry id="create-table">
19 <refname>CREATE-TABLE</refname>
20 <refpurpose><!-- purpose --></refpurpose>
21 <refclass>Function</refclass>
26 <function> (CREATE-TABLE NAME DESCRIPTION &KEY (DATABASE *DEFAULT-DATABASE*) (CONSTRAINTS NIL) (TRANSACTIONS T)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
29 <title>Arguments and Values</title>
31 <!-- arguments and values -->
35 <title>Description</title>
36 <para>Creates a table called NAME, which may be a string,
37 symbol or SQL table identifier, in DATABASE which defaults to
38 *DEFAULT-DATABASE*. DESCRIPTION is a list whose elements are
39 lists containing the attribute names, types, and other
40 constraints such as not-null or primary-key for each column in
41 the table. CONSTRAINTS is a string representing an SQL table
42 constraint expression or a list of such strings. With MySQL
43 databases, if TRANSACTIONS is t an InnoDB table is created
44 which supports transactions.
48 <title>Examples</title>
54 <title>Side Effects</title>
60 <title>Affected by</title>
68 <title>Exceptional Situations</title>
70 <!-- execeptional situations -->
74 <title>See Also</title>
89 <refentry id="describe-table">
91 <refname>DESCRIBE-TABLE</refname>
92 <refpurpose><!-- purpose --></refpurpose>
93 <refclass>Function</refclass>
98 <function> (DESCRIBE-TABLE TABLE &KEY DATABASE) [generic]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
101 <title>Arguments and Values</title>
103 <!-- arguments and values -->
107 <title>Description</title>
108 <para>Describes a table, returns a list of
109 name/type for columns in table
113 <title>Examples</title>
119 <title>Side Effects</title>
121 <!-- side effects -->
125 <title>Affected by</title>
133 <title>Exceptional Situations</title>
135 <!-- execeptional situations -->
139 <title>See Also</title>
154 <refentry id="drop-table">
156 <refname>DROP-TABLE</refname>
157 <refpurpose><!-- purpose --></refpurpose>
158 <refclass>Function</refclass>
161 <title>Syntax</title>
163 <function> (DROP-TABLE NAME &KEY (IF-DOES-NOT-EXIST :ERROR) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
166 <title>Arguments and Values</title>
168 <!-- arguments and values -->
172 <title>Description</title>
173 <para>Drops the table called NAME from DATABASE which defaults
174 to *DEFAULT-DATABASE*. If the table does not exist and
175 IF-DOES-NOT-EXIST is :ignore then DROP-TABLE returns nil whereas
176 an error is signalled if IF-DOES-NOT-EXIST is :error.
180 <title>Examples</title>
186 <title>Side Effects</title>
188 <!-- side effects -->
192 <title>Affected by</title>
200 <title>Exceptional Situations</title>
202 <!-- execeptional situations -->
206 <title>See Also</title>
221 <refentry id="list-tables">
223 <refname>LIST-TABLES</refname>
224 <refpurpose><!-- purpose --></refpurpose>
225 <refclass>Function</refclass>
228 <title>Syntax</title>
230 <function> (LIST-TABLES &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
233 <title>Arguments and Values</title>
235 <!-- arguments and values -->
239 <title>Description</title>
240 <para>Returns a list of strings representing table names in DATABASE
241 which defaults to *DEFAULT-DATABASE*. OWNER is nil by default
242 which means that only tables owned by users are listed. If OWNER
243 is a string denoting a user name, only tables owned by OWNER are
244 listed. If OWNER is :all then all tables are listed.
248 <title>Examples</title>
254 <title>Side Effects</title>
256 <!-- side effects -->
260 <title>Affected by</title>
268 <title>Exceptional Situations</title>
270 <!-- execeptional situations -->
274 <title>See Also</title>
289 <refentry id="table-exists-p">
291 <refname>TABLE-EXISTS-P</refname>
292 <refpurpose><!-- purpose --></refpurpose>
293 <refclass>Function</refclass>
296 <title>Syntax</title>
298 <function> (TABLE-EXISTS-P NAME &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
301 <title>Arguments and Values</title>
303 <!-- arguments and values -->
307 <title>Description</title>
308 <para>Tests for the existence of an SQL table called NAME in
309 DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by
310 default which means that only tables owned by users are
311 examined. If OWNER is a string denoting a user name, only
312 tables owned by OWNER are examined. If OWNER is :all then all
317 <title>Examples</title>
323 <title>Side Effects</title>
325 <!-- side effects -->
329 <title>Affected by</title>
337 <title>Exceptional Situations</title>
339 <!-- execeptional situations -->
343 <title>See Also</title>
358 <refentry id="create-view">
360 <refname>CREATE-VIEW</refname>
361 <refpurpose><!-- purpose --></refpurpose>
362 <refclass>Function</refclass>
365 <title>Syntax</title>
367 <function> (CREATE-VIEW NAME &KEY AS COLUMN-LIST (WITH-CHECK-OPTION NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
370 <title>Arguments and Values</title>
372 <!-- arguments and values -->
376 <title>Description</title>
377 <para>Creates a view called NAME in DATABASE which defaults to
378 *DEFAULT-DATABASE*. The view is created using the query AS and
379 the columns of the view may be specified using the COLUMN-LIST
380 parameter. The WITH-CHECK-OPTION is nil by default but if it
381 has a non-nil value, then all insert/update commands on the
382 view are checked to ensure that the new data satisfy the query
387 <title>Examples</title>
393 <title>Side Effects</title>
395 <!-- side effects -->
399 <title>Affected by</title>
407 <title>Exceptional Situations</title>
409 <!-- execeptional situations -->
413 <title>See Also</title>
428 <refentry id="drop-view">
430 <refname>DROP-VIEW</refname>
431 <refpurpose><!-- purpose --></refpurpose>
432 <refclass>Function</refclass>
435 <title>Syntax</title>
437 <function> (DROP-VIEW NAME &KEY (IF-DOES-NOT-EXIST :ERROR) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
440 <title>Arguments and Values</title>
442 <!-- arguments and values -->
446 <title>Description</title>
447 <para>Drops the view called NAME from DATABASE
448 which defaults to *DEFAULT-DATABASE*. If the view does
449 not exist and IF-DOES-NOT-EXIST is :ignore then
450 DROP-VIEW returns nil whereas an error is signalled if
451 IF-DOES-NOT-EXIST is :error.
455 <title>Examples</title>
461 <title>Side Effects</title>
463 <!-- side effects -->
467 <title>Affected by</title>
475 <title>Exceptional Situations</title>
477 <!-- execeptional situations -->
481 <title>See Also</title>
496 <refentry id="list-views">
498 <refname>LIST-VIEWS</refname>
499 <refpurpose><!-- purpose --></refpurpose>
500 <refclass>Function</refclass>
503 <title>Syntax</title>
505 <function> (LIST-VIEWS &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
508 <title>Arguments and Values</title>
510 <!-- arguments and values -->
514 <title>Description</title>
515 <para>Returns a list of strings representing view
516 names in DATABASE which defaults to
517 *DEFAULT-DATABASE*. OWNER is nil by default which
518 means that only views owned by users are listed. If
519 OWNER is a string denoting a user name, only views
520 owned by OWNER are listed. If OWNER is :all then all
525 <title>Examples</title>
531 <title>Side Effects</title>
533 <!-- side effects -->
537 <title>Affected by</title>
545 <title>Exceptional Situations</title>
547 <!-- execeptional situations -->
551 <title>See Also</title>
566 <refentry id="view-exists-p">
568 <refname>VIEW-EXISTS-P</refname>
569 <refpurpose><!-- purpose --></refpurpose>
570 <refclass>Function</refclass>
573 <title>Syntax</title>
575 <function> (VIEW-EXISTS-P NAME &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
578 <title>Arguments and Values</title>
580 <!-- arguments and values -->
584 <title>Description</title>
585 <para>Tests for the existence of an SQL view called NAME in
586 DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by
587 default which means that only views owned by users are
588 examined. If OWNER is a string denoting a user name, only
589 views owned by OWNER are examined. If OWNER is :all then all
594 <title>Examples</title>
600 <title>Side Effects</title>
602 <!-- side effects -->
606 <title>Affected by</title>
614 <title>Exceptional Situations</title>
616 <!-- execeptional situations -->
620 <title>See Also</title>
635 <refentry id="create-index">
637 <refname>CREATE-INDEX</refname>
638 <refpurpose><!-- purpose --></refpurpose>
639 <refclass>Function</refclass>
642 <title>Syntax</title>
644 <function> (CREATE-INDEX NAME &KEY ON (UNIQUE NIL) ATTRIBUTES (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
647 <title>Arguments and Values</title>
649 <!-- arguments and values -->
653 <title>Description</title>
654 <para>Creates an index called NAME on the table specified by
655 ON in DATABASE which default to *DEFAULT-DATABASE*. The table
656 attributes to use in constructing the index NAME are specified
657 by ATTRIBUTES. The UNIQUE argument is nil by default but if it
658 has a non-nil value then the indexed attributes must have
663 <title>Examples</title>
669 <title>Side Effects</title>
671 <!-- side effects -->
675 <title>Affected by</title>
683 <title>Exceptional Situations</title>
685 <!-- execeptional situations -->
689 <title>See Also</title>
704 <refentry id="drop-index">
706 <refname>DROP-INDEX</refname>
707 <refpurpose><!-- purpose --></refpurpose>
708 <refclass>Function</refclass>
711 <title>Syntax</title>
713 <function> (DROP-INDEX NAME &KEY (IF-DOES-NOT-EXIST :ERROR) (ON NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
716 <title>Arguments and Values</title>
718 <!-- arguments and values -->
722 <title>Description</title>
723 <para>Drops the index called NAME in DATABASE which
724 defaults to *DEFAULT-DATABASE*. If the index does not
725 exist and IF-DOES-NOT-EXIST is :ignore then DROP-INDEX
726 returns nil whereas an error is signalled if
727 IF-DOES-NOT-EXIST is :error. The argument ON allows
728 the optional specification of a table to drop the
733 <title>Examples</title>
739 <title>Side Effects</title>
741 <!-- side effects -->
745 <title>Affected by</title>
753 <title>Exceptional Situations</title>
755 <!-- execeptional situations -->
759 <title>See Also</title>
774 <refentry id="index-exists-p">
776 <refname>INDEX-EXISTS-P</refname>
777 <refpurpose><!-- purpose --></refpurpose>
778 <refclass>Function</refclass>
781 <title>Syntax</title>
783 <function> (INDEX-EXISTS-P NAME &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
786 <title>Arguments and Values</title>
788 <!-- arguments and values -->
792 <title>Description</title>
793 <para>Tests for the existence of an SQL index
794 called NAME in DATABASE which defaults to
795 *DEFAULT-DATABASE*. OWNER is nil by default which
796 means that only indexes owned by users are
797 examined. If OWNER is a string denoting a user name,
798 only indexes owned by OWNER are examined. If OWNER is
799 :all then all indexes are examined.
803 <title>Examples</title>
809 <title>Side Effects</title>
811 <!-- side effects -->
815 <title>Affected by</title>
823 <title>Exceptional Situations</title>
825 <!-- execeptional situations -->
829 <title>See Also</title>
844 <refentry id="list-indexes">
846 <refname>LIST-INDEXES</refname>
847 <refpurpose><!-- purpose --></refpurpose>
848 <refclass>Function</refclass>
851 <title>Syntax</title>
853 <function> (LIST-INDEXES &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
856 <title>Arguments and Values</title>
858 <!-- arguments and values -->
862 <title>Description</title>
863 <para>Returns a list of strings representing index
864 names in DATABASE which defaults to
865 *DEFAULT-DATABASE*. OWNER is nil by default which
866 means that only indexes owned by users are listed. If
867 OWNER is a string denoting a user name, only indexes
868 owned by OWNER are listed. If OWNER is :all then all
873 <title>Examples</title>
879 <title>Side Effects</title>
881 <!-- side effects -->
885 <title>Affected by</title>
893 <title>Exceptional Situations</title>
895 <!-- execeptional situations -->
899 <title>See Also</title>
914 <refentry id="list-table-indexes">
916 <refname>LIST-TABLE-INDEXES</refname>
917 <refpurpose><!-- purpose --></refpurpose>
918 <refclass>Function</refclass>
921 <title>Syntax</title>
923 <function> (LIST-TABLE-INDEXES TABLE &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
926 <title>Arguments and Values</title>
928 <!-- arguments and values -->
932 <title>Description</title>
933 <para>Returns a list of strings representing index
934 names on the table specified by TABLE in DATABASE
935 which defaults to *DEFAULT-DATABASE*. OWNER is nil by
936 default which means that only indexes owned by users
937 are listed. If OWNER is a string denoting a user name,
938 only indexes owned by OWNER are listed. If OWNER is
939 :all then all indexes are listed.
943 <title>Examples</title>
949 <title>Side Effects</title>
951 <!-- side effects -->
955 <title>Affected by</title>
963 <title>Exceptional Situations</title>
965 <!-- execeptional situations -->
969 <title>See Also</title>
985 <refentry id="attribute-type">
987 <refname>ATTRIBUTE-TYPE</refname>
988 <refpurpose><!-- purpose --></refpurpose>
989 <refclass>Function</refclass>
992 <title>Syntax</title>
994 <function> (ATTRIBUTE-TYPE ATTRIBUTE TABLE &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
997 <title>Arguments and Values</title>
999 <!-- arguments and values -->
1003 <title>Description</title>
1004 <para>Returns a string representing the field type of the
1005 supplied attribute ATTRIBUTE in the table specified by TABLE
1006 in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil
1007 by default which means that the attribute specified by
1008 ATTRIBUTE, if it exists, must be user owned else nil is
1009 returned. If OWNER is a string denoting a user name, the
1010 attribute, if it exists, must be owned by OWNER else nil is
1011 returned, whereas if OWNER is :all then the attribute, if it
1012 exists, will be returned regardless of its owner.
1016 <title>Examples</title>
1022 <title>Side Effects</title>
1024 <!-- side effects -->
1028 <title>Affected by</title>
1031 <!-- affected by -->
1036 <title>Exceptional Situations</title>
1038 <!-- execeptional situations -->
1042 <title>See Also</title>
1050 <title>Notes</title>
1057 <refentry id="list-attribute-types">
1059 <refname>LIST-ATTRIBUTE-TYPES</refname>
1060 <refpurpose><!-- purpose --></refpurpose>
1061 <refclass>Function</refclass>
1064 <title>Syntax</title>
1066 <function> (LIST-ATTRIBUTE-TYPES TABLE &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1069 <title>Arguments and Values</title>
1071 <!-- arguments and values -->
1075 <title>Description</title>
1076 <para>Returns a list containing information about
1077 the SQL types of each of the attributes in the table
1078 specified by TABLE in DATABASE which has a default
1079 value of *DEFAULT-DATABASE*. OWNER is nil by default
1080 which means that only attributes owned by users are
1081 listed. If OWNER is a string denoting a user name,
1082 only attributes owned by OWNER are listed. If OWNER is
1083 :all then all attributes are listed. The elements of
1084 the returned list are lists where the first element is
1085 the name of the attribute, the second element is its
1086 SQL type, the third is the type precision, the fourth
1087 is the scale of the attribute and the fifth is 1 if
1088 the attribute accepts null values and otherwise
1093 <title>Examples</title>
1099 <title>Side Effects</title>
1101 <!-- side effects -->
1105 <title>Affected by</title>
1108 <!-- affected by -->
1113 <title>Exceptional Situations</title>
1115 <!-- execeptional situations -->
1119 <title>See Also</title>
1127 <title>Notes</title>
1134 <refentry id="list-attributes">
1136 <refname>LIST-ATTRIBUTES</refname>
1137 <refpurpose><!-- purpose --></refpurpose>
1138 <refclass>Function</refclass>
1141 <title>Syntax</title>
1143 <function> (LIST-ATTRIBUTES NAME &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1146 <title>Arguments and Values</title>
1148 <!-- arguments and values -->
1152 <title>Description</title>
1153 <para>Returns a list of strings representing the
1154 attributes of table NAME in DATABASE which defaults to
1155 *DEFAULT-DATABASE*. OWNER is nil by default which
1156 means that only attributes owned by users are
1157 listed. If OWNER is a string denoting a user name,
1158 only attributes owned by OWNER are listed. If OWNER is
1159 :all then all attributes are listed.
1163 <title>Examples</title>
1169 <title>Side Effects</title>
1171 <!-- side effects -->
1175 <title>Affected by</title>
1178 <!-- affected by -->
1183 <title>Exceptional Situations</title>
1185 <!-- execeptional situations -->
1189 <title>See Also</title>
1197 <title>Notes</title>
1205 <refentry id="create-sequence">
1207 <refname>CREATE-SEQUENCE</refname>
1208 <refpurpose><!-- purpose --></refpurpose>
1209 <refclass>Function</refclass>
1212 <title>Syntax</title>
1214 <function> (CREATE-SEQUENCE NAME &KEY (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1217 <title>Arguments and Values</title>
1219 <!-- arguments and values -->
1223 <title>Description</title>
1224 <para>Creates a sequence called NAME in DATABASE which
1225 defaults to *DEFAULT-DATABASE*.
1229 <title>Examples</title>
1235 <title>Side Effects</title>
1237 <!-- side effects -->
1241 <title>Affected by</title>
1244 <!-- affected by -->
1249 <title>Exceptional Situations</title>
1251 <!-- execeptional situations -->
1255 <title>See Also</title>
1263 <title>Notes</title>
1270 <refentry id="drop-sequence">
1272 <refname>DROP-SEQUENCE</refname>
1273 <refpurpose><!-- purpose --></refpurpose>
1274 <refclass>Function</refclass>
1277 <title>Syntax</title>
1279 <function> (DROP-SEQUENCE NAME &KEY (IF-DOES-NOT-EXIST :ERROR) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1282 <title>Arguments and Values</title>
1284 <!-- arguments and values -->
1288 <title>Description</title>
1289 <para>Drops the sequence called NAME from DATABASE
1290 which defaults to *DEFAULT-DATABASE*. If the sequence
1291 does not exist and IF-DOES-NOT-EXIST is :ignore then
1292 DROP-SEQUENCE returns nil whereas an error is
1293 signalled if IF-DOES-NOT-EXIST is :error.
1297 <title>Examples</title>
1303 <title>Side Effects</title>
1305 <!-- side effects -->
1309 <title>Affected by</title>
1312 <!-- affected by -->
1317 <title>Exceptional Situations</title>
1319 <!-- execeptional situations -->
1323 <title>See Also</title>
1331 <title>Notes</title>
1338 <refentry id="list-sequences">
1340 <refname>LIST-SEQUENCES</refname>
1341 <refpurpose><!-- purpose --></refpurpose>
1342 <refclass>Function</refclass>
1345 <title>Syntax</title>
1347 <function> (LIST-SEQUENCES &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1350 <title>Arguments and Values</title>
1352 <!-- arguments and values -->
1356 <title>Description</title>
1357 <para>Returns a list of strings representing
1358 sequence names in DATABASE which defaults to
1359 *DEFAULT-DATABASE*. OWNER is nil by default which
1360 means that only sequences owned by users are
1361 listed. If OWNER is a string denoting a user name,
1362 only sequences owned by OWNER are listed. If OWNER is
1363 :all then all sequences are listed.
1367 <title>Examples</title>
1373 <title>Side Effects</title>
1375 <!-- side effects -->
1379 <title>Affected by</title>
1382 <!-- affected by -->
1387 <title>Exceptional Situations</title>
1389 <!-- execeptional situations -->
1393 <title>See Also</title>
1401 <title>Notes</title>
1408 <refentry id="sequence-exists-p">
1410 <refname>SEQUENCE-EXISTS-P</refname>
1411 <refpurpose><!-- purpose --></refpurpose>
1412 <refclass>Function</refclass>
1415 <title>Syntax</title>
1417 <function> (SEQUENCE-EXISTS-P NAME &KEY (OWNER NIL) (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1420 <title>Arguments and Values</title>
1422 <!-- arguments and values -->
1426 <title>Description</title>
1427 <para>Tests for the existence of an SQL sequence called NAME in
1428 DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by
1429 default which means that only sequences owned by users are
1430 examined. If OWNER is a string denoting a user name, only
1431 sequences owned by OWNER are examined. If OWNER is :all then all
1432 sequences are examined.
1436 <title>Examples</title>
1442 <title>Side Effects</title>
1444 <!-- side effects -->
1448 <title>Affected by</title>
1451 <!-- affected by -->
1456 <title>Exceptional Situations</title>
1458 <!-- execeptional situations -->
1462 <title>See Also</title>
1470 <title>Notes</title>
1477 <refentry id="sequence-last">
1479 <refname>SEQUENCE-LAST</refname>
1480 <refpurpose><!-- purpose --></refpurpose>
1481 <refclass>Function</refclass>
1484 <title>Syntax</title>
1486 <function> (SEQUENCE-LAST NAME &KEY (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1489 <title>Arguments and Values</title>
1491 <!-- arguments and values -->
1495 <title>Description</title>
1496 <para>Return the last value of the sequence called NAME in DATABASE
1497 which defaults to *DEFAULT-DATABASE*.
1501 <title>Examples</title>
1507 <title>Side Effects</title>
1509 <!-- side effects -->
1513 <title>Affected by</title>
1516 <!-- affected by -->
1521 <title>Exceptional Situations</title>
1523 <!-- execeptional situations -->
1527 <title>See Also</title>
1535 <title>Notes</title>
1542 <refentry id="sequence-next">
1544 <refname>SEQUENCE-NEXT</refname>
1545 <refpurpose><!-- purpose --></refpurpose>
1546 <refclass>Function</refclass>
1549 <title>Syntax</title>
1551 <function> (SEQUENCE-NEXT NAME &KEY (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1554 <title>Arguments and Values</title>
1556 <!-- arguments and values -->
1560 <title>Description</title>
1561 <para>Return the next value in the sequence called NAME in DATABASE
1562 which defaults to *DEFAULT-DATABASE*.
1566 <title>Examples</title>
1572 <title>Side Effects</title>
1574 <!-- side effects -->
1578 <title>Affected by</title>
1581 <!-- affected by -->
1586 <title>Exceptional Situations</title>
1588 <!-- execeptional situations -->
1592 <title>See Also</title>
1600 <title>Notes</title>
1607 <refentry id="set-sequence-position">
1609 <refname>SET-SEQUENCE-POSITION</refname>
1610 <refpurpose><!-- purpose --></refpurpose>
1611 <refclass>Function</refclass>
1614 <title>Syntax</title>
1616 <function> (SET-SEQUENCE-POSITION NAME POSITION &KEY (DATABASE *DEFAULT-DATABASE*)) [function]</function> => <returnvalue><!-- result --></returnvalue></synopsis>
1619 <title>Arguments and Values</title>
1621 <!-- arguments and values -->
1625 <title>Description</title>
1626 <para>Explicitly set the the position of the sequence called NAME in
1627 DATABASE, which defaults to *DEFAULT-DATABSE*, to POSITION.
1631 <title>Examples</title>
1637 <title>Side Effects</title>
1639 <!-- side effects -->
1643 <title>Affected by</title>
1646 <!-- affected by -->
1651 <title>Exceptional Situations</title>
1653 <!-- execeptional situations -->
1657 <title>See Also</title>
1665 <title>Notes</title>