![[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] / 43BSD / ingres / doc|
Return to toc.nr CVS log | Up to [CSRG BSD Unix] / 43BSD / ingres / doc |
1.1 root 1: .th CONTENTS INGRES
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: DELIM(QUEL) \- specify a name for a pattern of characters
106: .br
107: .bd destroy
108: .bd delim
109: groupname
110: (
111: delimitor, pattern
112: )
113: .br
114: pattern =
115: [ "[character list]" | "{character list}" ]*
116: .br
117: .s3
118: .i0
119: .in +4
120: .ti -4
121: DESTROY(QUEL) \- destroy existing relation(s)
122: .br
123: .bd destroy
124: relname { , relname }
125: .br
126: .bd destroy
127: [
128: .bd permit
129: |
130: .bd integrity
131: ] relname
132: [
133: integer { , integer }
134: |
135: .bd all
136: ]
137: .br
138: .bd destroy
139: .bd delim
140: groupname
141: .s3
142: .i0
143: .in +4
144: .ti -4
145: HELP(QUEL) \- get information about how to use \*(II, about relations in the database,
146: .br
147: .bd help
148: [
149: relname
150: ] [
151: "section"
152: ]
153: {, relname}{, "section"}
154: .br
155: .bd "help view"
156: relname {, relname}
157: .br
158: .bd "help permit"
159: relname {, relname}
160: .br
161: .bd "help integrity"
162: relname {, relname}
163: .br
164: .bd help
165: .bd delim
166: [
167: groupname
168: ]
169: {, groupname}
170: .br
171: .s3
172: .i0
173: .in +4
174: .ti -4
175: INDEX(QUEL) \- create a secondary index on an existing relation.
176: .br
177: .bd "index on"
178: relname
179: .bd is
180: indexname
181: (domain\c
182: .it 1
183: { ,domain\c
184: .it 2\c
185: })
186: .s3
187: .i0
188: .in +4
189: .ti -4
190: INTEGRITY(QUEL) \- define integrity constraints
191: .br
192: .bd "define integrity on"
193: var
194: .bd is
195: qual
196: .s3
197: .i0
198: .in +4
199: .ti -4
200: MACROS(QUEL) \- terminal monitor macro facility
201: .br
202: .s3
203: .i0
204: .in +4
205: .ti -4
206: MODIFY(QUEL) \- convert the storage structure of a relation
207: .br
208: .in +5
209: .ti -5
210: .bd modify
211: relname
212: .bd to
213: storage-structure
214: [
215: .bd on
216: key1 [ :
217: .it sortorder
218: ] [ { , key2 [ :
219: .it sortorder
220: ] } ] ]
221: [
222: .bd where
223: [
224: .bd "fillfactor ="
225: .it n
226: ] [
227: .bd ", minpages ="
228: .it n
229: ] [
230: .bd ", maxpages ="
231: .it n
232: ] [
233: .bd ", lidn ="
234: .it lidname
235: ] [
236: .i0
237: .s3
238: .i0
239: .in +4
240: .ti -4
241: MONITOR(QUEL) \- interactive terminal monitor
242: .br
243: .s3
244: .i0
245: .in +4
246: .ti -4
247: ORDERED(QUEL) \- storage structure type
248: .br
249: .s3
250: .i0
251: .in +4
252: .ti -4
253: PERMIT(QUEL) \- add permissions to a relation
254: .br
255: .bd define
256: .bd permit
257: oplist {
258: .bd on
259: |
260: .bd of
261: |
262: .bd to
263: } var [ (attlist) ]
264: .br
265: .if n .ti +5
266: .if t .ti +0.5i
267: .bd to
268: name [
269: .bd at
270: term ]
271: [
272: .bd from
273: time
274: .bd to
275: time ]
276: .br
277: .if n .ti +5
278: .if t .ti +0.5i
279: [
280: .bd on
281: day
282: .bd to
283: day ] [
284: .bd where
285: qual ]
286: .s3
287: .i0
288: .in +4
289: .ti -4
290: PRINT(QUEL) \- print relation(s)
291: .br
292: .bd print
293: relname {, relname}
294: .s3
295: .i0
296: .in +4
297: .ti -4
298: QUEL(QUEL) \- \fBQUE\fPry \fBL\fPanguage for \*(II
299: .br
300: .s3
301: .i0
302: .in +4
303: .ti -4
304: RANGE(QUEL) \- declare a variable to range over a relation
305: .br
306: .bd "range of"
307: variable
308: .bd is
309: relname
310: .s3
311: .i0
312: .in +4
313: .ti -4
314: REPLACE(QUEL) \- replace values of domains in a relation
315: .br
316: .bd replace
317: tuple_variable (target_list)
318: [\c
319: .bd where
320: qual]
321: .s3
322: .i0
323: .in +4
324: .ti -4
325: RETRIEVE(QUEL) \- retrieve tuples from a relation
326: .br
327: .bd retrieve
328: [[\c
329: .bd into\c
330: ] relname] (target_list)
331: [\c
332: .bd where
333: qual]
334: .br
335: .bd "retrieve unique"
336: (target_list) [\c
337: .bd where
338: qual]
339: .s3
340: .i0
341: .in +4
342: .ti -4
343: SAVE(QUEL) \- save a relation until a date.
344: .br
345: .bd save
346: relname
347: .bd until
348: month day year
349: .s3
350: .i0
351: .in +4
352: .ti -4
353: USE(QUEL) \- specify a group of delimitors to be used
354: .br
355: .bd use
356: groupname
357: .br
358: .bd unuse
359: groupname
360: .br
361: .s3
362: .i0
363: .in +4
364: .ti -4
365: VIEW(QUEL) \- define a virtual relation
366: .br
367: .bd define
368: .bd view
369: name (target-list) [
370: .bd where
371: qual ]
372: .s3
373: .i0
374: .in +4
375: .ti -4
376: COPYDB(UNIX) \- create batch files to copy out a data base and restore it.
377: .br
378: .bd copydb
379: [
380: .bd \-u\c
381: .it name
382: ] database full-path-name-of-directory
383: [ relation ... ]
384: .s3
385: .i0
386: .in +4
387: .ti -4
388: CREATDB(UNIX) \- create a data base
389: .br
390: .bd creatdb
391: [
392: .bd \-u\c
393: .it name
394: ] [
395: .bd \-e
396: ] [
397: .bd \-m
398: ] [
399: .bd \*(+-c
400: ] [
401: .bd \*(+-q
402: ] dbname
403: .s3
404: .i0
405: .in +4
406: .ti -4
407: DESTROYDB(UNIX) \- destroy an existing database
408: .br
409: .bd destroydb
410: [
411: .bd \-s
412: ] [
413: .bd \-m
414: ] dbname
415: .s3
416: .i0
417: .in +4
418: .ti -4
419: EQUEL(UNIX) \- Embedded QUEL interface to C
420: .br
421: .bd equel
422: [
423: .bd \-d
424: ] [
425: .bd \-f
426: ] [
427: .bd \-r
428: ] file.q ...
429: .s3
430: .i0
431: .in +4
432: .ti -4
433: HELPR(UNIX) \- get information about a database.
434: .br
435: .bd helpr
436: [
437: .bd \-u\c
438: .it name
439: ] [
440: .bd \*(+-w
441: ] database relation ...
442: .s3
443: .i0
444: .in +4
445: .ti -4
446: INGRES(UNIX) \- \*(II relational data base management system
447: .br
448: .bd ingres
449: [
450: .it flags
451: ] dbname [ process_table ]
452: .s3
453: .i0
454: .in +4
455: .ti -4
456: PRINTR(UNIX) \- print relations
457: .br
458: .bd printr
459: [
460: .it flags
461: ] database relation ...
462: .s3
463: .i0
464: .in +4
465: .ti -4
466: PURGE(UNIX) \- destroy all expired and temporary relations
467: .br
468: .bd purge
469: [
470: .bd \-f
471: ] [
472: .bd \-p
473: ] [
474: .bd \-a
475: ] [
476: .bd \-s
477: ] [
478: .bd \*(+-w
479: ] [ database ... ]
480: .s3
481: .i0
482: .in +4
483: .ti -4
484: RESTORE(UNIX) \- recover from an \*(II or \*(UU crash.
485: .br
486: .bd restore
487: [
488: .bd \-a
489: ] [
490: .bd \-s
491: ] [
492: .bd \*(+-w
493: ] [ database ... ]
494: .s3
495: .i0
496: .in +4
497: .ti -4
498: SYSMOD(UNIX) \- modify system relations to predetermined storage structures.
499: .br
500: .bd sysmod
501: [
502: .bd \-s
503: ] [
504: .bd \-w
505: ] dbname
506: [
507: .bd relation
508: ] [
509: .bd attribute
510: ] [
511: .bd indexes
512: ] [
513: .bd tree
514: ] [
515: .bd protect
516: ] [
517: .bd integrities
518: ]
519: .s3
520: .i0
521: .in +4
522: .ti -4
523: USERSETUP(UNIX) \- setup users file
524: .br
525: .bd \&.../bin/usersetup
526: [ flags [ pathname ] ]
527: .s3
528: .i0
529: .in +4
530: .ti -4
531: DAYFILE(FILES) \- \*(II login message
532: .br
533: .s3
534: .i0
535: .in +4
536: .ti -4
537: DBTMPLT(FILES) \- database template
538: .br
539: .s3
540: .i0
541: .in +4
542: .ti -4
543: ERROR(FILES) \- files with \*(II errors
544: .br
545: .s3
546: .i0
547: .in +4
548: .ti -4
549: LIBQ(FILES) \- Equel run-time support library
550: .br
551: .s3
552: .i0
553: .in +4
554: .ti -4
555: PROCTAB(FILES) \- \*(II runtime configuration information
556: .br
557: .s3
558: .i0
559: .in +4
560: .ti -4
561: STARTUP(FILES) \- \*(II startup file
562: .br
563: .s3
564: .i0
565: .in +4
566: .ti -4
567: TTYTYPE(FILES) \- \*(GQ terminal type database
568: .br
569: .s3
570: .i0
571: .in +4
572: .ti -4
573: USERS(FILES) \- \*(II user codes and parameters
574: .br
575: .s3
576: .i0
577: .in +4
578: .ti -4
579: INTRODUCTION(ERROR) \- Error messages introduction
580: .br
581: .s3
582: .i0
583: .in +4
584: .ti -4
585: PARSER(ERROR) \- Parser error message summary
586: .br
587: Error numbers 2000 \- 2999.
588: .s3
589: .i0
590: .in +4
591: .ti -4
592: QRYMOD(ERROR) \- Query Modification error message summary
593: .br
594: Error numbers 3000 \- 3999.
595: .s3
596: .i0
597: .in +4
598: .ti -4
599: OVQP(ERROR) \- One Variable Query Processor error message summary
600: .br
601: Error numbers 4000 \- 4499.
602: .s3
603: .i0
604: .in +4
605: .ti -4
606: DECOMP(ERROR) \- Decomposition error message summary
607: .br
608: Error numbers 4500 \- 4999.
609: .s3
610: .i0
611: .in +4
612: .ti -4
613: DBU(ERROR) \- Data Base Utility error message summary
614: .br
615: Error numbers 5000 \- 5999
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.