IT    Universe documentation - SYS also

SYS also

Contents:

Id Category Description Syntax E/W
( ... ) SYS Use in RetrieVe sentences to group selection criteria. Parentheses alter the order of the evaluation.      
* SYS 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 SYS Use with the SPOOL command to delete a print job from the printer queue.      
-L SYS Synonym for -LIST.      
-LIST SYS Use with the BASIC, FORMAT, and FANCY.FORMAT commands to generate a listing of the program.      
-SPOOL SYS 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 SYS Use with the BASIC command to generate a cross-reference table of statement labels and variable names used in the program.      
.A SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Use .U (Uppercase) to convert a sentence from lowercase to uppercase.   .U [n]   E  
.X SYS 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  
<<...>> SYS 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  
? SYS 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 SYS 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 SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
ABORT SYS 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 SYS 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 SYS 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 SYS 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 SYS Use with the DEFINE.DF command to add a part file to a distributed file.      
AFTER SYS Synonym for GT.      
ALL SYS 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 SYS Use with the SEARCH command to select only records containing all the specified strings.      
ANALYZE.FILE SYS 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 SYS 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 SYS Logical operator AND used to join selection expressions, WHEN clauses, and IF statements. For example:      
ANY SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
APPEND SYS Use with the DIVERT.OUT command to append output from diversion to the end of an existing record.      
ARE SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
AS SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command as a synonym for BANNER.      
ASSIGN SYS 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 SYS 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 SYS Synonym for @ASSOC_ROW.      
ASSOC.WITH SYS 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 SYS Synonym for ASSOC.WITH.      
ASSOCIATIONS SYS Synonym for ASSOC.      
AT SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to route jobs to a system printer specified as its argument.      
AUTOLOGOUT SYS 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 SYS 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 SYS In NLS mode, use with the SET.TERM.TYPE command to set a map for an auxiliary printer attached to the terminal.      
AVAIL SYS 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 SYS Synonym for AVG.      
AVG SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify a name on the banner page. Its syntax is as follows:      
BASIC SYS 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 SYS Synonym for LT.      
BELL SYS Use BELL to specify whether the terminal bell sounds when UniVerse generates warning messages.   BELL {ON | OFF}    
BLK SYS 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 SYS 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 SYS 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 SYS Use with the MASTER command to enable the Break key.      
BREAK ON SYS UniVerse SQL synonym for BREAK.ON.      
BREAK SUPPRESS SYS UniVerse SQL synonym for BREAK.SUP.      
BREAK-ON SYS Synonym for BREAK.ON.      
BREAK.ON SYS 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 SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to suppress display of SETPTR settings for approval.      
BUILD.INDEX SYS 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 SYS 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 SYS Synonym for BY.DSND.      
BY-EXP SYS Synonym for BY.EXP.      
BY-EXP-DSND SYS Synonym for BY.EXP.DSND.      
BY.DSND SYS 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 SYS 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 SYS 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 SYS 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 SYS Synonym for CALC.      
CANCEL SYS Use with the DEFINE.DF command to remove the part file number and algorithm from a part file.      
CATALOG SYS 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 SYS 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 SYS Use CHAP to control execution priority.   CHAP [UP | DOWN]    
CHDIR SYS If the account is not set up for UniVerse, the following message appears:   CHDIR pathname   E  
CHECK.SUM SYS 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 SYS 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 SYS 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 SYS 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 SYS The BASIC COMMON statement assigns common variables.   CLEARCOMMON    
CLEARDATA SYS 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 SYS 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 SYS 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 SYS Use CLR to clear the screen and return the cursor to the home position. CLR is a synonym for the CS command.   CLR    
CNAME SYS 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 SYS Synonym for COL.HDR.SUPP.      
COL-SUPP SYS Synonym for COL.SUP.      
COL.HDG SYS 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 SYS 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 SYS Synonym for COL.SPCS.      
COL.SPCS SYS 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 SYS 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 SYS 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 SYS UniVerse SQL synonym for COL.SPCS.      
COMO SYS COMO is short for command output.   COMO [action]   E  
COMPILE.DICT SYS 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 SYS 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 SYS 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 SYS 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 SYS Use CONFIG to display the currently active authorization parameters and current configurable parameter values.   CONFIG [ALL | BRIEF | DATA]   E  
CONFIGURE.FILE SYS 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 SYS 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 SYS 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 SYS Synonym for CONV.      
CONVERT.ACCOUNT SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS COPY.LIST is a proc that invokes the COPY processor.   COPY.LIST [filename] [listname]   E  
CORE SYS 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 SYS 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 SYS Use in a RetrieVe sentence or SQL SELECT statement to suppress the message that lists the number of records processed.      
CP SYS Use CP to print records on the system printer. CP prints only to print channel 0.   CP [DICT] filename [records | *] [options]   E  
CREATE.FILE SYS 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 SYS 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 SYS 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 SYS CREATE.LFILE creates log files with names in the following format:   CREATE.LFILE size files   E  
CRT SYS Use with the LIST.DIFF, LIST.INTER, or LIST.UNION commands to copy data to the terminal.      
CS SYS Use CS to clear the screen and return the cursor to the home position. CS is a synonym for the CLR command.   CS    
CSH SYS 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 SYS Use CT to display records on the terminal.   CT [DICT] filename [records | *] [options]   E  
DATE SYS DATE uses a 12-hour clock to display the time.   DATE   E  
DATE.FORMAT SYS 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 SYS Synonym for DBL.SPC.      
DBL.SPC SYS 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 SYS 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 SYS 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 SYS Use with the SET.TERM.TYPE command to set the map for the corresponding terminal type from its entry in the terminfo directory.      
DEFAULTS SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Use DELETE.CATALOG to remove globally, normally, or locally cataloged programs.   DELETE.CATALOG catalog.name   EN  
DELETE.FILE SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Synonym for DET.SUP.      
DET.SUP SYS 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 SYS 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 SYS Use with a filename to specify the file dictionary rather than the data file. Specify DICT immediately before the filename. For example:      
DISABLE.INDEX SYS 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 SYS Use with the STATUS command to display disk usage information about all disks.      
DISPLAY SYS Use DISPLAY to display a line of text on the terminal.   DISPLAY text   E  
DISPLAY.LIKE SYS 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 SYS Synonym for COL.HDG.      
DISPLAYLIKE SYS Synonym for DISPLAY.LIKE.      
DISPLAYNAME SYS Synonym for COL.HDG.      
DIVERT.OUT SYS 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 SYS 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 SYS UNIX. The DOS command is supported only if you use a suitable emulator.   DOS [/c command | pathname]   E  
DOUBLE SPACE SYS UniVerse SQL synonym for DBL.SPC.      
DOWN SYS 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 SYS 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 SYS The Editor creates records, not files. You must first create files with CREATE.FILE.   ED [DICT] [filename] [records | *]    
EDIT.CONFIG SYS When you enter EDIT.CONFIG, you see a screen similar to this:   EDIT.CONFIG   N  
EDIT.LIST SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to perform a page eject at the end of a print job.      
ENABLE.INDEX SYS Automatic updating is initially enabled. After disabling it, you can reenable automatic updating with ENABLE.INDEX.   ENABLE.INDEX [DICT] [filenames]    
ENABLE.RECOVERY SYS ENABLE.RECOVERY starts the log daemon uvlogd.   ENABLE.RECOVERY {YES | NO}   E  
ENDPAGE SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify ending page number for printing.      
ENUM SYS 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 SYS Synonym for ENUM.      
ENVIRONMENT SYS 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 SYS The relational operator EQUAL, used in selection expressions, WHEN clauses, and IF statements. For example:      
EQUAL SYS Synonym for EQ.      
ESEARCH SYS 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 SYS 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 SYS Synonym for EVAL.      
EVERY SYS 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 SYS 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 SYS 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 SYS Use with the DEFINE.DF and REBUILD.DF commands to specify an external routine as the partitioning algorithm for a distributed file.      
FANCY.FORMAT SYS If you do not specify filename or program, FANCY.FORMAT prompts for them.   FANCY.FORMAT [filename] [program | *] [-LIST]    
FILE SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
FILE.OFF SYS 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 SYS 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 SYS 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 SYS The FILE.USAGE report contains the following data:   FILE.USAGE [DICT] [filenames]    
FILE.USAGE.CLEAR SYS 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 SYS 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 SYS 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 SYS Use in a RetrieVe sentence or SQL SELECT statement as a synonym for SAMPLE.      
FMT SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify that the spooler controls pagination and formatting.      
FOOTER SYS Synonym for FOOTING.      
FOOTING SYS 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 SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
FORCE SYS 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 SYS 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 SYS Use with the CP or CT command to list each record on a separate page.      
FORM.LIST SYS If you enter FORM.LIST without specifying filename or record, FORM.LIST prompts for them.   FORM.LIST [filename] [record] [TO n]   E  
FORMAT SYS Synonym for FMT.      
FORMAT.CONV SYS 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 SYS 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 SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify that reports contain FORTRAN control codes.      
GE SYS The relational operator GREATER THAN OR EQUAL TO used in selection expressions, WHEN clauses, and IF statements. For example:      
GENERAL SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS UniVerse SQL synonym for GRAND.TOTAL.      
GRAND-TOTAL SYS Synonym for GRAND.TOTAL.      
GRAND.TOTAL SYS 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 SYS Synonym for GT.      
GROUP SYS Use with the UNLOCK command to restrict lock removal to the group specified by its group address. Its syntax is as follows:      
GROUP.SIZE SYS 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 SYS 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 SYS 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 SYS 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 SYS The relational operator GREATER THAN used in selection expressions, WHEN clauses, and IF statements. For example:      
HASH.AID SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Synonym for HDR.SUP.      
HDR.SUP SYS 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 SYS Synonym for HEADING.      
HEADER DEFAULT SYS Synonym for HEADING DEFAULT.      
HEADING SYS 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 SYS 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 SYS 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 SYS Use with the COPY and T.READ commands to display data in hexadecimal format.      
HOLD SYS 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 SYS 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 SYS 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 SYS Synonym for ID.SUP.      
ID-SUPP SYS Synonym for ID.SUP.      
ID.ONLY SYS 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 SYS 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 SYS 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 SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
IN2.FORMAT SYS Forces IN2-compatible format.      
INFORM SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Use with the DEFINE.DF command to specify the partitioning algorithm for a distributed file.      
INVISIBLE SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
IS.NOT.NULL SYS A relational operator used in selection expressions, WHEN clauses, and IF statements. Its syntax is as follows:      
IS.NULL SYS A relational operator used in selection expressions, WHEN clauses, and IF statements. Its syntax is as follows:      
JOBS SYS Phantom processes are processes that run in the background. You start them with the PHANTOM command.   JOBS   E  
KEEP SYS 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 SYS Use with the RUN and RAID commands. Maintains the value of unnamed common variables across BASIC programs connected with the CHAIN statement.      
LARGE.RECORD SYS 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 SYS The relational operator LESS THAN OR EQUAL TO used in selection expressions, WHEN clauses, and IF statements. For example:      
LESS SYS Synonym for LT.      
LIKE SYS Synonym for MATCHING.      
LIMIT SYS If you do not specify PROGRAMSIZE, LIMIT displays the current value.   LIMIT [PROGRAMSIZE size]    
LIST SYS 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.DF SYS 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 SYS 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 SYS 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 SYS 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 SYS The system prompts you to enter the name of a second list by displaying the following prompt:   LIST.INTER [listname1] [options]   E  
LIST.ITEM SYS RetrieVe field output specifications are ignored.   LIST.ITEM [DICT | USING [DICT] dictname] filename [records
| FROM n] [selection] [sort] [report.qualifiers]  
 
