![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to toc.nr CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [CSRG BSD Unix] / 42BSD / ingres / doc|
Return to toc.nr CVS log | Up to [CSRG BSD Unix] / 42BSD / ingres / doc |
1.1 root 1: .th "TABLE OF CONTENTS" INGRES 3/23/79
2: .s3
3: .i0
4: .in +4
5: .ti -4
6: APPEND(QUEL) \- append tuples to a relation
7: .br
8: .bd append
9: [\c
10: .bd to\c
11: ] relname (target_list) [\c
12: .bd where
13: qual\c
14: ]
15: .s3
16: .i0
17: .in +4
18: .ti -4
19: COPY(QUEL) \- copy data into/from a relation from/into a \*(UU file.
20: .br
21: .bd copy
22: relname
23: (domname = format {, domname = format })
24: .br
25: .ti +10
26: direction "filename"
27: .s3
28: .i0
29: .in +4
30: .ti -4
31: CREATE(QUEL) \- create a new relation
32: .br
33: .bd create
34: relname (domname\c
35: .it 1
36: = format {, domname\c
37: .it 2
38: = format })
39: .s3
40: .i0
41: .in +4
42: .ti -4
43: DEFINE(QUEL) \- define subschema
44: .br
45: .in +5
46: .ti -5
47: .bd define
48: .bd view
49: name (target list) [
50: .bd where
51: qual ]
52: .ti -5
53: .bd "define permit"
54: oplist
55: {
56: .bd on
57: |
58: .bd of
59: |
60: .bd to
61: }
62: var
63: [ (attlist) ]
64: .bd to
65: name
66: [
67: .bd at
68: term ]
69: [
70: .bd from
71: time
72: .bd to
73: time ]
74: [
75: .bd on
76: day
77: .bd to
78: day ] [
79: .bd where
80: qual ]
81: .ti -5
82: .bd define
83: .bd integrity
84: .bd on
85: var
86: .bd is
87: qual
88: .i0
89: .s3
90: .i0
91: .in +4
92: .ti -4
93: DELETE(QUEL) \- delete tuples from a relation
94: .br
95: .bd delete
96: tuple_variable
97: [\c
98: .bd where
99: qual\c
100: ]
101: .s3
102: .i0
103: .in +4
104: .ti -4
105: DESTROY(QUEL) \- destroy existing relation(s)
106: .br
107: .bd destroy
108: relname {, relname}
109: .br
110: .bd destroy
111: [\c
112: .bd permit
113: |
114: .bd integrity\c
115: ] relname
116: [\c
117: integer {, integer}\c
118: |
119: .bd all\c
120: ]
121: .s3
122: .i0
123: .in +4
124: .ti -4
125: HELP(QUEL) \- get information about how to use \*(II or about relations in the database.
126: .br
127: .bd help
128: [\c
129: relname\c
130: ] [\c
131: "section"\c
132: ]
133: {, relname}{, "section"}
134: .br
135: .bd "help view"
136: relname {, relname}
137: .br
138: .bd "help permit"
139: relname {, relname}
140: .br
141: .bd "help integrity"
142: relname {, relname}
143: .s3
144: .i0
145: .in +4
146: .ti -4
147: INDEX(QUEL) \- create a secondary index on an existing relation.
148: .br
149: .bd "index on"
150: relname
151: .bd is
152: indexname
153: (domain\c
154: .it 1
155: { ,domain\c
156: .it 2\c
157: })
158: .s3
159: .i0
160: .in +4
161: .ti -4
162: INTEGRITY(QUEL) \- define integrity constraints
163: .br
164: .bd "define integrity on"
165: var
166: .bd is
167: qual
168: .s3
169: .i0
170: .in +4
171: .ti -4
172: MACROS(QUEL) \- terminal monitor macro facility
173: .br
174: .s3
175: .i0
176: .in +4
177: .ti -4
178: MODIFY(QUEL) \- convert the storage structure of a relation
179: .br
180: .in +5
181: .ti -5
182: .bd modify
183: relname
184: .bd to
185: storage-structure
186: [
187: .bd on
188: key1 [ :
189: .it sortorder
190: ] [ { , key2 [ :
191: .it sortorder
192: ] } ] ]
193: [
194: .bd where
195: [
196: .bd "fillfactor ="
197: .it n
198: ] [
199: .bd ", minpages ="
200: .it n
201: ] [
202: .bd ", maxpages ="
203: .it n
204: ] ]
205: .i0
206: .s3
207: .i0
208: .in +4
209: .ti -4
210: MONITOR(QUEL) \- interactive terminal monitor
211: .br
212: .s3
213: .i0
214: .in +4
215: .ti -4
216: PERMIT(QUEL) \- add permissions to a relation
217: .br
218: .bd define
219: .bd permit
220: oplist {
221: .bd on
222: |
223: .bd of
224: |
225: .bd to
226: } var [ (attlist) ]
227: .br
228: .if n .ti +5
229: .if t .ti +0.5i
230: .bd to
231: name [
232: .bd at
233: term ]
234: [
235: .bd from
236: time
237: .bd to
238: time ]
239: .br
240: .if n .ti +5
241: .if t .ti +0.5i
242: [
243: .bd on
244: day
245: .bd to
246: day ] [
247: .bd where
248: qual ]
249: .s3
250: .i0
251: .in +4
252: .ti -4
253: PRINT(QUEL) \- print relation(s)
254: .br
255: .bd print
256: relname {, relname}
257: .s3
258: .i0
259: .in +4
260: .ti -4
261: QUEL(QUEL) \- \fBQUE\fPry \fBL\fPanguage for \*(II
262: .br
263: .s3
264: .i0
265: .in +4
266: .ti -4
267: RANGE(QUEL) \- declare a variable to range over a relation
268: .br
269: .bd "range of"
270: variable
271: .bd is
272: relname
273: .s3
274: .i0
275: .in +4
276: .ti -4
277: REPLACE(QUEL) \- replace values of domains in a relation
278: .br
279: .bd replace
280: tuple_variable (target_list)
281: [\c
282: .bd where
283: qual]
284: .s3
285: .i0
286: .in +4
287: .ti -4
288: RETRIEVE(QUEL) \- retrieve tuples from a relation
289: .br
290: .bd retrieve
291: [[\c
292: .bd into\c
293: ] relname] (target_list)
294: [\c
295: .bd where
296: qual]
297: .br
298: .bd "retrieve unique"
299: (target_list) [\c
300: .bd where
301: qual]
302: .s3
303: .i0
304: .in +4
305: .ti -4
306: SAVE(QUEL) \- save a relation until a date.
307: .br
308: .bd save
309: relname
310: .bd until
311: month day year
312: .s3
313: .i0
314: .in +4
315: .ti -4
316: VIEW(QUEL) \- define a virtual relation
317: .br
318: .bd define
319: .bd view
320: name (target-list) [
321: .bd where
322: qual ]
323: .s3
324: .i0
325: .in +4
326: .ti -4
327: COPYDB(UNIX) \- create batch files to copy out a data base and restore it.
328: .br
329: .bd copydb
330: [
331: .bd \-u\c
332: .it name
333: ] database full-path-name-of-directory
334: [ relation ... ]
335: .s3
336: .i0
337: .in +4
338: .ti -4
339: CREATDB(UNIX) \- create a data base
340: .br
341: .bd creatdb
342: [
343: .bd \-u\c
344: .it name
345: ] [
346: .bd \-e
347: ] [
348: .bd \-m
349: ] [
350: .bd \*(+-c
351: ] [
352: .bd \*(+-q
353: ] dbname
354: .s3
355: .i0
356: .in +4
357: .ti -4
358: DESTROYDB(UNIX) \- destroy an existing database
359: .br
360: .bd destroydb
361: [
362: .bd \-s
363: ] [
364: .bd \-m
365: ] dbname
366: .s3
367: .i0
368: .in +4
369: .ti -4
370: EQUEL(UNIX) \- Embedded QUEL interface to C
371: .br
372: .bd equel
373: [
374: .bd \-d
375: ] [
376: .bd \-f
377: ] [
378: .bd \-r
379: ] file.q ...
380: .s3
381: .i0
382: .in +4
383: .ti -4
384: HELPR(UNIX) \- get information about a database.
385: .br
386: .bd helpr
387: [
388: .bd \-u\c
389: .it name
390: ] [
391: .bd \*(+-w
392: ] database relation ...
393: .s3
394: .i0
395: .in +4
396: .ti -4
397: INGRES(UNIX) \- \*(II relational data base management system
398: .br
399: .bd ingres
400: [
401: .it flags
402: ] dbname [ process_table ]
403: .s3
404: .i0
405: .in +4
406: .ti -4
407: PRINTR(UNIX) \- print relations
408: .br
409: .bd printr
410: [
411: .it flags
412: ] database relation ...
413: .s3
414: .i0
415: .in +4
416: .ti -4
417: PURGE(UNIX) \- destroy all expired and temporary relations
418: .br
419: .bd purge
420: [
421: .bd \-f
422: ] [
423: .bd \-p
424: ] [
425: .bd \-a
426: ] [
427: .bd \-s
428: ] [
429: .bd \*(+-w
430: ] [ database ... ]
431: .s3
432: .i0
433: .in +4
434: .ti -4
435: RESTORE(UNIX) \- recover from an \*(II or \*(UU crash.
436: .br
437: .bd restore
438: [
439: .bd \-a
440: ] [
441: .bd \-s
442: ] [
443: .bd \*(+-w
444: ] [ database ... ]
445: .s3
446: .i0
447: .in +4
448: .ti -4
449: SYSMOD(UNIX) \- modify system relations to predetermined storage structures.
450: .br
451: .bd sysmod
452: [
453: .bd \-s
454: ] [
455: .bd \-w
456: ] dbname
457: [
458: .bd relation
459: ] [
460: .bd attribute
461: ] [
462: .bd indexes
463: ] [
464: .bd tree
465: ] [
466: .bd protect
467: ] [
468: .bd integrities
469: ]
470: .s3
471: .i0
472: .in +4
473: .ti -4
474: USERSETUP(UNIX) \- setup users file
475: .br
476: .bd \&.../bin/usersetup
477: [ pathname ]
478: .s3
479: .i0
480: .in +4
481: .ti -4
482: DAYFILE(FILES) \- \*(II login message
483: .br
484: .s3
485: .i0
486: .in +4
487: .ti -4
488: DBTMPLT(FILES) \- database template
489: .br
490: .s3
491: .i0
492: .in +4
493: .ti -4
494: ERROR(FILES) \- files with \*(II errors
495: .br
496: .s3
497: .i0
498: .in +4
499: .ti -4
500: LIBQ(FILES) \- Equel run-time support library
501: .br
502: .s3
503: .i0
504: .in +4
505: .ti -4
506: PROCTAB(FILES) \- \*(II runtime configuration information
507: .br
508: .s3
509: .i0
510: .in +4
511: .ti -4
512: STARTUP(FILES) \- \*(II startup file
513: .br
514: .s3
515: .i0
516: .in +4
517: .ti -4
518: USERS(FILES) \- \*(II user codes and parameters
519: .br
520: .s3
521: .i0
522: .in +4
523: .ti -4
524: INTRODUCTION(ERROR) \- Error messages introduction
525: .br
526: .s3
527: .i0
528: .in +4
529: .ti -4
530: EQUEL(ERROR) \- \s-2EQUEL\s0 error message summary
531: .br
532: Error numbers 1000 \- 1999.
533: .s3
534: .i0
535: .in +4
536: .ti -4
537: PARSER(ERROR) \- Parser error message summary
538: .br
539: Error numbers 2000 \- 2999.
540: .s3
541: .i0
542: .in +4
543: .ti -4
544: QRYMOD(ERROR) \- Query Modification error message summary
545: .br
546: Error numbers 3000 \- 3999.
547: .s3
548: .i0
549: .in +4
550: .ti -4
551: OVQP(ERROR) \- One Variable Query Processor error message summary
552: .br
553: Error numbers 4000 \- 4499.
554: .s3
555: .i0
556: .in +4
557: .ti -4
558: DECOMP(ERROR) \- Decomposition error message summary
559: .br
560: Error numbers 4500 \- 4999.
561: .s3
562: .i0
563: .in +4
564: .ti -4
565: DBU(ERROR) \- Data Base Utility error message summary
566: .br
567: Error numbers 5000 \- 5999
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.