|
|
1.1 ! root 1: .th INGRES UNIX 3/14/79 ! 2: .sh NAME ! 3: ingres \- \*(II relational data base management system ! 4: .sh SYNOPSIS ! 5: .bd ingres ! 6: [ ! 7: .it flags ! 8: ] dbname [ process_table ] ! 9: .sh DESCRIPTION ! 10: This is the \*(UU command which is used to invoke \*(II. ! 11: Dbname is the name of an existing data base. ! 12: The optional flags have the following meanings ! 13: (a ``\*(+-'' means the flag may be stated ! 14: ``+\c ! 15: .it x\c ! 16: \&'' ! 17: to set option ! 18: .it x ! 19: or ``\-\c ! 20: .it x\c ! 21: \&'' ! 22: to clear option ! 23: .it x. ! 24: ``\-'' alone means that ``\-\c ! 25: .it x\c ! 26: \&'' ! 27: must be stated ! 28: to get the ! 29: .it x ! 30: function): ! 31: .s3 ! 32: .de xx ! 33: .lp +10 10 ! 34: .if t \fB\\$1\fP\fI\\$2\fP\t\c ! 35: .if n \\$1\\$2\t\c ! 36: .. ! 37: .xx \*(+-U ! 38: Enable/disable direct update ! 39: of the system relations ! 40: and secondary indicies. ! 41: You must have the 000004 bit ! 42: in the status field ! 43: of the users file ! 44: set ! 45: for this flag to be accepted. ! 46: This option is provided ! 47: for system debugging ! 48: and is strongly discouraged for normal use. ! 49: .xx \-u name ! 50: Pretend you are the user ! 51: with login name ! 52: .it name ! 53: (found in the users file). ! 54: If ! 55: .it name ! 56: is of the form ! 57: .bd :\c ! 58: .it xx, ! 59: .it xx ! 60: is the two character user code ! 61: of a user. ! 62: This may only be used ! 63: by the DBA for the database ! 64: or by the \*(II superuser. ! 65: .xx \-c N ! 66: Set the minimum field width ! 67: for printing ! 68: character domains ! 69: to ! 70: .it N. ! 71: The default is 6. ! 72: .xx \-i lN ! 73: Set integer output field width to ! 74: .it N. ! 75: .it l ! 76: may be 1, 2, or 4 for ! 77: i1's, i2's, or i4's repectively. ! 78: .xx \-f lxM.N ! 79: Set floating point output field width ! 80: to ! 81: .it M ! 82: characters ! 83: with ! 84: .it N ! 85: decimal places. ! 86: .it l ! 87: may be 4 or 8 to apply to ! 88: f4's or f8's respectively. ! 89: .it x ! 90: may be ! 91: .bd e, ! 92: .bd E, ! 93: .bd f, ! 94: .bd F, ! 95: .bd g, ! 96: .bd G, ! 97: .bd n, ! 98: or ! 99: .bd N ! 100: to specify an output format. ! 101: .bd E ! 102: is exponential form, ! 103: .bd F ! 104: is floating point form, ! 105: and ! 106: .bd G ! 107: and ! 108: .bd N ! 109: are identical to ! 110: .bd F ! 111: unless the number ! 112: is too big to fit in that field, ! 113: when it is output in ! 114: .bd E ! 115: format. ! 116: .bd G ! 117: format guarantees decimal point alignment; ! 118: .bd N ! 119: does not. ! 120: The default format for both is ! 121: .bd n10.3. ! 122: .xx \-v X ! 123: Set the column seperator ! 124: for retrieves to the terminal ! 125: and print commands ! 126: to be ! 127: .it X. ! 128: The default is vertical bar. ! 129: .xx \-r M ! 130: Set modify mode ! 131: on the ! 132: .it retrieve into ! 133: command ! 134: to ! 135: .it M. ! 136: .it M ! 137: may be ! 138: .bd isam, ! 139: .bd cisam, ! 140: .bd hash, ! 141: .bd chash, ! 142: .bd heap, ! 143: .bd cheap, ! 144: .bd heapsort, ! 145: or ! 146: .bd cheapsort, ! 147: for ISAM, ! 148: compressed ISAM, ! 149: hash table, ! 150: compressed hash table, ! 151: heap, ! 152: compressed heap, ! 153: sorted heap, ! 154: or compressed sorted heap. ! 155: The default is ``cheapsort''. ! 156: .xx \-n M ! 157: Set modify mode on the ! 158: .it index ! 159: command to ! 160: .it M. ! 161: .it M ! 162: can take the same values as the ! 163: .bd \-r ! 164: flag above. ! 165: Default is ``isam''. ! 166: .xx \*(+-a ! 167: Set/clear ! 168: the autoclear option in the terminal monitor. ! 169: It defaults to set. ! 170: .xx \*(+-b ! 171: Set/reset batch update. ! 172: Users must the 000002 bit set ! 173: in the status field of the users file ! 174: to clear this flag. ! 175: This flag is normally set. ! 176: When clear, ! 177: queries will run slightly faster, ! 178: but no recovery can take place. ! 179: Queries which update a secondary index ! 180: automatically set this flag for that query only. ! 181: .xx \*(+-d ! 182: Print/don't print the dayfile. ! 183: Normally set. ! 184: .xx \*(+-s ! 185: Print/don't print any of the monitor messages, ! 186: including prompts. ! 187: This flags is normally set. ! 188: If cleared, ! 189: it also clears the ! 190: .bd \-d ! 191: flag. ! 192: .xx \*(+-w ! 193: Wait/don't wait for the database. ! 194: If the ! 195: .bd +w ! 196: flag is present, ! 197: \*(II will wait if ! 198: certain processes are running (purge,restore, and/or sysmod) ! 199: on the given data base. ! 200: Upon completion of those processes \*(II will proceed. ! 201: If the ! 202: .bd \-w ! 203: flag is present, ! 204: a message is returned and execution stopped ! 205: if the data base is not available. ! 206: If the ! 207: .bd \*(+-w ! 208: flag is omitted ! 209: and the data base is unavailable, ! 210: the error message is returned ! 211: if \*(II is running in foreground ! 212: (more precisly if the ! 213: standard input is from a terminal), ! 214: otherwise the wait option ! 215: is invoked. ! 216: .i0 ! 217: .s3 ! 218: .it Process_table ! 219: is the pathname of a \*(UU file ! 220: which may be used to specify the run-time configuration of \*(II. ! 221: This feature is intended for use in system maintenance only, ! 222: and its unenlightened use by the user community is strongly ! 223: discouraged. ! 224: .s3 ! 225: Note: It is possible to run the monitor as a batch-processing ! 226: interface using the `<', `>' and `\*v' operators of the \*(UU shell, ! 227: provided the input file is in proper ! 228: monitor-format. ! 229: .sh EXAMPLE ! 230: .nf ! 231: ingres demo ! 232: ingres \-d demo ! 233: ingres \-s demo < batchfile ! 234: ingres \-f4g12.2 \-i13 +b \-rhash demo ! 235: .fi ! 236: .sh FILES ! 237: \&.../files/users \- valid \*(II users ! 238: .br ! 239: \&.../data/base/* \- data bases ! 240: .br ! 241: \&.../datadir/* \- for compatability with previous versions ! 242: .br ! 243: \&.../files/proctab7 \- runtime configuration file ! 244: .sh "SEE ALSO" ! 245: monitor(quel) ! 246: .sh DIAGNOSTICS ! 247: .lp +4 4 ! 248: Too many options to \*(II \- you have stated too many flags ! 249: as \*(II options. ! 250: .lp +4 4 ! 251: Bad flag format \- you have stated a flag ! 252: in a format which is not intelligible, ! 253: or a bad flag entirely. ! 254: .lp +4 4 ! 255: Too many parameters \- you have given a database name, ! 256: a process table name, ! 257: and ``something else'' ! 258: which \*(II doesn't know what to do with. ! 259: .lp +4 4 ! 260: No database name specified ! 261: .lp +4 4 ! 262: Improper database name \- the database name is not legal. ! 263: .lp +4 4 ! 264: You may not access database ! 265: .it name ! 266: \- according to the users file, ! 267: you do not have permission to enter this database. ! 268: .lp +4 4 ! 269: You are not authorized to use the ! 270: .it flag ! 271: flag \- the flag specified ! 272: requires some special authorization, ! 273: such as a bit in the users file, ! 274: which you do not have. ! 275: .lp +4 4 ! 276: Database ! 277: .it name ! 278: does not exist ! 279: .lp +4 4 ! 280: You are not a valid \*(II user \- you have not been ! 281: entered into the users file, ! 282: which means that you may not use \*(II at all. ! 283: .lp +4 4 ! 284: You may not specify this process table \- special authorization ! 285: is needed to specify process tables. ! 286: .lp +4 4 ! 287: Database temporarily unavailable \- someone else is currently ! 288: performing some operation on the database ! 289: which makes it impossible for you to even log in. ! 290: This condition should disappear shortly.
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.