LIST.LABEL SYS 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 SYS 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 SYS The LIST.READU command produces a report containing the following information:   LIST.READU [USER terminal#] [EVERY]   E  
LIST.SICA SYS LIST.SICA lists the currently active column, constraint, and permission definitions for the specified table.   LIST.SICA tablename [LPTR] [NO.PAGE]   E  
LIST.UNION SYS The system prompts you to enter the name of a second list by displaying the following prompt:   LIST.UNION [listname1] [options]   E  
LISTME SYS The contents of the LISTME report depends on the operating system you are running.   LISTME   E  
LISTU SYS The contents of the LISTU report depends on the operating system you are running.   LISTU   E  
LNUM SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to prefix each line with its line number.      
LOCAL SYS 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 SYS 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 SYS Can be included in the MASTER command for compatibility with Prime INFORMATION.      
LOG.RESTORE SYS 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 SYS 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 SYS If you enter LOGON port, a UniVerse session starts on the named terminal.   LOGON port [command]    
LOGOUT SYS UNIX SYSTEM V   LO [-pid#]
LOGOUT [-pid#]  
 
LOGTO SYS If UniVerse does not recognize the account name as an existing UniVerse account, it displays the following message:   LOGTO account    
LOGTO.ABORT SYS If UniVerse does not recognize the account name as an existing UniVerse account, it displays the following message:   LOGTO.ABORT account    
LOOP SYS 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 SYS 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 SYS The relational operator LESS THAN used in selection expressions, WHEN clauses, and IF statements. For example:      
MAIL SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS The MASTER command:   MASTER {LOCKS | BREAK | OFF} user.no | ALL    
MATCHES SYS Synonym for MATCHING.      
MATCHING SYS A relational operator used in selection expressions, WHEN clauses, IF statements, and ReVise sentences.      
MAX SYS 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 SYS Use with the STATUS command to display information about your current processes.      
MENU.DOC SYS 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 SYS MENU.PIX prompts you as follows:   MENU.PIX    
MENUS SYS The MENUS command invokes the menu MAKE.MENUS in the UNIVERSE.MENU.FILE. The menu displays the following options:   MENUS    
MERGE.LIST SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Synonym for MULTI.VALUE.      
NE SYS The relational operator NOT EQUAL used in selection expressions, WHEN clauses, and IF statements. For example:      
NETWORK SYS Use with the STATUS command to display node information about the system.      
NEW.PAGE SYS Use with the COPY command to list each record on a separate page.      
NEXT SYS 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 SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to allow the application to control pagination and formatting instead of the spooler.      
NHEAD SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to suppress printing of the banner.      
NLS.UPDATE.ACCOUNT SYS 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 SYS Synonym for NE (not equal).      
NO.INDEX SYS 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 SYS Use with the SEARCH command to specify that only records not containing any of the specified strings should be selected.      
NO.NEW SYS 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 SYS 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 SYS Synonym for NOPAGE.      
NO.SELECT SYS 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 SYS 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 SYS 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 SYS 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 SYS Use with the UNLOCK command to restrict lock removal to the network node specified by its argument.      
NODEFAULT SYS 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 SYS 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 SYS Synonym for NFMT.      
NOHEAD SYS Synonym for NHEAD.      
NOHOLD SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to turn off the HOLD option.      
NOKEEP SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to close output files after reports are sent to them.      
NONE SYS 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 SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to turn off the RETAIN option.      
NOT SYS Synonym for NE.      
NOT.MATCHING SYS A relational operator used in selection expressions, WHEN clauses, IF statements, and ReVise sentences. NOT.MATCHING is the inverse of MATCHING.      
NOTIFY SYS 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 SYS 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 SYS NLS MODE   NSELECT [DICT] filename [FROM n] [TO n]   E  
NUM.SUP SYS Use with the COPY command to suppress line numbers.      
OF SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
OFF SYS Use with commands such as BREAK or DIVERT.OUT to stop or disable a process or function.      
ON SYS Use with commands such as BREAK or DIVERT.OUT to begin or enable a process or function.      
ON.ABORT SYS 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 SYS 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 SYS Synonym for ID.ONLY.      
OR SYS Logical operator OR used to join selection expressions, WHEN clauses, and IF statements. For example:      
OVERWRITING SYS 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 SYS If someone else is using the printer you want to attach, the following message appears:   P.ATT n [-WAIT]    
P.DET SYS When you log out, UniVerse automatically releases any devices, including printers, that have been assigned to you.   P.DET n    
PAGE.MESSAGE SYS 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 SYS If you do not enter your old password correctly, the message Sorry appears.   PASSWD [name]   E  
PCT SYS Synonym for PERCENT.      
PDICT SYS 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 SYS 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 SYS Use with the HASH.HELP command to change allowance for file growth.      
PERCENTAGE SYS Synonym for PERCENT.      
PHANTOM SYS 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 SYS 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 SYS Format      
PORT.STATUS SYS 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 SYS 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 SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
PRINT.ADMIN SYS 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 SYS Synonym for AT.      
PRIORITY SYS 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 SYS 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 SYS 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 (Windows NT) SYS 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 SYS 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 SYS 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 SYS 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 SYS RADIX prompts for the type of action with the following message:   RADIX   E  
RAID SYS 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 SYS 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 SYS Use with the UNLOCK command to restrict lock removal to update record locks.      
REALITY.FORMAT SYS 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 SYS 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 SYS If you omit a qualifier, RECORD prompts for it.   RECORD [[DICT] filename [record]]   E  
RECORD.SIZE SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS REMOVE.DEMO.TABLES removes the tables that were created by the MAKE.DEMO.TABLES command.   REMOVE.DEMO.TABLES    
REMOVING SYS Use with the DEFINE.DF command to remove a part file from a distributed file.      
REPEAT SYS Use REPEAT in a loop. See the LOOP command for information about REPEAT.      
REPORTING SYS 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 SYS Synonym for RETAIN.      
REQUIRE.INDEX SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Use REVISE to add, change, and delete file records.   REVISE [DICT] [filename] [fields] [USING process]
[verifield {VERIFY | VERIFILE} verifile
[VERIFIELD display.field]]  
 
RUN SYS 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 SYS 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 SYS Use in a RetrieVe command to limit the number of records selected. Its syntax is as follows:      
SAMPLED SYS 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 SYS 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 SYS SAVE.LOCALE saves the current setting for a locale. You can save only one locale at a time.   SAVE.LOCALE    
SAVE.STACK SYS If you do not specify listname, SAVE.STACK prompts you for one.   SAVE.STACK [listname]   E  
SAVING SYS 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 SYS 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 SYS 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 SYS Synonym for REQUIRE.SELECT.      
SEMAPHORE.STATUS SYS 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 SYS 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 SYS If you do not specify qualifiers, SET.FILE prompts for them.   SET.FILE [account] [filename] [pointer]    
SET.FILE.MAP SYS 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 SYS 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 SYS 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 SYS For complete information about locales, see UniVerse NLS Guide.   SET.LOCALE [category | ALL] {locale.name | OFF}   E  
SET.LOG.ATTR SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 (Windows NT) SYS 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 SYS 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 SYS 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 SYS 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 SYS HEADING "Stock available for deletion'L'Pick the ones to delete"      
SHUTDOWN.RECOVERY SYS 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 SYS 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 SYS Synonym for SINGLE.VALUE.      
SLEEP SYS To suspend a process for a specified amount of time, use the command in the following format:   SLEEP [seconds | hh:mm[:ss]]   E  
SOME SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
SORT SYS 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 SYS SORT.ITEM ignores RetrieVe field output specifications.   SORT.ITEM [DICT | USING [DICT] dictname] filename [records
| FROM n] [selection] [sort] [report.qualifiers]  
 
SORT.LABEL SYS 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 SYS 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 (Windows NT) SYS 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 SYS You must be sure that the tape unit is assigned to you (see ASSIGN).   SP.TAPE [printer] [alignment]   E  
SPLIT.LOAD SYS 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 SYS Synonym for SAID.      
SPOOL (Windows NT) SYS SPOOL can use select list 0.   SPOOL filename record [-AS alias][-AT printer][-COPIES n]
[-FORM form][-NOHEAD][-PRINTER printer]  
 
SQUAWK SYS 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 SYS 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 SYS 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 SYS Use with the SETPTR (UNIX) or SETPTR (Windows NT) command to specify starting page number for printing.      
STAT SYS 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 SYS 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 SYS Synonym for STATISTICS.      
STATUS SYS Use STATUS to display information about users and resources.   STATUS [option] [NO.PAGE]    
SUM SYS 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 SYS Synonym for HDR.SUP.      
SUPPRESS COLUMN HEADER SYS UniVerse SQL synonym for COL.HDR.SUPP.      
SUPPRESS COLUMN HEADING SYS UniVerse SQL synonym for COL.HDR.SUPP.      
SUPPRESS DETAIL SYS UniVerse SQL synonym for DET.SUP.      
SUSPEND.RECOVERY SYS 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 SYS Use with the DEFINE.DF command to specify the default partitioning algorithm for a distributed file.      
T.ATT SYS 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 SYS 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 SYS The T.DET command runs a BASIC program that executes an UNASSIGN command.   T.DET [MTU [mtu]]    
T.DUMP SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS Use T.REW to rewind a tape to the load point.   T.REW [MTU [mtu]]    
T.SPACE SYS 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 SYS 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 SYS Use T.WEOF to write an end-of-file mark on the tape at the current position.   T.WEOF [MTU [mtu]]    
T.WTLBL SYS Reel number is 01. Multireel tape handling has not yet been implemented.   T.WTLBL [MTU [mtu]] [format] [text]   E  
TANDEM SYS TANDEM shows output only from UniVerse processes. You can use TANDEM in the following three modes:   TANDEM terminal.no   N  
TAPE SYS Direct output of REFORMAT and SREFORMAT commands to tape.      
TEMPL SYS Synonym for USING.      
TERM SYS If you use TERM with no qualifiers, TERM displays the current settings.   TERM [#1, #2, #3, #4, #5, #6, #7, #8, #9]   E  
TEST SYS 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 SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
THE SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
THEN SYS Use in any RetrieVe sentence to make it more English-like. This keyword is not required and is ignored by RetrieVe.      
TIME SYS NLS MODE.   TIME   E  
TO SYS 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 SYS 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 SYS 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 SYS Use with the RUN and RAID commands to cause the RAID debugger to be entered when a warning message appears during run time.      
TRUNCATE SYS 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 SYS Use with the DIVERT.OUT command to turn off terminal (tty) display of diverted output. User input is also turned off.      
TTY.ON SYS Use with the DIVERT.OUT command to turn on terminal output display if it has been disabled by the TTY.OFF keyword.      
UMASK SYS 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 SYS 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 SYS 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 SYS The conversion process requires exclusive access to the file.   UNICODE.FILE [DICT] filename [mapname] [TEST [ID.ONLY]]   E  
UNIQUE SYS 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 SYS Synonym for NOT.MATCHING.      
UNLOCK SYS 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 SYS 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 SYS Use with the CHAP command to raise execution priority. If you are not in the uniVerse account, CHAP UP has no effect.      
UPDATE.ACCOUNT SYS 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 SYS 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 SYS 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 SYS 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 SYS Use with the STATUS command to display information about all user processes.      
USING SYS 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 SYS 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 SYS 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 SYS 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 SYS If you enter only uniVerse.VI filename, UniVerse prompts for a record name.   UV.VI [DICT] filename [records | *]   E  
UVFIXFILE SYS 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 SYS 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 SYS 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 SYS Synonym for VERIFY.      
VERIFY SYS 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 SYS 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 SYS 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 SYS Synonym for VERTICALLY.      
VERTICALLY SYS 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 SYS You cannot create a UniVerse file using VI. You must first create the file using CREATE.FILE.   VI [pathname]   E  
VLIST SYS 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 SYS 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 SYS 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 SYS 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 SYS Use in a RetrieVe sentence to select records whose data meets specified criteria. Its syntax is as follows:      
WITHIN SYS Use with RetrieVe commands to RetrieVe one record with all its related subrecords. Its syntax is as follows:      
analyze.shm SYS 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 SYS 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 SYS 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 SYS 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 SYS 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 SYS If the directory you are working in is not set up as a UniVerse account, the following message appears:   uv    
uvbackup (Windows NT) SYS 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 SYS 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 SYS 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 (Windows NT) SYS 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  

All documents copyright by their respective owners.