IT Universe documentation - SYS

SYS

Id	Description	Syntax	E/W
( ... )	Use in RetrieVe sentences to group selection criteria. Parentheses alter the order of the evaluation.
*	The comment does not affect the operation of the sentences in the paragraph. A comment line must contain at least one space character after the asterisk ( * ) to distinguish it from a cataloged BASIC program name.	* [comment]	E
-CANCEL	Use with the SPOOL command to delete a print job from the printer queue.
-L	Synonym for -LIST.
-LIST	Use with the BASIC, FORMAT, and FANCY.FORMAT commands to generate a listing of the program.
-SPOOL	Use with the BASIC command to generate a listing of the program, and spool it directly to the printer rather than to a file.
-XREF	Use with the BASIC command to generate a cross-reference table of statement labels and variable names used in the program.
.A	The .A command does not execute the newly created sentence. It just changes the sentence in the sentence stack. You can execute the changed sentence, or you can save it using sentence stack commands.	.A [n] text	E
.C	The .C command does not execute the newly created sentence. You execute or save the changed sentence using sentence stack commands.	.C[n] /string1/string2[/[G]]	E
.D	Before deleting a stored sentence or paragraph, you can examine the contents of the sentence or paragraph using the .L (List) command.	.D[n \| name]	E
.I	Use .I (Insert) to insert a new sentence into the sentence stack. This feature is useful for building paragraphs because you can add a sentence to those already in the sentence stack.	.I[n] text	E
.L	If you do not specify n, sentences 1 through 20 are displayed. If you choose a number greater than 22, the first 23 sentences are displayed followed by the message:	.L[n \| name]	E
.R	When you recall a sentence, you copy it to sentence 1 in the sentence stack. When you recall a paragraph, you copy the sentences in the paragraph to the first n sentences in the sentence stack, where n is the number of sentences in the paragraph.	.R[n \| name]	E
.S	You can specify start and end either in ascending or in descending order. The .S command always saves a range of sentences in descending order from oldest to newest.	.S name [start [end]]	E
.U	Use .U (Uppercase) to convert a sentence from lowercase to uppercase.	.U [n]	E
.X	When you execute a sentence other than sentence 1, the command processor first copies it to sentence 1 and then executes it.	.X[n]	E
<<...>>	Once a value has been entered for a particular prompt, the prompt continues to have that value until a CLEARPROMPTS command is executed if control option A is not specified. CLEARPROMPTS clears all of the values that have been entered for in-line prompts.	<< [control,]... text [, option] >>	E
?	If you are typing a sentence and you notice you made a typing mistake before completing the sentence, you can save the sentence in the stack without executing it. Because the sentence has been saved in the sentence stack, you do not have to retype the entire sentence. Instead, you can correct the mistake using .C and then execute the sentence.	sentence.with.mistake?	E
@ASSOC_ROW	Use as a column name in the SQL SELECT, INSERT, UPDATE, and DELETE statements to reference an association's keys. @ASSOC_ROW generates a sequence of unique numbers which, when used with the primary key of the base table, produces a set of jointly unique association row keys. Use @ASSOC_ROW when the association does not have explicitly defined association keys. @ASSOC_ROW acts as a virtual column name when you dynamically normalize an NF2 table or file.
A	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
ABORT	Use ABORT in a paragraph or in a BASIC EXECUTE statement to abort the current process. This is useful in conditional clauses to stop a process when certain conditions exist.	ABORT	E
ABORT.LOGIN	Use ABORT.LOGIN to abort the current process and rerun the LOGIN paragraph. This reestablishes the defaults that are set up in the LOGIN paragraph.	ABORT.LOGIN	E
ACCOUNT.FILE.STATS	ACCOUNT.FILE.STATS writes records to the STAT.FILE file. Each file receives a unique key in the following format:	ACCOUNT.FILE.STATS [filenames \| ALL \| *] [LOCAL]
ACTLIST	ACTLIST activates the data file, the file dictionary, and any secondary indexes for each file in the select list. ACTLIST cannot activate a type 1 or a type 19 file. It displays an error message for each type 1 or type 19 file in the select list.	ACTLIST listname	E
ADDING	Use with the DEFINE.DF command to add a part file to a distributed file.
AFTER	Synonym for GT.
ALL	Use in a COPY sentence to copy all records in the source file. For example, to copy all records from FILE1 to FILE2, enter the following:
ALL.MATCH	Use with the SEARCH command to select only records containing all the specified strings.
ANALYZE.FILE	For each dynamic file specified, a report lists the hashing algorithm, the modulo, the minimum modulus, the large record size, the group size, the split load, the merge load, the current load, the number of secondary indexes, and the size of the file.	ANALYZE.FILE [DICT] [filename[,filename]...] [STATISTICS \| STATS] [NO.PAGE] [LPTR [n]]	E
ANALYZE.SHM	The disk shared memory segment is a global work area that must be present for UniVerse to work. The printer shared memory segment is local to each user.	ANALYZE.SHM {options}	E
AND	Logical operator AND used to join selection expressions, WHEN clauses, and IF statements. For example:
ANY	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
APPEND	Use with the DIVERT.OUT command to append output from diversion to the end of an existing record.
ARE	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
AS	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command as a synonym for BANNER.
ASSIGN	If you do not use the -WAIT option and the device you requested is assigned to another user, a message like the following appears:	ASSIGN device TO MTU n [MAP mapname] [-WAIT] [BLK size] ASSIGN device TO LPTR n [-WAIT]	E
ASSOC	Use as a field qualifier in a RetrieVe sentence or SQL SELECT statement to associate a field expression with an existing association of multivalued fields. Its syntax is as follows:
ASSOC.ROW	Synonym for @ASSOC_ROW.
ASSOC.WITH	Use as a field qualifier in a RetrieVe sentence or SQL SELECT statement to associate a field expression with another field expression that is multivalued. Its syntax is as follows:
ASSOCIATED	Synonym for ASSOC.WITH.
ASSOCIATIONS	Synonym for ASSOC.
AT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to route jobs to a system printer specified as its argument.
AUTOLOGOUT	Use AUTOLOGOUT to enable or disable automatic logout. With AUTOLOGOUT enabled, UniVerse logs you out automatically if you have not pressed a key within a specified time.	AUTOLOGOUT [time]	E
AUX.PORT	Use in a RetrieVe sentence or SQL SELECT statement to send results to a printer connected to the terminal's auxiliary port; results are also displayed on the screen.
AUXMAP	In NLS mode, use with the SET.TERM.TYPE command to set a map for an auxiliary printer attached to the terminal.
AVAIL	Use AVAIL to display statistics about available disk space, including the number of bytes used, the number of bytes still available, and the percent of total disk space used.	AVAIL [device]	E
AVERAGE	Synonym for AVG.
AVG	Use in a RetrieVe sentence or SQL SELECT statement to calculate the average for a single-valued or multivalued numeric field of the selected records and list it at the bottom of a report. Its syntax is as follows:
BANNER	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify a name on the banner page. Its syntax is as follows:
BASIC	The object code produced by the compiler is saved in a file with the source filename and the suffix .O (for example, BP.O). The record ID of the object code is the same as the record ID of the source code.	BASIC filename [programs \| *] [options]	E
BEFORE	Synonym for LT.
BELL	Use BELL to specify whether the terminal bell sounds when UniVerse generates warning messages.	BELL {ON \| OFF}
BLK	Use with the ASSIGN, T.ATT, T.DUMP, REFORMAT, and SREFORMAT commands to define the block size of a tape record. The default block size is 8192 bytes, the maximum size. When you restore tape records to disk using T.LOAD, the block size is displayed.
BLOCK.PRINT	To use BLOCK.PRINT, your account must have a VOC file entry pointing to the BLTRS file in the uniVerse account. BLTRS contains each character that can be listed in block format. If the character is not in BLTRS, BLOCK.PRINT cannot print it. To list the characters you can print in block format, enter SORT BLTRS at the system prompt.	BLOCK.PRINT string [string...]	E
BLOCK.TERM	To use BLOCK.TERM, your account must have a VOC file entry pointing to the BLTRS file in the uniVerse account. BLTRS contains each character that can be listed in block format. If the character is not in BLTRS, BLOCK.TERM cannot display it. To list the characters you can display in block format, enter SORT BLTRS at the system prompt.	BLOCK.TERM string [string...]	E
BREAK	Use with the MASTER command to enable the Break key.
BREAK ON	UniVerse SQL synonym for BREAK.ON.
BREAK SUPPRESS	UniVerse SQL synonym for BREAK.SUP.
BREAK-ON	Synonym for BREAK.ON.
BREAK.ON	Use with RetrieVe commands and the SQL SELECT statement to specify which field to use to create breaks in a report. A break occurs when the column values change. The break is indicated by asterisks or by user-specified text. BREAK.ON expressions are often used with the keywords AVG, CALC, PCT, and TOTAL to perform the specified action and display the results when the values change.
BREAK.SUP	Use with RetrieVe commands and the SQL SELECT statement to specify which field to use to create breaks in a report. BREAK.SUP does the same thing as BREAK.ON, except it does not display the row of stars or a column containing the values in the field specified.
BRIEF	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to suppress display of SETPTR settings for approval.
BUILD.INDEX	If you do not specify either indexes or ALL, you are prompted to enter the name of an index.	BUILD.INDEX [DICT] [filename] [indexes \| ALL]	E
BY	Use in a sort expression to sort selected records. Records are sorted in ascending order of values in the specified field. Its syntax is as follows:
BY-DSND	Synonym for BY.DSND.
BY-EXP	Synonym for BY.EXP.
BY-EXP-DSND	Synonym for BY.EXP.DSND.
BY.DSND	Use in a sort expression to sort selected records. Records are sorted in descending order of values in the specified field. Its syntax is as follows:
BY.EXP	Use in a sort expression to explode and sort data in multivalued fields. The exploded multivalues are sorted in ascending order. Its syntax is as follows:
BY.EXP.DSND	Use in a sort expression to explode and sort data in multivalued fields. The exploded multivalues are sorted in ascending order. Its syntax is as follows:
CALC	Use in a RetrieVe sentence or SQL SELECT statement to specify total calculations in I-descriptors. CALC can be used with breakpointing to produce subtotals. Its syntax is as follows:
CALCULATE	Synonym for CALC.
CANCEL	Use with the DEFINE.DF command to remove the part file number and algorithm from a part file.
CATALOG	If you use CATALOG with no options, you are prompted to enter the filename, the catalog name, and the program name. If you press Return at any of the prompts, CATALOG terminates without cataloging anything.	CATALOG [filename] [[catalog.name] program.name \| *] [options]	E
CD	CD stores the compiled object code and the time and date of the compilation in the I-descriptor record. If you change the I-descriptor expression, the Editor flags the I-descriptor and displays a reminder that the I-descriptor must be recompiled when you file the record. It invalidates the existing descriptor as well. RetrieVe compiles this I-descriptor before using it in a sentence.	CD filename [descriptors]	E
CHAP	Use CHAP to control execution priority.	CHAP [UP \| DOWN]
CHDIR	If the account is not set up for UniVerse, the following message appears:	CHDIR pathname	E
CHECK.SUM	The CHECK.SUM command displays output in the following format:	CHECK.SUM [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [field] [report.qualifiers]	E
CLEAN.ACCOUNT	CLEAN.ACCOUNT looks in your account for specific system files and asks your permission to delete or clear the contents of these files. CLEAN.ACCOUNT also examines all the files in your account to verify that they are valid UniVerse files.	CLEAN.ACCOUNT	E
CLEAR.FILE	If you use a select list with CLEAR.FILE, the files named in the select list must be defined in the VOC file. If filename specifies a VOC entry that is a file synonym or a remote file entry, CLEAR.FILE clears the file specified in that VOC entry.	CLEAR.FILE [DICT \| DATA] [filename]	E
CLEAR.LOCKS	Before using CLEAR.LOCKS, be sure you know how the locks have been set for your installation. Consult your UniVerse Administrator if you are not sure. If you release a lock that should be retained, you might damage the data. CLEAR.LOCKS does not check the current execution status of a lock. It verifies only that your task set the lock.	CLEAR.LOCKS [n]	E
CLEARCOMMON	The BASIC COMMON statement assigns common variables.	CLEARCOMMON
CLEARDATA	Use CLEARDATA when a data stack exists and a BASIC program requests input from the terminal. CLEARDATA is useful for clearing data when an error occurs in processing DATA statements.	CLEARDATA	E
CLEARPROMPTS	Once a value has been entered at an in-line prompt, the prompt retains that value until a CLEARPROMPTS command is executed, unless the in-line prompt control option A is specified. CLEARPROMPTS clears all values entered for in-line prompts.	CLEARPROMPTS	E
CLEARSELECT	Use CLEARSELECT when you have created an active select list and you decide you do not want to use the list. You can clear an entire select list or the unused remainder of an active select list.	CLEARSELECT [list# \| ALL]	E
CLR	Use CLR to clear the screen and return the cursor to the home position. CLR is a synonym for the CS command.	CLR
CNAME	When you change a filename or record ID name, a message confirms the change.	CNAME old.filename {TO \| ,} new.filename CNAME [DICT] filename old {TO \| ,} new CNAME [DICT] filename old, new [old2, new2]...	E
COL-HDR-SUPP	Synonym for COL.HDR.SUPP.
COL-SUPP	Synonym for COL.SUP.
COL.HDG	Use as a field qualifier in a RetrieVe sentence or SQL SELECT statement to define a column heading for the field or EVAL expression it qualifies. Its syntax is as follows:
COL.HDR.SUPP	Use in a RetrieVe sentence or SQL SELECT statement to suppress printing of the default page heading (page, time, and date), and column headings. Used in LIST.LABEL and SORT.LABEL statements, COL.HDR.SUPP produces a continuous form report without page breaks. The COL.HDR.SUPP phrase is a combination of the COL.SUP and HDR.SUP keywords.
COL.SPACES	Synonym for COL.SPCS.
COL.SPCS	Use in a RetrieVe sentence or SQL SELECT statement to change the default spacing between columns in the display. The default varies from one through four depending on the total width of the fields being displayed and the length of the field names. Each space is the width of a single screen column.
COL.SUP	Use in a RetrieVe sentence or SQL SELECT statement to suppress the column headings, which are the display names that normally display at the top of the column. For example:
COLLATE	In NLS mode, use with the CREATE.INDEX command to specify the name of the locale whose Collate convention you want to associate with an index. Use with GET.LOCALE and SET.LOCALE to specify the category value.
COLUMN SPACES	UniVerse SQL synonym for COL.SPCS.
COMO	COMO is short for command output.	COMO [action]	E
COMPILE.DICT	COMPILE.DICT stores the compiled object code and the time and date of the compilation in the I-descriptor record. If you change the I-descriptor expression, the Editor flags the I- descriptor and displays a reminder that the I-descriptor must be recompiled when you file the record. It invalidates the existing descriptor as well. RetrieVe compiles this I- descriptor before using it in a sentence. Because the I- descriptors in a dictionary are often related, they should always be compiled together.	COMPILE.DICT filename [descriptors]	E
COMPILE.DICTS	COMPILE.DICTS runs the COMPILE.DICT command on every file in the account. The output of COMPILE.DICTS is also saved in a record of &COMO& called COMPILE.DICTS. For more information about the &COMO& file, see the COMO command.	COMPILE.DICTS
COMPLETE	Use with the CATALOG command to specify that the VOC entry for a locally cataloged program is to contain the program's absolute pathname. The VOC entry normally contains the location of the program relative to the user's account.
CONCURRENT	Use in a RESIZE command to permit other users to access the file while it is being resized. To let other users use the file PAYABLES while it is being resized, enter the following:
CONFIG	Use CONFIG to display the currently active authorization parameters and current configurable parameter values.	CONFIG [ALL \| BRIEF \| DATA]	E
CONFIGURE.FILE	Be careful when changing dynamic file parameters. The default parameters are set so most dynamic files work correctly. For some files, you can increase efficiency by changing the default file parameters.	CONFIGURE.FILE [DICT] [filename] [parameter [value]... \| DEFAULTS]	E
CONNECT	The CONNECT command lets you submit SQL statements to a specified data source and receive results at your terminal.	CONNECT data.source [option setting [option setting...]]
CONV	Use as a field qualifier in a RetrieVe sentence or SQL statement to define a conversion for the field name or EVAL expression it qualifies. Its syntax is as follows:
CONVERSION	Synonym for CONV.
CONVERT.ACCOUNT	CONVERT.ACCOUNT invokes the account conversion menu. The menu comprises two submenus, one for converting Pick and Prime file dictionaries (including the VOC file), the other for converting BASIC programs. The dictionary conversion menu also has an option for converting REALITY procs to a proc format compatible with UniVerse.	CONVERT.ACCOUNT
CONVERT.SQL	CONVERT.SQL analyzes the file's dictionary and generates an intermediate file called filename_SQLDEF, known as the SQLDEF file. The SQLDEF file contains column and association definitions based on the contents of the file dictionary. The information in the SQLDEF file is used to form a CREATE TABLE statement which is executed to convert the file to a table. This process adds a SICA (security and integrity constraints area) to the file's header, adds SQL datatype codes to the file's dictionary, and updates the SQL catalog with information about this new table.	CONVERT.SQL [filename [action [options]]]	EN
CONVERT.VOC	When you invoke CONVERT.VOC, you are prompted to select the name of the computer or operating system from which the original Master Dictionary or VOC file came:	CONVERT.VOC
COPIES	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to print the number of copies specified in its argument of each report with a single banner page.
COPY	You can copy records individually, in groups, or all at once. You can also copy records within the source file by using different target record IDs.	COPY FROM [DICT] source.file [TO [DICT] target.file] [rec1 [, new.rec1] [rec2 [, new.rec2]]... \| ALL] [options]	E
COPY.LIST	COPY.LIST is a proc that invokes the COPY processor.	COPY.LIST [filename] [listname]	E
CORE	Use CORE to display statistics about your current memory usage. The statistics include the number of blocks, number of bytes, and average block size for free, used, and total memory.	CORE	E
COUNT	If you enter COUNT with no options, it counts and reports the total number of records in the file.	COUNT [DICT \| USING [DICT] dictname] filename [FROM n] [selection]	E
COUNT.SUP	Use in a RetrieVe sentence or SQL SELECT statement to suppress the message that lists the number of records processed.
CP	Use CP to print records on the system printer. CP prints only to print channel 0.	CP [DICT] filename [records \| *] [options]	E
CREATE.FILE	CREATE.FILE creates or modifies the file definition in the VOC file. In addition, CREATE.FILE allocates space for the data file and the file dictionary and creates a default field definition in the dictionary for record IDs.	CREATE.FILE [DICT \| DATA] [filename [, datafile]] [type] [modulo] [separation] [parameter [value]...] [description]	EN
CREATE.INDEX	Setting up a secondary index is a two-step process. First you create the index with CREATE.INDEX. Then you build the index with BUILD.INDEX. You must use the BUILD.INDEX command to build the initial index, even if the file you want to index contains no records. If the indexed file contains records when you create the index, a warning reminds you to build the index.	CREATE.INDEX [DICT \| USING [DICT] dictname] [filename] [AT account] [fields] [NO.NULLS] [COLLATE {locale.name \| OFF}]	EN
CREATE.LDIR	The log directory contains the log files where warmstart and data transactions are logged. Before you can use transaction logging, you must create a log directory and a set of log files to store logged updates to recoverable files. If the log files in the log directory fill up and you need more space, you can create another log directory for them on another partition.	CREATE.LDIR pathname	E
CREATE.LFILE	CREATE.LFILE creates log files with names in the following format:	CREATE.LFILE size files	E
CRT	Use with the LIST.DIFF, LIST.INTER, or LIST.UNION commands to copy data to the terminal.
CS	Use CS to clear the screen and return the cursor to the home position. CS is a synonym for the CLR command.	CS
CSH	Once you invoke a C shell, you can execute any UNIX command. You can also give CSH an argument to execute a single command or a shell script without exiting UniVerse. To return to the UniVerse prompt, enter exit or press Ctrl-D.	CSH [-c "command" \| script]	E
CT	Use CT to display records on the terminal.	CT [DICT] filename [records \| *] [options]	E
DATA	Use with a filename to specify the data file. Specify DATA immediately before the filename. To delete only the data file OVERDUE but retain its dictionary, enter the following:
DATE	DATE uses a 12-hour clock to display the time.	DATE	E
DATE.FORMAT	In international format, the day of the month appears first. In United States format, the month appears first.	DATE.FORMAT [ON \| OFF \| conversion \| INFORM]	EN
DBL-SPC	Synonym for DBL.SPC.
DBL.SPC	Use in a RetrieVe sentence or SQL SELECT statement to set double spacing between records in a report, overriding the default single spacing. For example:
DEACTLIST	Use the MKFILELIST command to create a list of files that you want to activate and deactivate for transaction logging. Use the ACTLIST command to activate the files in the list.	DEACTLIST listname	E
DECATALOG	Use DECATALOG to delete a locally cataloged program from your VOC file and to delete the object code for that program. DECATALOG does not delete the source code of the program. (Use DELETE to do this.)	DECATALOG [filename [program]]	E
DEFAULT	Use with the SET.TERM.TYPE command to set the map for the corresponding terminal type from its entry in the terminfo directory.
DEFAULTS	Use with the CONFIGURE.FILE command to configure a dynamic (type 30) file with the default dynamic file parameters. The values for GROUP.SIZE and RECORD.SIZE are not changed by the DEFAULTS keyword.
DEFER	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to defer printing of the report until the time specified in its argument. Its argument can be specified in one of the following formats:
DEFINE.DF	A distributed file is made up of one or more part files. Part files are standard UniVerse hashed files (including dynamic files). Type 1 and type 19 files cannot be part files.	DEFINE.DF [DATA] dist.filename [ADDING] part.name [part#] [part.name [part#]...] [algorithm] [FORCE]	E
DEL.RFILE	If any of the log files you specify have entries in the UV_LOGS file, DEL.RFILE can delete them only if their status is Released. If the log files do not have entries in UV_LOGS, DEL.RFILE deletes them. DEL.RFILE does not change anything in the UV_LOGS file.	DEL.RFILE first.log last.log [logdir.path]	E
DELETE	You can use select list 0 to specify records to delete. If select list 0 is active, DELETE displays the following messages:	DELETE [DICT] filename [records]	E
DELETE.CATALOG	Use DELETE.CATALOG to remove globally, normally, or locally cataloged programs.	DELETE.CATALOG catalog.name	EN
DELETE.FILE	If you do not specify the DATA or DICT keyword, DELETE.FILE deletes the data file and its dictionary.	DELETE.FILE [DICT \| DATA] [filename]	EN
DELETE.INDEX	If you do not specify either indexes or ALL, DELETE.INDEX prompts you to enter an index name.	DELETE.INDEX [DICT] [filename] [indexes \| ALL]
DELETE.LFILE	DELETE.LFILE verifies that each log file is empty, then deletes the log file and the corresponding record in the UV_LOGS file, and reduces the value of the LOG.NEXT record in the dictionary of UV_LOGS.	DELETE.LFILE files	E
DELETE.LIST	Use DELETE.LIST to remove a saved select list that was created with the SAVE.LIST command, or to remove a sentence stack that was saved by logging out.	DELETE.LIST [listname \| *]	E
DELETING	Use with the COPY command to delete the records from the source file after they are copied to the new file. For example, to delete records 101 and 102 from the ACCOUNTS file after copying them to the DEADACCOUNTS file, enter the following:
DET-SUPP	Synonym for DET.SUP.
DET.SUP	Use in a RetrieVe sentence or SQL SELECT statement containing a BREAK.ON expression to suppress detail lines and display only breakpoint, subtotal, and total lines. For example:
DETAIL	Use with the LIST.INDEX command to display additional information detailing the name of each secondary key value, the number of records with that key value, and the bytes used for that key value.
DICT	Use with a filename to specify the file dictionary rather than the data file. Specify DICT immediately before the filename. For example:
DISABLE.INDEX	After you build an index, automatic updating is enabled. Disabling automatic updating can increase processing speed when entering data. However, reports generated from files while automatic updating is disabled can contain incorrect information. That is, records added after updating is disabled cannot be accessed using a secondary key, deleted records can still be accessed using a secondary key, and modified records can be associated with the wrong secondary key.	DISABLE.INDEX [DICT] [filenames]
DISKS	Use with the STATUS command to display disk usage information about all disks.
DISPLAY	Use DISPLAY to display a line of text on the terminal.	DISPLAY text	E
DISPLAY.LIKE	Use as a field qualifier in a RetrieVe sentence or SQL SELECT statement to set a field's display characteristics to be the same as those of another field. Its syntax is as follows:
DISPLAY.NAME	Synonym for COL.HDG.
DISPLAYLIKE	Synonym for DISPLAY.LIKE.
DISPLAYNAME	Synonym for COL.HDG.
DIVERT.OUT	DIVERT.OUT works like the COMO command, except that COMO automatically creates a &COMO& file if it does not exist, and COMO time-stamps the beginning and end of a COMO session.	DIVERT.OUT action [filename record] [parameter]	E
DLIST	Use DLIST to display a listing of I-descriptor object code. DLIST displays the I-descriptor expression followed by the lines of compiled code it generated. DLIST also displays statistics about the I-descriptor.	DLIST filename I-descriptor	E
DOS	UNIX. The DOS command is supported only if you use a suitable emulator.	DOS [/c command \| pathname]	E
DOUBLE SPACE	UniVerse SQL synonym for DBL.SPC.
DOWN	Use with the CHAP command to lower the priority of processing tasks for that account. CHAP DOWN causes 10 to be added to the priority number assigned each task.
DYNAMIC	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify a dynamic file. Dynamic files are created as type 30 files. DYNAMIC and 30 are equivalent file types.
ED	The Editor creates records, not files. You must first create files with CREATE.FILE.	ED [DICT] [filename] [records \| *]
EDIT.CONFIG	When you enter EDIT.CONFIG, you see a screen similar to this:	EDIT.CONFIG	N
EDIT.LIST	EDIT.LIST lets you create, change or add to a list using the UniVerse Editor. EDIT.LIST is the same as ED using the filename &SAVEDLISTS& and the record ID of the list you want to edit.	EDIT.LIST [listname]
EJECT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to perform a page eject at the end of a print job.
ENABLE.INDEX	Automatic updating is initially enabled. After disabling it, you can reenable automatic updating with ENABLE.INDEX.	ENABLE.INDEX [DICT] [filenames]
ENABLE.RECOVERY	ENABLE.RECOVERY starts the log daemon uvlogd.	ENABLE.RECOVERY {YES \| NO}	E
ENDPAGE	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify ending page number for printing.
ENUM	Use in a RetrieVe sentence to count the number of values that occur in a specified field in a set of records. Its syntax is as follows:
ENUMERATE	Synonym for ENUM.
ENVIRONMENT	ENV prints variables containing control characters (that is, ASCII characters 0 through 26) as a caret ( ^ ) followed by the character. For example:	ENV[IRONMENT] [DISPLAY] ENV[IRONMENT] [SET] env.variable=value ENV[IRONMENT] CLEAR env.variable	E
EQ	The relational operator EQUAL, used in selection expressions, WHEN clauses, and IF statements. For example:
EQUAL	Synonym for EQ.
ESEARCH	Use ESEARCH to create a select list of records that contain an occurrence of a specified string. ESEARCH is a synonym for the SEARCH command.	ESEARCH [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [TO n] [options]
EVAL	Use in any RetrieVe sentence to introduce an in-line I- descriptor expression. An EVAL expression defines a new virtual field which exists only for the duration of the current query. Its syntax is as follows:
EVALUATE	Synonym for EVAL.
EVERY	Use in a selection expression to select a record only if every value in a multivalued field meets the specified condition. EVERY must be used with the WITH keyword. For example:
EXCHANGE	The EXCHANGE command is a proc that copies the contents of record.a into a temporary file, then copies the contents of record.b into record.a, and then copies the contents of the temporary file into record.b.	EXCHANGE [DICT] filename record.a record.b
EXPLODE	Use with the SEARCH command to specify that an element be included in the select list for each value in a record that matches a specified string. The select list elements also contain the field and value number in which the string was found. When the EXPLODE keyword is used, the list elements are created according to the form:
EXTERNAL	Use with the DEFINE.DF and REBUILD.DF commands to specify an external routine as the partitioning algorithm for a distributed file.
FANCY.FORMAT	If you do not specify filename or program, FANCY.FORMAT prompts for them.	FANCY.FORMAT [filename] [program \| *] [-LIST]
FILE	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
FILE.OFF	Use with the DIVERT.OUT command to suspend the diversion of command output to the current file. Subsequent command output is not diverted until a DIVERT.OUT FILE.ON command is entered.
FILE.ON	Use with the DIVERT.OUT command to resume sending command output to a file after it had been suspended by issuing a DIVERT.OUT FILE.OFF command.
FILE.STAT	If you specify a type 1, type 19, type 25, or dynamic file (type 30), an error message appears.	FILE.STAT [DICT] filename [[DICT] filename...] [LPTR]	E
FILE.USAGE	The FILE.USAGE report contains the following data:	FILE.USAGE [DICT] [filenames]
FILE.USAGE.CLEAR	Use FILE.USAGE.CLEAR to reset the file usage statistics displayed by the FILE.USAGE command. You must have write permission on a file to collect its statistics.	FILE.USAGE.CLEAR [DICT] [filenames]
FILE.USAGE.OFF	Use FILE.USAGE.OFF to disable collection of file usage statistics displayed by the FILE.USAGE command. You must have write permission on a file to use this command.	FILE.USAGE.OFF [DICT] [filenames]
FILELOCK	Use with the UNLOCK command to restrict lock removal to file locks. When combined with the SEMAPHORE n argument of the UNLOCK command, FILELOCK releases concurrency control semaphores that control access to the file lock table.
FIRST	Use in a RetrieVe sentence or SQL SELECT statement as a synonym for SAMPLE.
FMT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify that the spooler controls pagination and formatting.
FOOTER	Synonym for FOOTING.
FOOTING	Use in a RetrieVe sentence or SQL SELECT statement to define a footer for the bottom of each page of your report. Its syntax is as follows:
FOR	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
FORCE	Use with the CATALOG command to force the replacement of an existing global catalog routine of the same name. To replace the cataloged program RECEIVABLES with an updated version, enter the following:
FORM	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify a special form for printing this report. The system operator is prompted to put the named form in the printer. The name can be up to six characters long, and is specified as an argument to FORM.
FORM.FEED	Use with the CP or CT command to list each record on a separate page.
FORM.LIST	If you enter FORM.LIST without specifying filename or record, FORM.LIST prompts for them.	FORM.LIST [filename] [record] [TO n]	E
FORMAT	Synonym for FMT.
FORMAT.CONV	Use the first syntax for converting the format of UniVerse files. Use the second syntax when you are exporting and importing UniVerse SQL tables either from one system to another or from one schema to another on the same system.	FORMAT.CONV [options] pathname	EN
FORMAT.MAP	In NLS mode, use with the SETPTR command to set a map name for formatting only. Data still goes to the spool queue with a map name of NONE.
FROM	Use in a RetrieVe sentence or in an NSELECT, QSELECT, or SAVE.LIST sentence to specify that the records listed in the specified numbered select list should be used. Its syntax is as follows:
FTN	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify that reports contain FORTRAN control codes.
GE	The relational operator GREATER THAN OR EQUAL TO used in selection expressions, WHEN clauses, and IF statements. For example:
GENERAL	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the general hashing algorithm for dynamic (type 30) files. The SEQ.NUM keyword can be used in place of GENERAL to specify a hashing algorithm suitable for sequential numbers. GENERAL is the default hashing algorithm for dynamic files.
GET.FILE.MAP	GET.FILE.MAP returns the name of the map associated with the specified file. If there is no map name associated with the file, the command gives the name of the default map to be used.	GET.FILE.MAP [DICT] filename	EN
GET.LIST	Activating a select list makes it available to BASIC READNEXT statements, control level commands, data management commands, and RetrieVe commands. After you execute GET.LIST, a message confirms that the list is active.	GET.LIST [[filename] listname] [TO list#]	E
GET.LOCALE	GET.LOCALE also displays details of any saved locale that differs from the current one. If locales are not enabled on the system, or if NLS mode is off, GET.LOCALE returns an error.	GET.LOCALE [category \| ALL]	E
GET.STACK	Use GET.STACK to retrieve a saved sentence stack from the &SAVEDLISTS& file and load it into the current sentence stack.	GET.STACK [listname]	E
GET.TERM.TYPE	The terminal type is set by a SET.TERM.TYPE command or from the TERM environment variable if no SET.TERM.TYPE command was executed.	GET.TERM.TYPE [HUSH]	E
GO	The labelled statement must follow the GO statement or the remaining statements will be skipped. You can use the GO statement in an IF statement to exit a loop.	GO label [:]	E
GRAND TOTAL	UniVerse SQL synonym for GRAND.TOTAL.
GRAND-TOTAL	Synonym for GRAND.TOTAL.
GRAND.TOTAL	Use with RetrieVe commands and the SQL SELECT statement to specify text to be printed on the grand total line of a report. Any text you specify is printed left-justified in the first column of the report. Text that exceeds the width specification for the first column is truncated. Its syntax is as follows:
GREATER	Synonym for GT.
GROUP	Use with the UNLOCK command to restrict lock removal to the group specified by its group address. Its syntax is as follows:
GROUP.SIZE	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the size of each group in a dynamic (type 30) file. Its syntax is as follows:
GROUP.STAT	If you do not include filename and a select list is active, GROUP.STAT analyzes the files specified by the list.	GROUP.STAT [DICT] filename [NO.PAGE] [LPTR]	E
GROUP.STAT.DETAIL	If you do not include filename and a select list is active, GROUP.STAT.DETAIL analyzes the filenames specified by the list.	GROUP.STAT.DETAIL [DICT] [filename] [NO.PAGE] [LPTR]	E
GROUPLOCK	Use with the UNLOCK command to restrict lock removal to group locks and update record locks associated with the group. When combined with the SEMAPHORE n argument of the UNLOCK command, releases concurrency control semaphores that control access to the group lock table.
GT	The relational operator GREATER THAN used in selection expressions, WHEN clauses, and IF statements. For example:
HASH.AID	If you do not include filename, type, or modulo in the command line, HASH.AID prompts for them. You can enter the value for type, modulo, and separation as control variables for a loop. When you do that, enter the value as follows:	HASH.AID [DICT] [filename] [type] [modulo] [separation] [NO.PAGE] [LPTR]	E
HASH.HELP	The HASH.HELP recommendation is based on the averages of the existing records. The modulo it recommends is the minimum modulo and may be smaller than needed. Use the PERCENT.GROWTH keyword to size the file for anticipated growth.	HASH.HELP [DICT] [filename] [NO.PAGE] [LPTR] [PERCENT.GROWTH n]	E
HASH.HELP.DETAIL	In addition to the key and record information that HASH.HELP provides, HASH.HELP.DETAIL also provides the smallest, largest, and average record ID and record data sizes.	HASH.HELP.DETAIL [DICT] [filename] [NO.PAGE] [LPTR]	E
HASH.TEST	If you do not include the filename, type, or modulo in the command line, you are prompted for the missing information.	HASH.TEST [DICT] [filename] [type] [modulo] [separation] [NO.PAGE] [LPTR]	E
HASH.TEST.DETAIL	If you do not include the filename, type, or modulo in the command line, you are prompted for the missing information.	HASH.TEST.DETAIL [DICT] [filename] [type] [modulo] [separation] [NO.PAGE] [LPTR]	E
HDR-SUPP	Synonym for HDR.SUP.
HDR.SUP	Use in a RetrieVe sentence or SQL SELECT statement to suppress the default header, which contains the sentence that you executed, the time, the date, and the page number. For example:
HEADER	Synonym for HEADING.
HEADER DEFAULT	Synonym for HEADING DEFAULT.
HEADING	Use in a RetrieVe sentence or SQL SELECT statement to define a header at the top of each page of your report. This heading overrides the default heading. The default heading includes the sentence, the time, the date, and a page number. Its syntax is as follows:
HEADING DEFAULT	Use in a RetrieVe sentence or SQL SELECT statement to specify the default header, which contains the sentence that you executed, the time, the date, and the page number.
HELP	You can also get help by entering ?item. If field 1 in a record in the VOC file contains a description, ?item displays it.	HELP [BASIC \| CONV \| PICK \| SQL \| BCI \| helpfile] [item \| *]	E
HEX	Use with the COPY and T.READ commands to display data in hexadecimal format.
HOLD	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to send print jobs to the spool queue in the hold state. The jobs are not printed initially but can be printed using SP.EDIT (UNIX), SP.EDIT (Windows NT), or usm -r. The jobs can be removed from the spool queue using SP.EDIT or usm -k. Unlike the RETAIN option, HOLD removes a job from the spool queue once it is printed. The HOLD option is the same as the S option of SP.ASSIGN.
HUSH	You might use this command when you are transmitting information over phone lines or when you are sending data to a hard-copy terminal. Both these situations result in slower transmission speeds. The unnecessary data display makes the task even slower.	HUSH [ON \| OFF]
IAM	Some commands require an account directory name. CATALOG, for example, uses the account directory name as part of the name of a cataloged program when you use normal cataloging.	IAM account.dir	E
ID-SUP	Synonym for ID.SUP.
ID-SUPP	Synonym for ID.SUP.
ID.ONLY	Use in a RetrieVe sentence or SQL SELECT statement to display only record IDs when the fields in the @ phrase or @LPTR phrase would otherwise be displayed. However, if you use this keyword in a sentence that specifies field names for display, it is ignored. To display only record IDs instead of the fields in the @LPTR or @ phrase, use a sentence like the following:
ID.SUP	Use in a RetrieVe sentence, a SQL SELECT statement, or a COPY command to suppress record IDs. Without this keyword, RetrieVe displays record IDs in the first column of a report. For example:
IF	Use IF in a paragraph to change the operation sequence. The IF statement introduces a test whose results determine the next action. You must use an IF statement in a loop to end the loop (see "Example"). IF statements have no function on the command line.	IF expression THEN sentence	E
IN	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
IN2.FORMAT	Forces IN2-compatible format.
INFORM	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to display spooler job numbers of newly queued jobs. The default is that INFORM is turned off.
INFORMATION.FORMAT	Use with the T.DUMP, T.LOAD, and T.WTLBL commands to specify a tape label in a format compatible with Prime INFORMATION. Prime INFORMATION systems do not write tape labels.
INITIALIZE.CATALOG	The impact of INITIALIZE.CATALOG can be catastrophic. You should be absolutely sure you want to initialize the catalog space. If you have any doubts whatsoever about this, do not press Y at the Continue Initialization prompt.	INITIALIZE.CATALOG [-R]	E
INITIALIZE.DEMO	UniVerse supplies the sample files CUSTOMERS, INVENTORY, and ORDERS. INITIALIZE.DEMO updates the VOC file, then verifies that files with these names do not exist. If a file with one of these names exists, INITIALIZE.DEMO checks to see if it is an old demonstration file. If it is, INITIALIZE.DEMO clears the file without prompting you and loads new records into the file. If the file is not an old demonstration file, INITIALIZE.DEMO asks if you want to overwrite it. This command also checks for the existence of an ACCOUNTS file. If it exists, INITIALIZE.DEMO asks if you want to delete it.	INITIALIZE.DEMO
INPLACE	Use with the RESIZE command to resize a file in place. This is very useful when free disk space is low. To resize the file PAYABLES in its present disk location, enter the following:
INQUIRING	Use in any RetrieVe sentence to prompt for the record IDs. Enter a record ID at the Records prompt. To end the prompting, press Return. For example:
INTERNAL	Use with the DEFINE.DF command to specify the partitioning algorithm for a distributed file.
INVISIBLE	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
IS.NOT.NULL	A relational operator used in selection expressions, WHEN clauses, and IF statements. Its syntax is as follows:
IS.NULL	A relational operator used in selection expressions, WHEN clauses, and IF statements. Its syntax is as follows:
In-Line Prompting
JOBS	Phantom processes are processes that run in the background. You start them with the PHANTOM command.	JOBS	E
KEEP	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to keep output files open after reports are sent to them. Use in mode 3 to append subsequent reports to the same file.
KEEP.COMMON	Use with the RUN and RAID commands. Maintains the value of unnamed common variables across BASIC programs connected with the CHAIN statement.
LARGE.RECORD	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the size of a record ID considered too large to be included in the primary group buffer of a dynamic (type 30) file. Its syntax is as follows:
LE	The relational operator LESS THAN OR EQUAL TO used in selection expressions, WHEN clauses, and IF statements. For example:
LESS	Synonym for LT.
LIKE	Synonym for MATCHING.
LIMIT	If you do not specify PROGRAMSIZE, LIMIT displays the current value.	LIMIT [PROGRAMSIZE size]
LIST	LIST lists the selected records in the order in which they are stored in the file, unless you specify a sort expression.	LIST [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [output] [report.qualifiers]
LIST commands	The LIST commands are sentences or procs stored in the UNIVERSE.VOCLIB file. The following table describes each command:	LISTDOS LISTF LISTFL LISTFR LISTK LISTM LISTO LISTPA LISTPH LISTPQ LISTR LISTS LISTSL LISTUN LISTV
LIST.DF	Use LIST.DF to list the pathnames and part numbers of part files belonging to a distributed file.	LIST.DF dist.filename	E
LIST.DIFF	The system prompts you to enter the name of a second list by displaying the following prompt:	LIST.DIFF [listname1] [options]	E
LIST.FILE.STATS	If you enter LIST.FILE.STATS with no options, the command generates a listing of statistics stored in the UNIVERSE.STAT.FILE file.	LIST.FILE.STATS [LOCAL] [WIDE] [LPTR]	E
LIST.INDEX	If you do not specify either indexes or ALL, LIST.INDEX prompts you.	LIST.INDEX [DICT] [filename] [indexes \| ALL] [STATISTICS \| STATS \| DETAIL] [LPTR [n]] [NO.PAGE]	EN
LIST.INTER	The system prompts you to enter the name of a second list by displaying the following prompt:	LIST.INTER [listname1] [options]	E
LIST.ITEM	RetrieVe field output specifications are ignored.	LIST.ITEM [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [sort] [report.qualifiers]
LIST.LABEL	After you enter a LIST.LABEL command, the following prompt appears:	LIST.LABEL [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [output] [report.qualifiers]	E
LIST.LOCKS	LIST.LOCKS displays the lock number and a number that indicates which user set the lock. If a lock is not set, LIST.LOCKS displays a series of dashes.	LIST.LOCKS	E
LIST.READU	The LIST.READU command produces a report containing the following information:	LIST.READU [USER terminal#] [EVERY]	E
LIST.SICA	LIST.SICA lists the currently active column, constraint, and permission definitions for the specified table.	LIST.SICA tablename [LPTR] [NO.PAGE]	E
LIST.UNION	The system prompts you to enter the name of a second list by displaying the following prompt:	LIST.UNION [listname1] [options]	E
LISTME	The contents of the LISTME report depends on the operating system you are running.	LISTME	E
LISTU	The contents of the LISTU report depends on the operating system you are running.	LISTU	E
LNUM	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to prefix each line with its line number.
LOCAL	Use in a CATALOG command to specify that a BASIC program should be cataloged in the current account rather than in the system catalog. To catalog the subroutine OVERDUE locally, enter the following:
LOCK	If you use LOCK without the PROMPT or NO.WAIT keywords, and if the lock you specify is not available, the command waits until the lock is free before returning control to the command processor.	LOCK n [PROMPT \| NO.WAIT]	E
LOCKS	Can be included in the MASTER command for compatibility with Prime INFORMATION.
LOG.RESTORE	Use LOG.SAVE to save transaction logging files from disk to tape. LOG.SAVE does not change anything in the UV_LOGS file.	LOG.SAVE first.log last.log [logdir.path] [device]	E
LOGIN	When your UniVerse account is first created, the VOC file does not contain a LOGIN entry. You can create or change a LOGIN entry in the VOC file at any time. UniVerse searches for this entry and executes it when you invoke UniVerse and when you log to a UniVerse account.	LOGIN	E
LOGON	If you enter LOGON port, a UniVerse session starts on the named terminal.	LOGON port [command]
LOGOUT	UNIX SYSTEM V	LO [-pid#] LOGOUT [-pid#]
LOGTO	If UniVerse does not recognize the account name as an existing UniVerse account, it displays the following message:	LOGTO account
LOGTO.ABORT	If UniVerse does not recognize the account name as an existing UniVerse account, it displays the following message:	LOGTO.ABORT account
LOOP	You can use any number of LOOP...REPEAT loops. At least one of the statements must be an IF statement that specifies the exit condition and action.	LOOP statements REPEAT	E
LPTR	Use in a RetrieVe sentence or SQL SELECT statement to send the results to a printer channel instead of the terminal. Its syntax is as follows:
LT	The relational operator LESS THAN used in selection expressions, WHEN clauses, and IF statements. For example:
MAIL	You can send mail to other people on the system, and you can also receive mail that other people send you.	MAIL [-s subject] [user.list]	E
MAKE.DEMO.FILES	UniVerse supplies the sample files ACTS, CONCESSIONS, ENGAGEMENTS, EQUIPMENT, INVENTORY, LIVESTOCK, LOCATIONS, PERSONNEL, RIDES, and VENDORS. MAKE.DEMO.FILES creates the data files and the file dictionaries for the 10 files, compiles the dictionaries, and loads the data (from the sample directory in uvhome) into them. The 10 filenames all have the .F suffix. The data in the .F files is the same as the data in the .T tables created by MAKE.DEMO.TABLES.	MAKE.DEMO.FILES
MAKE.DEMO.TABLES	UniVerse supplies the sample tables ACTS, CONCESSIONS, ENGAGEMENTS, EQUIPMENT, INVENTORY, LIVESTOCK, LOCATIONS, PERSONNEL, RIDES, and VENDORS. MAKE.DEMO.TABLES creates the 10 tables and loads the data into them (from the sample directory in uvhome). The 10 table names all have the .T suffix. You are the owner of these tables.	MAKE.DEMO.TABLES
MAKE.MAP.FILE	The information in the &MAP& file is the same as that displayed by the MAP command. By creating the &MAP& file, you can take full advantage of the selection, sorting, and report formatting capabilities of the RetrieVe commands to produce reports on the catalog space.	MAKE.MAP.FILE
MAP	In NLS mode, use in the ASSIGN, T.ATT, or SET.TERM.TYPE command to set a map for the tape device or terminal.
MARGIN	Use in a RetrieVe sentence or SQL SELECT statement to define the width of the left margin by indenting from the left edge. If you do not use this keyword, the display is left-justified, with a left margin of 0. To change the left margin in a report, use a sentence like this:
MASTER	The MASTER command:	MASTER {LOCKS \| BREAK \| OFF} user.no \| ALL
MATCHES	Synonym for MATCHING.
MATCHING	A relational operator used in selection expressions, WHEN clauses, IF statements, and ReVise sentences.
MAX	Use in a RetrieVe sentence to calculate and list the maximum value of a field in a set of records. Its syntax is as follows:
ME	Use with the STATUS command to display information about your current processes.
MENU.DOC	MENU.DOC prompts you to enter the name of a file that stores menu records, and the name of a menu record.	MENU.DOC
MENU.PIX	MENU.PIX prompts you as follows:	MENU.PIX
MENUS	The MENUS command invokes the menu MAKE.MENUS in the UNIVERSE.MENU.FILE. The menu displays the following options:	MENUS
MERGE.LIST	Use MERGE.LIST to create a select list from existing select lists. This avoids the need to execute another SELECT command.	MERGE.LIST list1 {UNION \| INTERSECT [ION] \| DIFF [ERENCE]} list2 [TO list3] [COUNT.SUP]
MERGE.LOAD	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the level at which a dynamic (type 30) file's modulo is decreased by one. Its syntax is as follows:
MESSAGE	MESSAGE prompts you to enter the text of your message. Pressing Return ends the message and sends it.	MESSAGE [user \| number \| -ACCEPT \| -REJECT \| -STATUS [ME]]	E
MIN	Use in a RetrieVe sentence to calculate and list the minimum value of a field in a set of records. Its syntax is as follows:
MINIMIZE.SPACE	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify that the values for split load, merge load, and the large record size be calculated to optimize the amount of space required by a dynamic (type 30) file at the expense of access time. If you specify a value for split load, merge load, or large record size, the value you specify overrides the value calculated by MINIMIZE.SPACE. If MINIMIZE.SPACE and RECORD.SIZE are specified, the value for the large record size calculated by MINIMIZE.S PACE is used instead of the value calculated by RECORD.SIZE.
MINIMUM.MODULUS	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the minimum modulo of a dynamic (type 30) file. Its syntax is as follows:
MKFILELIST	MKFILELIST creates a select list and saves it in the &SAVEDLISTS& file. Each line in the saved list contains the account name and a filename, separated by a colon. MKFILELIST lists all files defined in the VOC file of the specified account, except for files whose names begin with ampersand ( & ).	MKFILELIST account listname	E
MOTIF	When you display a menu in Motif format, the title of the menu appears at the top of the screen. Under the title, options of the main menu are displayed in a menu bar. The first menu option is highlighted. Each option in the menu bar stands for a pull-down menu that scrolls down from the main menu bar when the user selects an option.	MOTIF menu.name	E
MTU	Specifies the magnetic tape unit and needs to be used only if you have more than one tape drive or if you want to change the mode. Its syntax is as follows:
MULTI.VALUE	Use as a field qualifier in a RetrieVe sentence or SQL SELECT statement to specify that a field name or EVAL expression be treated as multivalued. The MULTI.VALUE keyword always follows the name of the field or EVAL expression. MULTI.VALUE overrides any existing specification in field 6 of the file dictionary. See also the SINGLE.VALUE keyword.
MULTIVALUED	Synonym for MULTI.VALUE.
NE	The relational operator NOT EQUAL used in selection expressions, WHEN clauses, and IF statements. For example:
NETWORK	Use with the STATUS command to display node information about the system.
NEW.PAGE	Use with the COPY command to list each record on a separate page.
NEXT	Use with the BANNER keyword in the SETPTR (UNIX) or SETPTR (Windows NT) command to specify a unique record ID in the &HOLD& file for each new report.
NEXT.AVAILABLE	Use in a ReVise sentence to tell ReVise to use the next sequential value for the record ID every time you press Return at the RECORD ID= prompt.
NFMT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to allow the application to control pagination and formatting instead of the spooler.
NHEAD	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to suppress printing of the banner.
NLS.UPDATE.ACCOUNT	NLS.UPDATE.ACCOUNT updates VOC file entries in existing accounts for UniVerse in NLS mode. New accounts created in NLS mode do not need to be updated.	NLS.UPDATE.ACCOUNT	E
NO	Synonym for NE (not equal).
NO.INDEX	Use in a RetrieVe command to specify that secondary key indexes not be used if they exist. This is useful when indexes are not up to date or built.
NO.MATCH	Use with the SEARCH command to specify that only records not containing any of the specified strings should be selected.
NO.NEW	Use with the COPY command to copy a record only if a record with the same record ID exists in the target file. The new record overwrites the old.
NO.NULLS	Use with the CREATE.INDEX command to specify that empty secondary key values are not to be indexed in the newly created indexes. You can save disk space and processing time using this facility, but reports generated from empty-string- suppressed secondary keys do not contain values for the empty keys.
NO.PAGE	Synonym for NOPAGE.
NO.SELECT	Use with the SEARCH command to specify that a list of the record IDs be displayed instead of a select list being created.
NO.SPLIT	Use with a LIST or SORT command to start a record on a new page if it does not fit on the current page of a report.
NO.WAIT	Use in a LOCK sentence to return control to the command processor if the specified lock is already set. If this option isn't used, LOCK waits for the other user to release the lock. To return control to the command level if LOCK number 42 is set, use a sentence like the following:
NO.WARN	Use with the RUN and RAID commands to suppress all warning (nonfatal) error messages. If NO.WARN is not specified, the terminal screen prints run-time error messages as they are encountered.
NODE	Use with the UNLOCK command to restrict lock removal to the network node specified by its argument.
NODEFAULT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to change only those parameters specified with your command and not supply default settings for unspecified parameters.
NOEJECT	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to indicate not to skip to a new page at the end of a report.
NOFMT	Synonym for NFMT.
NOHEAD	Synonym for NHEAD.
NOHOLD	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to turn off the HOLD option.
NOKEEP	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to close output files after reports are sent to them.
NONE	In NLS mode, use with most NLS commands, such as the SET.FILE.MAP command, to specify that no mapping takes place. Records are read and written to the file in internal format.
NOPAGE	Use in a RetrieVe sentence or SQL SELECT statement to scroll the output on the screen and not stop at page breaks. Without NOPAGE, RetrieVe displays a page of information and the following message:
NORETAIN	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to turn off the RETAIN option.
NOT	Synonym for NE.
NOT.MATCHING	A relational operator used in selection expressions, WHEN clauses, IF statements, and ReVise sentences. NOT.MATCHING is the inverse of MATCHING.
NOTIFY	Use NOTIFY to specify whether to display messages from phantom processes instantly or when UniVerse displays the next system prompt. When you enter UniVerse, NOTIFY OFF is in effect.	NOTIFY {ON \| OFF}
NOXREF	Use in a CATALOG sentence to catalog the program without the cross-reference table and symbol table information. To catalog the program UPDATE.FILES without its cross-reference and symbol tables, enter the following:
NSELECT	NLS MODE	NSELECT [DICT] filename [FROM n] [TO n]	E
NUM.SUP	Use with the COPY command to suppress line numbers.
OF	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
OFF	Use with commands such as BREAK or DIVERT.OUT to stop or disable a process or function.
ON	Use with commands such as BREAK or DIVERT.OUT to begin or enable a process or function.
ON.ABORT	The ON.ABORT record in the VOC file executes when a program aborts. An ON.ABORT entry must be a sentence, a paragraph, a menu, a proc, a BASIC program, a verb, or a remote pointer to one of these.	ON.ABORT	E
ON.EXIT	The ON.EXIT entry in the VOC file executes when you exit UniVerse. An ON.EXIT entry must be a sentence, a paragraph, a menu, a proc, a BASIC program, a verb, or a remote pointer to one of these.	ON.EXIT	E
ONLY	Synonym for ID.ONLY.
OR	Logical operator OR used to join selection expressions, WHEN clauses, and IF statements. For example:
OVERWRITING	Use with commands such as T.LOAD or COPY to overwrite records that exist in the target file. If you do not use this keyword in your sentence, T.LOAD or COPY examines the target file and does not copy a record if a record with the same record ID already exists. For example:
P.ATT	If someone else is using the printer you want to attach, the following message appears:	P.ATT n [-WAIT]
P.DET	When you log out, UniVerse automatically releases any devices, including printers, that have been assigned to you.	P.DET n
PAGE.MESSAGE	The default state is to display the message. Disabling the message suppresses it and makes one extra line available at the bottom of each page. The cursor goes to the end of the last printed line, and no message appears. Output does not scroll beyond each page.	PAGE.MESSAGE [ON \| OFF]
PASSWD	If you do not enter your old password correctly, the message Sorry appears.	PASSWD [name]	E
PCT	Synonym for PERCENT.
PDICT	Use with a filename to specify a Pick-style file dictionary rather than the data file. PDICT causes the Pick dictionary, as specified by the P_filename in field 5 of the VOC entry, to be displayed using the DICT.PICK file rather than the DICT.DICT file. Specify PDICT immediately before the filename. For example:
PERCENT	Use in a RetrieVe sentence or SQL SELECT statement to calculate percentages for a numeric field. It calculates the total value of the specified field for all records, then calculates and displays the percent of the total value of the specified field for each record. Its syntax is as follows:
PERCENT.GROWTH	Use with the HASH.HELP command to change allowance for file growth.
PERCENTAGE	Synonym for PERCENT.
PHANTOM	There is a system-wide limit on the number of processes that you can initiate. If you can start no more processes when you issue a PHANTOM command, the following message appears:	PHANTOM [BRIEF] [SQUAWK] command
PICK.FORMAT	Use with the T.DUMP, T.LOAD, and T.WTLBL commands to specify a tape label in a format compatible with Pick systems. The label includes the time and date. With the T.WTLBL command text can follow the PICK.FORMAT keyword to be included in the label.
.*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE	Format
PORT.STATUS	Use PORT.STATUS to list currently active UniVerse jobs on the system. You can execute the PORT.STATUS command only from the uniVerse account.	PORT.STATUS [USER name] [PORT number] [DEVICE pathname] [PID process#] [FILEMAP] [LAYER.STACK] [MFILE.HIST] [LOCK.HIST] [{ENABLE \| DISABLE} LOCK.HIST] [ODBC.CONNECTIONS] [LPTR]	E
PRIME	PRIME returns two numbers, the next highest prime and the next lowest prime. This is useful for determining what number to use as the modulo for a file. Using a prime number for the modulo minimizes hashing conflicts and distributes records evenly.	PRIME n	E
PRINT	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
PRINT.ADMIN	PRINT.ADMIN invokes the Printer Administration menu. The menu comprises three submenus, one to list printer and spooler queue status, one to control print jobs, and one to change the characteristics of print jobs.	PRINT.ADMIN
PRINTER	Synonym for AT.
PRIORITY	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify priority for printing. The highest priority is 1 and the lowest is 255. The priority you enter is converted to a number within the range for Windows NT, which goes from 99 through 1. Because the range of priorities in UniVerse goes from 1 through 254, the mapping is not one to one. The following list shows the conversion of UniVerse priorities to Windows NT priorities:
PROGRAMSIZE	Use with the LIMIT command to set the total size of user memory space for storing active BASIC routines. When a routine exceeding the size specified with PROGRAMSIZE is loaded into user memory space, UniVerse tries to unload the least recently used programs to bring the total usage within the limit. Size is specified as a number of 1024-byte units. A value of 0 specifies unlimited space.
PROMPT	Use with the LOCK command to return control to the command processor so that a user can execute other commands. When the lock becomes free, it is set and a message is issued indicating that the lock is now set. You are not notified until the next prompt unless you specify NOTIFY ON.
PTERM (UNIX)	Berkeley systems do not support the following options:	PTERM [LPTR \| MTU [channel]] [DISPLAY] [option setting]	E
PTERM (Windows NT)	The allowable options for the PTERM command depend on the type of device being referenced: a console window, a telnet session, or a serial port. If an option is used for a device that is not supported, an error message is displayed.	PTERM [LPTR channel] [DEVICE name] [DISPLAY] [option setting]	E
PTIME	Use PTIME to display information about your use of the system during the current terminal session. The nature of the information depends on how your system is configured.	PTIME	E
QSELECT	You can supply an explicit record ID list on the command line. You can also use an active select list to select records.	QSELECT [DICT] filename [records \| *] [options]	E
QUIT	When you quit, UniVerse closes all files that you have been using, releases any devices that have been assigned to your terminal, and discards the sentence stack if the STACKWRITE entry in the VOC file is OFF.	Q
RADIX	RADIX prompts for the type of action with the following message:	RADIX	E
RAID	RAID can function as either an object code or a source code debugger. Thus, it is a powerful tool for detecting errors in UniVerse BASIC code. RAID lets you set and delete breakpoints, set watchpoints, step through and display source code, examine object addresses, and examine and modify variables. Use RAID in the same way you use RUN, to invoke the debugger just before program execution.	RAID [filename] program [options]
RAID.GUI	The new Raid GUI Debugger makes use of encapsulated raid output to parse the display and forward the messages into the appropriate GUI windows. In order to enable the encapsulated display, this special mode must be turned on. Once it is turned on, all raid output will be encapsulated with the start and end strings.	RAID.GUI [ON \| OFF \| SHOW ] RAID.GUI [START \| STOP \| END \| INPUT ] string RAID.GUI [STARTHEX \| STOPHEX \| ENDHEX \| INPUTHEX ] string	E
READU	Use with the UNLOCK command to restrict lock removal to update record locks.
REALITY.FORMAT	Use with the T.DUMP, T.LOAD, and T.WTLBL commands to specify a tape label in a format compatible with REALITY systems. The label includes the time and date. With the T.WTLBL command, text can follow the REALITY.FORMAT keyword to be included in the label.
REBUILD.DF	REBUILD.DF reads the distributed file header and opens each part file to verify its pathname and part number. If there are inconsistencies, REBUILD.DF fixes them. It then removes part files with duplicate part numbers from the distributed file.	REBUILD.DF dist.filename algorithm	E
RECORD	If you omit a qualifier, RECORD prompts for it.	RECORD [[DICT] filename [record]]	E
RECORD.SIZE	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify that the values for group size, and large record size for a dynamic (type 30) file should be calculated based on the value of the estimated average record size specified. Its syntax is as follows:
RECOVERY.CHECKPOINT	RECOVERY.CHECKPOINT searches all selected UniVerse files for the file containing the earliest log file checkpoint. You should roll forward this log file first. RECOVERY.CHECKPOINT also reports the last log file checkpointed. You can then determine how many log files to restore in view of the disk space available.	RECOVERY.CHECKPOINT {listname \| ALL}	E
RECOVERY.CONSISTENT	Use RECOVERY.CONSISTENT to clear the flag that indicates a file is in an inconsistent state. You must be a UniVerse Administrator logged in to the uniVerse account to use RECOVERY.CONSISTENT.	RECOVERY.CONSISTENT pathname	E
REFORMAT	After you enter a REFORMAT command, the following prompt appears:	REFORMAT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] output [modifiers] [MTU mtu] [BLK size] [labelopt]
RELEASE	You should not need to use RELEASE unless an unusual event occurs that prevents the BASIC program from releasing records locked by MATREADL, MATREADU, READL, READU, READVL, and READVU statements.	RELEASE [filename] [record]
RELEASE.LFILE	RELEASE.LFILE makes a full log file available for reuse. Once you release a log file, its logged updates are lost; if you still need them, you should back up the log file to tape before releasing them.	RELEASE.LFILE logfile	EN
REMOVE.DEMO.FILES	REMOVE.DEMO.FILES removes the UniVerse data files, and the associated file dictionaries that were created by the MAKE.DEMO.FILES command.	REMOVE.DEMO.FILES
REMOVE.DEMO.TABLES	REMOVE.DEMO.TABLES removes the tables that were created by the MAKE.DEMO.TABLES command.	REMOVE.DEMO.TABLES
REMOVING	Use with the DEFINE.DF command to remove a part file from a distributed file.
REPEAT	Use REPEAT in a loop. See the LOOP command for information about REPEAT.
REPORTING	Use with the COPY command to display the status of the OVERWRITE, UPDATING, and DELETING options, and record IDs of the source records and the record IDs of the copies.
REQUEUE	Synonym for RETAIN.
REQUIRE.INDEX	Use in a RetrieVe command to specify that secondary key indexes must be used to process the sentence. If indexes cannot be used, an error message appears and the sentence does not proceed.
REQUIRE.SELECT	Use with any RetrieVe sentence when you want to process a select list. This keyword requires an active select list in order to run the process. If a select list is not active, a message like the following appears:
RESIZE	As you add records to a file, your original estimate of the file type, modulo, and separation may no longer be correct. You can use commands such as HASH.HELP, HASH.HELP.DETAIL, HASH.TEST, and HASH.TEST.DETAIL to test a file type, modulo, and separation, without actually changing the file structure. As a file grows, it may be necessary to change the modulo, separation, and file type to maintain the most efficient file structure.	RESIZE [DICT] [filename] [type] [modulo] [separation] [CONCURRENT \| INPLACE \| USING partition]
RESTORE.LOCALE	RESTORE.LOCALE restores a locale that was previously saved using the SAVE.LOCALE command. When you enter UniVerse, a locale is set up and saved automatically. RESTORE.LOCALE restores this initial locale unless you executed a SAVE.LOCALE command during your UniVerse session.	RESTORE.LOCALE
RETAIN	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to hold jobs in the spool queue after printing them. Held jobs can be reprinted using usm with the -r option or by using the SP.EDIT (UNIX) or SP.EDIT (Windows NT) command. Reprinting the job does not remove it from the spool queue. Held jobs can be removed from the spool queue using the -k option of usm, or by using the SP.EDIT command. The RETAIN option is the same as the H option of SP.ASSIGN.
REVISE	Use REVISE to add, change, and delete file records.	REVISE [DICT] [filename] [fields] [USING process] [verifield {VERIFY \| VERIFILE} verifile [VERIFIELD display.field]]
RUN	If you do not use NO.PAGE, UniVerse counts the lines printed by the PRINT statement and displays the following message at the bottom of each full page:	RUN [filename] program [options]
SAID	A relational operator used in WITH expressions, WHEN clauses, and IF statements to select values that sound like the specified value. The specified value must begin with the same letter as the value. To create a list of all names like Paine, Payne, Pane, and so on, enter the following:
SAMPLE	Use in a RetrieVe command to limit the number of records selected. Its syntax is as follows:
SAMPLED	Use in a RetrieVe command to limit the number of records selected. SAMPLED selects every nth record, whereas SAMPLE selects the first n records. Its syntax is as follows:
SAVE.LIST	To save select list 0, you must use SAVE.LIST immediately after you have created the list.	SAVE.LIST [[filename] listname] [FROM n]	E
SAVE.LOCALE	SAVE.LOCALE saves the current setting for a locale. You can save only one locale at a time.	SAVE.LOCALE
SAVE.STACK	If you do not specify listname, SAVE.STACK prompts you for one.	SAVE.STACK [listname]	E
SAVING	Use with SELECT, SSELECT, or QSELECT to create a list containing field values instead of record IDs. If you have field values that are also record IDs in another file, this is useful. The syntax in SELECT or SSELECT sentences is as follows:
SEARCH	After you enter SEARCH, the following prompt appears:	SEARCH [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [TO n] [options]
SELECT	Use SELECT to create a list of records that meet specified criteria. You can then use this list with other commands in the UniVerse system. Because the list contains the data or record IDs from selected records, it is called a select list.	SELECT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [SAVING [UNIQUE] field [NO.NULLS]] [TO n] [report.qualifiers]
SELECT.ONLY	Synonym for REQUIRE.SELECT.
SEMAPHORE.STATUS	SEMAPHORE.STATUS is not available on all systems. It is designed only for systems whose semaphores are implemented in assembly language.	SEMAPHORE.STATUS	E
SEQ.NUM	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the sequential numeric hashing algorithm for dynamic (type 30) files. The sequential numeric hashing algorithm should be used only for files with record IDs that are mainly numeric, sequential, and consecutive. For other files use the GENERAL keyword to specify the general hashing algorithm. GENERAL is the default hashing algorithm for dynamic files.
SET.FILE	If you do not specify qualifiers, SET.FILE prompts for them.	SET.FILE [account] [filename] [pointer]
SET.FILE.MAP	Use SET.FILE.MAP to assign a map to a file. The map defines the external character set for the file. Use this command when you have existing UniVerse files containing non-ASCII characters, and you want to access them in NLS mode.	SET.FILE.MAP [DICT] filename {mapname \| DEFAULT \| NONE} [FORCE] [VERIFY]	E
SET.GCI.MAP	Use SET.GCI.MAP to set a map for GCI subroutines to use for passing strings between BASIC and C or FORTRAN programs.	SET.GCI.MAP [mapname \| DEFAULT \| NONE \| OS]	N
SET.INDEX	You can use SET.INDEX on any UniVerse file for which you have write permissions. If you move or copy a file at the operating system level, SET.INDEX lets you easily change the file header information to point to the new location for the secondary indexes.	SET.INDEX [DICT] filename [TO [pathname \| NULL]] [options]	E
SET.LOCALE	For complete information about locales, see UniVerse NLS Guide.	SET.LOCALE [category \| ALL] {locale.name \| OFF}	E
SET.LOG.ATTR	The transaction logging system can run in checkpoint, archive mode, or both. You can change the mode of transaction logging only when its state is inactive, uninitialized, suspended, or disabled.	SET.LOG.ATTR {CHECKPOINT \| ARCHIVE} {ON \| OFF} [DEVICELIST devices]	E
SET.REMOTE.ID	Use SET.REMOTE.ID before entering any command that accesses a remote file. If you are connecting a local UNIX or Windows NT system to a remote Windows NT system via TCP/IP, you must use SET.REMOTE.ID to specify a user name and password.	SET.REMOTE.ID [domain] username {password \| PROMPT} ON nodename [[GROUP] groupname]	E
SET.SEQ.MAP	SET.SEQ.MAP specifies the map you want to use with the BASIC sequential I/O statements if no explicit map is assigned to the sequential file or device that you opened. Use SET.SEQ.MAP with no options to report the current map name as set by the uvconfig parameter or by a previous SET.SEQ.MAP command.	SET.SEQ.MAP [mapname \| DEFAULT \| NONE]	EN
SET.SQL	SET.SQL lets you set the SQL environment variables and other aspects of the SQL environment dynamically at run time. You must specify at least one option or the REPORTING keyword.	SET.SQL {options}	E
SET.TERM.TYPE	If you enter SET.TERM.TYPE without a code, UniVerse prompts for the code. Enter ? r ?at the prompt to list supported codes.	SET.TERM.TYPE [code] [options]	E
SETFILE	Use SETFILE to create a file pointer entry in the VOC file. A file pointer entry is a synonym for a file in your own or in another account. SETFILE creates a record in the VOC file that points to a UniVerse file that already exists.	SETFILE [pathname] [filename] [OVERWRITING]	E
SETPTR (UNIX)	Use SETPTR to set the line printer spooler options for a logical print channel. These changes are effective until you use SETPTR again or use LOGOUT or QUIT.	SETPTR [channel, l.len, p.len, top, bottom, mode, options]	E
SETPTR (Windows NT)	Use SETPTR to set the line printer spooler options for a logical print channel. These changes are effective until you use SETPTR again or use LOGOUT or QUIT.	SETPTR [channel, l.len, p.len, top, bottom, mod , options]	E
SETPTR.DEFAULT	SETPTR.DEFAULT uses the SETPTR settings of logical print channel 0 in the uniVerse account to set system-wide default SETPTR parameters.	SETPTR.DEFAULT	E
SETUP.DEMO.SCHEMA	This command lets the DBA set up an SQL schema for another user who wants to run MAKE.DEMO.TABLES. SETUP.DEMO.SCHEMA registers username as an SQL user (if not already).	SETUP.DEMO.SCHEMA username
SH	Once you invoke a Bourne shell, you can execute any UNIX command. You can also give SH an argument to execute a single command or a shell script without exiting UniVerse. To return to the UniVerse prompt, enter exit or press Ctrl-D.	SH [-c "command" \| script]	E
.*X COMMAND INFORM SELECT LIST SHOW VERB	HEADING "Stock available for deletion'L'Pick the ones to delete"
SHUTDOWN.RECOVERY	Use SHUTDOWN.RECOVERY in extreme situations to disable the transaction logging system. For example, if your tape unit is unserviceable and all log files are full but processing must continue, SHUTDOWN.RECOVERY permits nontransactional updates to recoverable files without logging updates. You can reenable transaction logging with ENABLE.RECOVERY.	SHUTDOWN.RECOVERY	E
SINGLE.VALUE	Used as a field qualifier in a RetrieVe sentence or SQL SELECT statement, SINGLE.VALUE specifies that the fieldname or EVAL expression it qualifies be treated as single-valued. The SINGLE.VALUE keyword always follows the name of the field or EVAL expression. SINGLE.VALUE overrides any existing specification in field 6 of the file dictionary. See also the MULTI.VALUE keyword.
SINGLEVALUED	Synonym for SINGLE.VALUE.
SLEEP	To suspend a process for a specified amount of time, use the command in the following format:	SLEEP [seconds \| hh:mm[:ss]]	E
SOME	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
SORT	SORT lists the selected records in the order specified by the sort expression. If there is no sort expression, it lists them in record ID order.	SORT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [output] [report.qualifiers]
SORT.ITEM	SORT.ITEM ignores RetrieVe field output specifications.	SORT.ITEM [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [sort] [report.qualifiers]
SORT.LABEL	After you enter a SORT.LABEL command, the following prompt appears:	SORT.LABEL [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [output] [report.qualifiers]	E
SP.ASSIGN	Use SP.ASSIGN to set the line printer spooler options for Windows NT systems. These changes remain set until you use SP.ASSIGN again or use LOGOUT or QUIT. If you specify no options, SP.ASSIGN uses default settings.	SP.ASSIGN [copies] [{F \| Q} form] [S] [O] [T]
SP.EDIT (UNIX)	After you enter SP.EDIT, the Display prompt appears. SP.EDIT prints spooler statistics for the current file on the terminal before displaying the Display prompt. The format of the spooler statistics follow:	SP.EDIT [entry [-entry]] [Fform [-form]] [L] [R] [U] [MD] [MS] [O]
SP.EDIT (Windows NT)	After you enter SP.EDIT, the Display prompt appears. SP.EDIT prints spooler statistics for the current file on the terminal before displaying the Display prompt. The format of the spooler statistics follow:	SP.EDIT [entry [-entry]] [Fform [-form]] [L] [R] [U] [MD] [MS] [O]
SP.TAPE	You must be sure that the tape unit is assigned to you (see ASSIGN).	SP.TAPE [printer] [alignment]	E
SPLIT.LOAD	Use with the CREATE.FILE, CONFIGURE.FILE, and RESIZE commands to specify the level at which a dynamic (type 30) file's modulo is increased by one. Its syntax is as follows:
SPOKEN	Synonym for SAID.
SPOOL (UNIX)	SPOOL can use select list 0. SPOOL ignores all options if the records are spooled to the &HOLD& file.	SPOOL filename record [-AS alias][-AT printer][-COPIES n] [-FORM form][-NOHEAD][-PRINTER printer]	E
SPOOL (Windows NT)	SPOOL can use select list 0.	SPOOL filename record [-AS alias][-AT printer][-COPIES n] [-FORM form][-NOHEAD][-PRINTER printer]
SQUAWK	Use with the COPY command to display a message for each record copied, indicating the record ID of the source record, the record ID of the copy, and the status of the OVERWRITE and DELETING options. To copy the file CUR.ACCOUNTS to the file OLD.ACCOUNTS and list each record ID as it is copied, enter the following:
SREFORMAT	After you enter an SREFORMAT command, the following prompt appears:	SREFORMAT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] output [modifiers] [MTU mtu] [BLK size] [labelopt]
SSELECT	Use SSELECT to create a list of records that meet specified criteria, sorted by record ID. You can then use this list with other commands in the UniVerse system. Because the list contains the data or record IDs from selected records, it is called a select list.	SSELECT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [sort] [SAVING [UNIQUE] field [NO.NULLS]] [TO n] [report.qualifiers]
STARTPAGE	Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify starting page number for printing.
STAT	Use STAT to total the numeric values in specified fields in a file. STAT also counts the selected records, and averages and totals the data contained in the fields.	STAT [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [fields] [report.qualifiers]
STATISTICS	Use with the LIST.INDEX command to specify that additional information about the secondary key index should be displayed, including the total number of keys, records per key, and index size. Each specified index must be scanned to gather the data, so this process may take a while for large files.
STATS	Synonym for STATISTICS.
STATUS	Use STATUS to display information about users and resources.	STATUS [option] [NO.PAGE]
SUM	Use SUM to add the numeric values in specified fields of a file and list the totals at the end of each column of the report. You must include the name of at least one numeric field or a phrase name that includes a numeric field in the SUM sentence.	SUM [DICT \| USING [DICT] dictname] filename [records \| FROM n] [selection] [output.limiter] [fields] [report.qualifiers]
SUPP	Synonym for HDR.SUP.
SUPPRESS COLUMN HEADER	UniVerse SQL synonym for COL.HDR.SUPP.
SUPPRESS COLUMN HEADING	UniVerse SQL synonym for COL.HDR.SUPP.
SUPPRESS DETAIL	UniVerse SQL synonym for DET.SUP.
SUSPEND.RECOVERY	SUSPEND.RECOVERY suspends the transaction logging system. In this state, updates to recoverable files are prohibited, except by means of the roll-forward utility, and any attempt to update a recoverable file waits until the state changes. You can reenable transaction logging with ENABLE.RECOVERY.	SUSPEND.RECOVERY	E
SYSTEM	Use with the DEFINE.DF command to specify the default partitioning algorithm for a distributed file.
T.ATT	If the tape drive is already assigned to another user, T.ATT displays an error message. Wait until the other user logs out or uses T.DET before you issue another T.ATT.	T.ATT [MTU [mtu]] [[BLK] size \| (size)] [MAP mapname [-WAIT]
T.BCK	If the drive encounters an end-of-file mark before it backs up over the specified number of tape records, or if you do not specify nn, the tape is positioned before the end-of-file mark. A subsequent read operation gets an immediate end-of- file indicator.	T.BCK [MTU [mtu]] [nn]
T.DET	The T.DET command runs a BASIC program that executes an UNASSIGN command.	T.DET [MTU [mtu]]
T.DUMP	The simplest form of the T.DUMP command is as follows:	T.DUMP [DICT] filename [records] [FROM n] [selection] [sort] [MTU [mtu]] [BLK size] [modifiers]	N
T.EOD	Use T.EOD to advance a tape to the end-of-data mark. The end- of-data mark is two consecutive end-of-file marks.	T.EOD [MTU [mtu]]
T.FWD	If the drive encounters an end-of-file mark before it advances over the specified number of tape records, or if you do not specify nn, the tape is positioned after the next end-of-file mark.	T.FWD [MTU [mtu]] [nn]
T.LOAD	Use T.LOAD to copy files created by T.DUMP from tape to disk. Use ASSIGN to assign the tape drive before you use T.LOAD.	T.LOAD [DICT] filename [selection] [MTU [mtu]] [modifiers]	N
T.RDLBL	T.RDLBL reads the tape label and displays the reel number, block size, time, and date from when the tape was written, and a header text. T.RDLBL changes tape block size if necessary and prints a message that it has done so. If the tape does not have a label, the message Tape was unlabelled appears.	T.RDLBL [MTU [mtu]] [n]	N
T.READ	If you manually rewind the tape, a subsequent T.READ does not reposition the tape to the beginning. It reads the tape starting at the position of the previous T.READ because UniVerse maintains its own internal tape position counters.	T.READ [MTU [mtu]] [options]
T.REW	Use T.REW to rewind a tape to the load point.	T.REW [MTU [mtu]]
T.SPACE	Use T.SPACE to advance a specified number of files on the tape or to advance to the end-of-file mark. If the drive encounters an end-of-file mark before it advances over the specified number of records, the tape is positioned after the next end- of-file mark.	T.SPACE [MTU [mtu]] [n]
T.UNLOAD	Use T.UNLOAD to rewind a magnetic tape and unload the tape from the drive after you finish using it.	T.UNLOAD [MTU [mtu]]
T.WEOF	Use T.WEOF to write an end-of-file mark on the tape at the current position.	T.WEOF [MTU [mtu]]
T.WTLBL	Reel number is 01. Multireel tape handling has not yet been implemented.	T.WTLBL [MTU [mtu]] [format] [text]	E
TANDEM	TANDEM shows output only from UniVerse processes. You can use TANDEM in the following three modes:	TANDEM terminal.no	N
TAPE	Direct output of REFORMAT and SREFORMAT commands to tape.
TEMPL	Synonym for USING.
TERM	If you use TERM with no qualifiers, TERM displays the current settings.	TERM [#1, #2, #3, #4, #5, #6, #7, #8, #9]	E
TEST	In NLS mode, use with the UNICODE.FILE command to verify that no data loss occurs during the file conversion. If there is data loss, the file is not converted and a report is displayed.
THAN	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
THE	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
THEN	Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.
TIME	NLS MODE.	TIME	E
TO	Use in a SELECT, SSELECT, QSELECT, NSELECT, GET.LIST, FORM.LIST, SEARCH, or ESEARCH sentence to specify which select list to write the list to. The syntax for a select expression is as follows:
TOTAL	Use in a RetrieVe sentence or SQL SELECT statement to calculate and display totals for numeric fields. This keyword is often used with breakpoints to produce subtotals. The TOTAL keyword is not the same as the TOTAL function used in
TRANSPORT	Use in a RetrieVe sentence to display the last value for a specified field in a set of records. Its syntax is as follows:
TRAP	Use with the RUN and RAID commands to cause the RAID debugger to be entered when a warning message appears during run time.
TRUNCATE	Use with the DIVERT.OUT command to delete any remaining part of an existing record which has not been overwritten by the current output diversion. The end of the record is at the end of the current output diversion. The TRUNCATE option should be specified when the output record already exists and the current diversion does not entirely overwrite the previous contents; otherwise the existing record is not cleared.
TTY.OFF	Use with the DIVERT.OUT command to turn off terminal (tty) display of diverted output. User input is also turned off.
TTY.ON	Use with the DIVERT.OUT command to turn on terminal output display if it has been disabled by the TTY.OFF keyword.
TYPE	Synonym for FORM.
UMASK	UMASK values are in octal format. The default value UMASK is the default as set on your UNIX system. The default lets you read, write, and execute your files, and users can read and execute them.	UMASK [nnn]	E
UNASSIGN	While the device is assigned to you, no one else can use it. UNASSIGN releases a device so that it becomes available to other users. You can unassign a device that has been assigned to your exclusive use from your terminal. If you are using UNASSIGN at your terminal, you must be at the same terminal where you assigned the device.	UNASSIGN device
UNICODE	In NLS mode, use with the COPY, CP, CT, and SET.FILE.MAP commands to list records with each character represented by its 4-digit hexadecimal Unicode value. In the COPY command, use this option with the CRT or LPTR options.
UNICODE.FILE	The conversion process requires exclusive access to the file.	UNICODE.FILE [DICT] filename [mapname] [TEST [ID.ONLY]]	E
UNIQUE	Use with the SAVING keyword to prevent duplicates in a list of values other than record ID values. UNIQUE gives an error message unless SAVING is also in the sentence. SAVING UNIQUE also sorts on the specified field.
UNLIKE	Synonym for NOT.MATCHING.
UNLOCK	You can specify ID numbers (that is, the node number, device number, or record ID) in either decimal or hexadecimal format. Precede the number with 0x to specify it as hexadecimal.	UNLOCK [NODE node] [USER user.number] [FILE pathname \| [DEVICE device.number] [INODE i.node.number]] [GROUP group.address] [RECORD record.ID] {FILELOCK \| GROUPLOCK \| READULOCK \| READLLOCK \| ALL}
UNLOCK SEMAPHORE	UNLOCK SEMAPHORE is not available on all systems. It is designed only for systems whose semaphores are implemented in assembly language.	UNLOCK {FILELOCK \| GROUPLOCK \| READULOCK} SEMAPHORE n
UP	Use with the CHAP command to raise execution priority. If you are not in the uniVerse account, CHAP UP has no effect.
UPDATE.ACCOUNT	The optional arguments PIOPEN, PICK, NEWACC, IN2, INFORMATION, and REALITY let you change the flavor of your account.	UPDATE.ACCOUNT [PIOPEN \| PICK \| NEWACC \| IN2 \| INFORMATION \| REALITY]
UPDATE.INDEX	You can use UPDATE.INDEX when automatic updating is enabled or disabled. Automatic updating is initially enabled. After disabling it, you can use ENABLE.INDEX to reenable automatic indexing. Note that enabling automatic updating does not update the index entries; use UPDATE.INDEX for this.	UPDATE.INDEX [DICT] [filenames]
UPDATING	Use with the COPY command to copy a record only if a record with the same record ID exists in the target file. The new record overwrites the old.
USER	Use with the UNLOCK command to restrict lock removal to the locks of a particular user. A user's number can be obtained from the output of LIST.READU.
USERS	Use with the STATUS command to display information about all user processes.
USING	Use with RetrieVe commands and SQL statements to specify an alternate dictionary to be used as the file dictionary. Its syntax is as follows:
UTF8	Use with the ASSIGN, T.ATT, SET.FILE.MAP, and SET.SEQ.MAP commands to specify the name of an NLS character set map. UTF8 is the same as NONE, but with system delimiters mapped to the Unicode private use area.
UV.LOGIN	The uniVerse.LOGIN entry in the VOC file of the uniVerse account defines a sequence of commands that are executed in any UniVerse account when any user logs in to it. For example, you might include specifying default printer settings, enabling phantom notification, or changing date formats. If the UV.LOGIN entry exists, it is executed before the LOGIN entry in the VOC file of the account.	UV.LOGIN	E
UV.PROMPT	Use UVPROMPT to change the command-line-prompt character, the select-list-active character, and the line-continue character.	UVPROMPT [prompt] [select] [continue]
UV.VI	If you enter only uniVerse.VI filename, UniVerse prompts for a record name.	UV.VI [DICT] filename [records \| *]	E
UVFIXFILE	UVFIXFILE traces through a file's groups, identifies problem groups, and reports their location to standard error. If you specify the FIX option, UVFIXFILE repairs most damaged files. However, UVFIXFILE cannot detect certain file breaks, and therefore it cannot fix them.	UVFIXFILE [[DICT] filename \| [PATH] pathname] [BRIEF] [CASE setting] [DECIMAL] [FIX] [HELP] [HEXADECIMAL] [I] [LOG logfile] [MAP] [OUTPUT outfile] [REVISION] [STATS] [TRACE groups] [VLEVEL] level]] [{ZERO \| ZGROUP} groups]
VCATALOG	If you do not specify filename, you cannot specify any other qualifiers on the command line. In this case, VCATALOG prompts you for the qualifier values, one at a time. If you press Return at any of the prompts, VCATALOG terminates without verifying.	VCATALOG [filename [[catalog] [program]]] [LOCAL]
VERIFIELD	Use in a ReVise sentence to display values from a verification file. VERIFIELD must be used with either the VERIFY or VERIFILE keywords. Its syntax is as follows:
VERIFILE	Synonym for VERIFY.
VERIFY	Use in a ReVise sentence to verify that the information you are entering for a field does or does not match a record ID of another file.
VERIFY.DF	VERIFY.DF reads the distributed file header and opens each part file to verify its pathname and part number. It then displays any inconsistencies.	VERIFY.DF dist.filename	E
VERIFY.SQL	VERIFY.SQL compares data in the security and integrity constraints areas (SICAs) of tables, views, and schemas to data in the SQL catalog, and displays any inconsistencies.	VERIFY.SQL {TABLE \| VIEW} {table \| pathname} [FIX] [options] VERIFY.SQL SCHEMA [schema \| pathname] [FIX] [options] VERIFY.SQL {CATALOG \| ALL} [FIX] [options] VERIFY.SQL SCHEMAS [options]	EN
VERT	Synonym for VERTICALLY.
VERTICALLY	Use to display the output in a vertical format, with each field on a separate line. There is no spacing or formatting between lines. If a multivalued field is displayed, the information is displayed in a column. If multivalued fields are associated, the information is displayed next to each other in columns.
VI	You cannot create a UniVerse file using VI. You must first create the file using CREATE.FILE.	VI [pathname]	E
VLIST	Use VLIST to display a listing of BASIC object code. VLIST displays each line of source code followed by the lines of object code it generated. VLIST also displays statistics about your program.	VLIST [filename] program [R]	E
VVOC	When the UniVerse Administrator creates a new UniVerse account, UniVerse uses information in the NEWACC file to build the account's VOC file. As you use the account to create files, sentences, paragraphs, and other items, your VOC file changes. None of the item you create in your account appear in the NEWACC file.	VVOC [NO.PAGE] [LPTR]
WHEN	Use in a RetrieVe sentence to limit output to values or subvalues in a multivalued field that meet specified criteria. Its syntax is as follows:
WHO	Use WHO to display your terminal number and the name of your current account directory. If your login name is different from the account directory name, WHO also displays your login name.	WHO	E
WITH	Use in a RetrieVe sentence to select records whose data meets specified criteria. Its syntax is as follows:
WITHIN	Use with RetrieVe commands to RetrieVe one record with all its related subrecords. Its syntax is as follows:
analyze.shm	The disk shared memory segment is a global work area that must be present for UniVerse to work. The printer shared memory segment is local to each user.	analyze.shm {options}	E
usa	Use usa for general spooler administration. Use usa from a UNIX shell. You must be a UNIX superuser to use all options except -A, -H, -j, -p, -s, and -S. Members of printer groups can also use the -F, -a, o, and q options. If you specify no options, -s is assumed.	usa [-p printer] [-F formname [-a [+number \| pathname]]] [-A] [-b] [-c] [-C] [-g] [-H] [-j] [{- \| +} L] [{- \| +} o] [-P] [{- \| +} q] [-r] [-R] [-s] [-S] [-z]
usd	If you specify no options, usd creates no log files, and jobs are processed in order by size (smaller jobs are processed before larger).	usd [directory] [-a filename] [-e filename] [-L] [-t] [-w seconds]
usm	Use usm to alter the specification of a job already in the printer queues. Use usm from a UNIX shell.	usm [-B [L] string [-E [L] string [-Fformname] [-h] [-H] [-k] [-ncopies] [-pprinter] [-Ppriority] [-q] [-r] [-tdelay] [-x n [-m]] [-y n [-m]] jobnum \| all
usp	Use usp to submit a print job to the spooler. Use usp from a UNIX shell.	usp [-B [L] string [-C classtext] [-e] [-E [L] string [-f] [-F formname] [-h] [-H] [-J jobtext] [-l] [-n copies] [-p printer] [-P priority] [-q] [-Q] [-r] [-s] [-t delay] [-x n [-m]] [-y n [-m]] files
uv	If the directory you are working in is not set up as a UniVerse account, the following message appears:	uv
uvbackup (UNIX)	uvbackup backs up files specified by pathnames. This means you must explicitly specify each data file, file dictionary, and secondary index you want to back up. Specify the pathnames of file dictionaries in the format D_filename. Specify the pathnames of secondary indexes in the format I_filename/*.	uvbackup {-d \| -w \| -f} [-b blksize] [-cachedetail] [-cmdfil filename] [-delay buffers] [-l "labeltext"] [-limit buffers] [-rev7] [-rev8] [-rev93] [-rev94] [-s file] [{-t device} ... ] [-v \| -V] [- \| pathnames]	E
uvbackup (Windows NT)	uvbackup backs up files specified on the command line or in a command file. You must explicitly specify each data file, file dictionary, and secondary index you want to back up. Pathnames of file dictionaries have the form D_filename. Pathnames of secondary indexes have the form I_filename.	uvbackup {-d \| -w \| -f} [-b blksize] [-cachedetail] [-cmdfil filename] [-delay buffers] [-l "labeltext"] [-limit buffers] [-rev7] [-rev8] [-rev93] [-rev94] [-s file] [{-t device} -] [-v \| -V] [pathnames]	E
uvdlockd	You can use the uvdlockd command to automatically identify and resolve deadlocks as they occur, or you can manually fix a deadlock by selecting and aborting one of the deadlocked user processes.	uvdlockd {[-t time] [-r resolution] [-l location]} \| [-query] \| [-stop] \| [-v victim]	E
uvfixfile	uvfixfile traces through a file's groups, identifies problem groups, and reports their location to standard error. If you specify the -fix option, uvfixfile repairs most damaged files. However, uvfixfile cannot detect certain file breaks, and therefore it cannot fix them.	uvfixfile -f[ile] pathname [-b[rief]] [-case setting] [-dec] [-fix] [-help] [-hex] [-i] [-l[og] [logfile]] [-m[ap]] [-o[utput] [outfile]] [-rev] [-s[tats]] [-t[race] groups] [-v [level] level] [-z[ero] groups] [-zgroup groups]
uvrestore (UNIX)	To restore the contents of a directory and all its dependencies, append a slash followed by an asterisk ( * ) to pathname. For example, to restore all files and subdirectories in the SALES directory, use a command like the following:	uvrestore [-F pathname [=newpathname] [-R record [=newrecord]]] [-X pathname] [-b blksize] [-i[b]] [+I] [-l] [-L] [-n] [-p] [-P n] [-rehash] [-s file] [-startb block] [{-t device} ... ] [-U] [-v \| -V] [-verify] [ - \| imagepath]	E
uvrestore (Windows NT)	To restore the contents of a directory and all its dependencies, append a slash followed by an asterisk ( * ) to pathname. For example, to restore all files and subdirectories in the SALES directory, use a command like the following:	uvrestore [-F pathname[=newpathname] [-R record[=newrecord]]] [-X pathname] [-b blksize] [-i[b]] [+I] [-l] [-L] [-n] [-nodrv] [-p] [-P n] [-rehash] [-s file] [-startb block] [{-t device} ...] [-U] [-v \| -V] [-verify] [imagepath]	E

SYS

Contents: