PROMPTAPPENDASSIGNBUILD CHANGECH1   CH2   COLUMNDCOLUMCOMPUTDEFINEDELETEDISPLAEDIT  ED1   ED2   ENTER EN1   EN2   EXIT  EXPANDFORMS HELP  INPUT INTERSJOIN  LIST  LOAD  LO1   LO2   OPEN  OUTPUTOWNER PACK  PASSWODPASSWPRINT PROJECRBEDITRELOADREMOVERE1   RE2   RENAMEREPORTRULES RU1   RU2   RUN   SELECTSET   ST1   ST2   SHOW  SUBTRATABLESDTABLETALLY UNION UNLOADUN1   UN2   USER  DEND  DMODE My			i



M5p>X

)CR\MmqcosN    Prompts are available for the following commands:   K     APPEND     DISPLAY    INTERSECT   PASSWORDS   RULES      UNION p     ASSIGN     EDIT       JOIN        PRINT       RUN        UNLOAD     BUILD      ENTER      LIST        PROJECT     SELECT     USER     CHANGE     EXIT       LOAD        RBEDIT      SET     COLUMNS    EXPAND     OPEN        RELOAD      SHOW      COMPUTE    FORMS      OUTPUT      REMOVE      SUBTRACT      DEFINE     HELP       OWNER       RENAME      TABLES 1     DELETE     INPUT      PACK        REPORTS     TALLY5  H  Press [G] to use Prompt mode. MENDC\APPEND @1 TO @2 WHERE @3c  APPENDj     Use APPEND to copy rows from one table to the end of another.     Name of table which is the source of rows : @1  Name of table to which to append the rows : @2  Condition which selects rows to append (optional):  @3ENDCASSIGN @3 TO @1 IN @2 WHERE @4  ASSIGN  F  Use ASSIGN to calculate new values for a column from an expressionY  or from string concatenation. ]  x  Expression (new value)                    : @1  Name of table to be modified              : @2  Name of column that contains old value(s) : @3  Condition which selects rows to change (optional):  @4ENDCBUILD KEY FOR @1 IN @2  BUILD KEY    $  Use BUILD KEY to create a key index for a column.  You need to specify<  the table name and the name of the column to be indexed.@  Z  Name of column to index                 : @1t  Name of table that contains the column  : @2yENDCPROMPT CH@1   CHANGE    1  CHANGE values in a table  2  CHANGE the definition of a column   Enter a choice (1 or 2): @1 ENDCCHANGE @3 TO @1 IN @2 WHERE @4  CHANGE  $   Use CHANGE to change the value of a column to a new value.  ToH  change the value of a column in a single table, specify a table l  name.  To change the value of a column in all tables where that    column appears, leave out the table name.  You must include a   WHERE clause.     New value                                 : @1  Name of table to be modified              : @2  Name of column that contains old value(s) : @3  Condition which selects rows to be changed (required) :   @4ENDCCHANGE COLUMN @1 IN @2 TO @3 @4 @58  CHANGE COLUMN C   h  Use CHANGE COLUMN to change the definition of a column in a table.l    Name of column to change                    : @1  Name of table that contains the column      : @2  Name of column after the change (required)  : @3  New data type (if changing data type)       : @4  New length (if changing length of a   TEXT column or changing data type to TEXT)  : @5ENDC7DEFINE ; OWNER @1 ; PROMPT DCOLUMNS ?  COLUMNS G   K  n   R:BASE restricts database structure changes to users with the z	  owner password.   Enter your owner password (if none, type NONE) : @1     WARNING: Pressing [Return] is not a valid response to this           prompt for your user password. If you do not have           a user password, type NONE.ENDCCOLUMNS ; @1 ; @2 ; @3 ; @4 ; @5 ; @6 ; @7 ; PROMPT DMODE   COLUMNS )   M  You may enter up to seven column definitions in the table below:i                 Column   Column   Length     Key                  Name     Datatype (optional) (optional)
  Definition 1:  @1 
  Definition 2:  @2 
  Definition 3:  @3 
  Definition 4:  @4 
  Definition 5:  @5 
  Definition 6:  @6 
  Definition 7:  @7 ENDCCOMPUTE @3 @2 FROM @1 WHERE @4  COMPUTE    J$  Use COMPUTE to calculate either the count, minimum, maximum, average, l  sum, rows or all of these values for the column you specify.p    Name of table that contains column                  : @1  Name of column that contains values                 : @2  SUM, AVE, COUNT, MAX, MIN, ALL or ROWS              : @3  Condition with which to select rows (optional) :  @4ENDCDEFINE @1@2@3 ; PROMPT DMODE  DEFINE  8   Use DEFINE to enter the define mode where you can set up a newW  database or add to the definition of an existing one. u  If you want to execute DEFINE without any arguments,  get the R> prompt and type DEFINE [Return]  Otherwise,  Volumename (if not the default volume)     : @1   Directory (if not the current directory)   : @2   Database name (required)                   : @3 ENDCDELETE @1 FOR @2 IN @3 WHERE @4   DELETE  F  Use DELETE to delete entire rows or duplicate rows from a table.j  It is also used to delete the key index for a specified column. n    Type of delete (ROWS, DUPLICATES, or KEY)                  : @1   For DELETE KEY name of column for which to delete KEY index: @2   Name of table used in this delete                          : @3 $  Conditions which select rows (required for ROWS, not permitted on the 
  other forms of DELETE) :  @4ENDC(
DISPLAY @1 IN @2@3@40  DISPLAY 8   Z  Use the DISPLAY command to display the contents of a commandk  file or of any ASCII file.o    Procedure name:                                     : @1  Volumename (if procedure not on default volume)     : @2  Directory (if procedure not on default directory)   : @3  Filename that contains procedure (required)         : @4	ENDC	
PROMPT ED@1 	  EDIT	  	8  Use the EDIT command to gain access to a table for browsing 	Y  through rows, changing or updating data, or deleting rows.	]  	r  Which display format do you want? 	  1  Customized dataentry form. (Choose only if a form is defined 	$      for the table you want to edit. Do not use with a variable form.) 	  2  Standard R:BASE format	  Enter a choice (1 or 2): @1 	ENDC	EDIT USING @1 SORTED BY @2 WHERE @3 	  EDIT	  	  Form name of the customized form            : @1	>  Sort order (optional list of column names)  : 	C  @2	_  Conditions by which select rows (optional)    : 	d  @3	iENDC	EDIT @2 FROM @1 SORTED BY @3 WHERE @4 	  EDIT	  	  Name of table to edit                      : @1 	  Name(s) of columns to edit (or ALL)        :	  @2	  Sort order (optional list of column names) :	  @3
  Conditions which select rows (optional)    :
  @4
ENDC
PROMPT EN@1 
  ENTER 
   
B  Use ENTER to add data to a table using a data entry form
e   you previously created for that table. (Do not use a variable 
o  entry form.)
s  
  Which way do you want to enter data?
  1  Enter from the keyboard 
  2  Enter from a file 
  Enter a choice (1 or 2): @1 
ENDC

ENTER @1 FOR @2 ROWS
  ENTER 
   
  Form name of the customized form : @1 

  Number of rows (required)        : @2 
ENDC

ENTER @1 FROM @2@3@4
  ENTER 
*   
F  Form name of the customized form           : @1 
b  Volumename (if not the default volume)     : @2 
  Directory (if not the current directory)   : @3 
  Filename (required)                        : @4 
ENDC
EXIT
  EXIT
  
  Use the EXIT command to leave R:BASE.   Press [G] to execute or press [Q] not to execute.   WARNING: Executing the EXIT command makes it necessary to restart H           R:BASE. Are you finished with your R:BASE session? MENDC\EXPAND @1 WITH @2 @3 @4 c  EXPANDj    Use EXPAND to add a new column to an existing table.    Name of table to expand              : @1   Name of new column                   : @2   Datatype of new column               : @3   Length of new column (for TEXT only) : @4 ENDCFORMS   FORMS 	     Use FORMS to create a custom entry form.0  Press [G] to execute. 5ENDC:HELP@  HELPF  k  The HELP mode does not have any parameters. Press [G] to execute. pENDCyINPUT @1@2@3  INPUT      The default input source for R:BASE commands and data is your keyboard. $  The source may be changed from your keyboard to a file with the INPUT   command.    Volumename (if not the default volume)     : @1   Directory (if not the current directory)   : @2 9  Name of command file to execute (required) : @3 >ENDCUINTERSECT @1 WITH @2 FORMING @3 USING @4^  INTERSECT g      The INTERSECT command combines rows from two tables to form a   new table. The resulting table contains the rows from both tables   that have common, matching column values. The two original tables   must share at least one column in common.     Name of first table         : @1  Name of second table        : @2  Name of new table           : @3N  List of column names to include in new table (optional) : S  @4XENDCvJOIN @1 USING @2 WITH @3 USING @4 FORMING @5 WHERE @6 |  JOIN    The JOIN command combines rows from two existing tables to form a   new table. The value of a column named in the first table is
   compared with the value of a column named in the second table.
  If the values of these two columns satisfy the condition you
F   specified, a row containing all the columns from the first two
[  tables is added to the new table. 
_  
z  First table name                          : @1
  Name of comparison column in first table  : @2
  Second table name                         : @3
  Name of comparison column in second table : @4
  Name of new relation                      : @5
  Comparison (EQ, NE, GT, GE, LT, or LE)    : @6
ENDC

LIST @1 
  LIST
  
=  Use the LIST command to list information about the open database
M
  or available databases. 
Q  
w  Type of listing (enter COLUMNS, DATABASES, FORMS, REPORTS, RULES, or
  TABLES): @1 
ENDC
PROMPT LO@1 
  LOAD
  
  Use LOAD to add data to a table, row by row, without using a data entry 
  form. From which source do you want to load data?   1  Load data from the keyboard   2  Load data from a file $  Enter a choice (1 or 2) : @1)ENDC6
LOAD @1 @2 USING @3 <  LOADB  V  Loading data from the keyboard. u  Name of table to load with data values            : @1  To be prompted for each value, enter WITH PROMPTS : @2  List of names of columns to load (optional) :   @3ENDCLOAD @1 FROM @2@3@4 AS @5 USING @6  LOAD    Loading data from a file.   Name of table to load with data            : @1   Volumename (if not the default volume)     : @2 >  Directory (if not the current directory)   : @3 Z  Name of file (required)                    : @4 s  If data on file is more than 80 characters  in length enter the keyword ASCII          : @5   List of table columns to load (optional)   :  @6ENDCOPEN @1@2@3   OPEN    Use the OPEN command to gain access to a previously defined   database. You can open one R:BASE database at a time. To setB  up a new database or modify an existing database, use P  the DEFINE command. T  p  Volumename (if not the default volume)     : @1   Directory (if not the current directory)   : @2   Existing database name (required)          : @3 ENDCOUTPUT @1@2@3 WITH @4   OUTPUT    The OUTPUT command directs messages and the results of commands to$  a file, printer, screen, or any combination of the three. The primary <$  output device can be a file, the PRINTER, or the SCREEN. The secondaryc$  device, if any, can be the PRINTER, the SCREEN, or BOTH. Messages and   output continue to go to the devices you specify until you enter another	  OUTPUT command.     Volumename (if not the default volume)               : @1   Directory (if not the current directory)             : @2   Primary output device (SCREEN, PRINTER, or filename) : @3   Optional secondary output device(s) (SCREEN, PRINTER, or BOTH) :*  @4ENDC6OWNER @1=  OWNER D   k$  The OWNER command is used within the DEFINE module for specifying the   owner password for a database.    Owner password : @1 ENDCPACK @1@2@3   PACK    Use the PACK command to recover disk space that originally contained  database information. When information is removed with the REMOVE or$  DELETE command, the disk space that was occupied by the information is6  unusable until PACK or RELOAD is executed.:  a$  Use COPY to make a backup copy of the database before executing PACK.e    Volumename (if not the default volume)     : @1   Directory (if not the current directory)   : @2   Name of database to pack                   : @3 ENDCDEFINE ; OWNER @1 ; PROMPT DPASSWORDS   PASSWORDS    '  R:BASE restricts password changes to users with the owner password. E  Enter your owner password (if none, type NONE) : @1 I  j  WARNING: Pressing [Return] is not a valid response to this           prompt for your user password. If you do not have           a user password, type NONE.ENDCPASSWORDS ; @2 FOR @1 IS @3 ; PROMPT DMODE  PASSWORDS      RPW stands for read password, MPW stands for modify password.     Name of table to be protected : @1  Password type (RPW or MPW)    : @2>  User password (eight or less characters) : @3 CENDCUPRINT @1 SORTED BY @2 WHERE @3\  PRINT c     Use the PRINT command to generate a report defined in the REPORTS mode. $  The report will be output to the device(s) you specified in your last 	  OUTPUT command.     Name of report : @1   Sort order (optional list of column names) :  @2  Condition by which selects rows (optional)   :  @3ENDCBPROJECT @2 FROM @1 USING @3 SORTED BY @4 WHERE @5 J  PROJECT R   y$  Use the PROJECT command to create a new table from an existing table.   The new table can be either an identical copy of the original table   or a subset of the original table.    Name of old table                          : @1   Name of new table                          : @2 
  Names of columns to include (or ALL)       :  @3)  Sort order (optional list of column names) :.  @4H  Condition which selects rows (optional)    :M  @5RENDCXRBEDIT_  RBEDITf    Use RBEDIT to create or edit small text and command files   within R:BASE.    Press [G] to execute. ENDCRELOAD @1@2@3   RELOAD    Use RELOAD to make a copy of the currently open database, without   copying unusable disk space.  When information is removed with theK  REMOVE or DELETE command, the disk space that was occupied by the p  information is unusable until RELOAD or PACK is executed.  The two  databases must have different names if they are to be on the same   volume.     Volumename (if not the default volume)(e.g., [d0])      : @1  Directory (if not the current directory)(e.g., <mydir>) : @2  New database name (required if on same volume)          : @3ENDCPROMPT RE@1   REMOVE  1  1  An entire table E  2  A single column from a tableW  Enter a choice (1 or 2): @1 \ENDCdREMOVE @1 k  REMOVEr    Use REMOVE to delete a table, its definition, and all of its data 
  from the database.    Name of table to remove from the database : @1ENDCREMOVE COLUMN @1 FROM @2  REMOVE COLUMN      Use REMOVE COLUMN to delete a single column from a table.   7  Column name to remove : @1H  Table name            : @2MENDC[REN @1 @3 TO @4 IN @2 b  RENAMEi     Use the RENAME command to change the name of a table, a column   or the owner password. To change the name of a column in only   one table, specify the table name.    Type of rename (TABLE, OWNER, or COLUMN)  : @1  If renaming COLUMN for one table only, name of table : @2   Old name : @3   New name : @4 ENDCREPORTS .  REPORTS 6   U  The REPORTS command enters the report definition mode.Y  h  Press [G] to execute. mENDCDEFINE ; OWNER @1 ; PROMPT RU@2   RULES      Use RULES to define data entry and modification rules.     R:BASE restricts changes of data entry and modification rules   to users with the owner password.   Enter your owner password : @1    WARNING: Pressing [Return] is not a valid response to thisC           prompt for your user password. If you do not haveY           a user password, type NONE.]  u  Which kind of rule do you want to enter?  1  Enter a range checking rule (value built into the rule)   2  Enter a table checking rule (value exists in a table)   Enter a choice (1 or 2): @2 ENDCRULES ; @1 @2 IN @3 @4 @5 ; PROMPT DMODE  RULES      Message to be displayed when invalid data is entered :  @1  Name of column to validate : @2 A  Name of table to validate  : @3 g  Comparison test (EQ, NE, GT, GE, LT, LE, CONTAINS, EXISTS, FAILS) : l  @4{  Comparison value : @5 ENDCRULES ; @1 @2 IN @3 @4 @5 IN @6 ; PROMPT DMODE  RULES      Message to be displayed when invalid data is entered :  @1  Name of column to validate                      : @2  Name of table to validate                       : @3=  Comparison test (EQA, NEA, GTA, GEA, LTA, LEA)  : @4[  Name of column that contains comparison values  : @5y  Name of table that contains comparison column   : @6ENDC
RUN @1 IN @2@3@4 USING @5   RUN      Use RUN to execute an R:BASE command file or macro.     Name of procedure to run : @1   Enter the procedure file that contains the command file if the file   is not in the current procedure file. (  Volumename (if not the default volume)      : @2D  Directory (if not the current directory)    : @3  Filename that contains procedure            : @4  List of procedure parameters (up to nine, separated by blanks) :  @5ENDCSELECT @2 FROM @1 SORTED BY @3 WHERE @4   SELECT     Use the SELECT command to retrieve data from a table. Specify    the table and the columns. To display all columns, enter ALL. $   To sum a column, add =S to the column name.  To set a display F  width for a column, add =w to the column name, where w is a U  number from 1 to 256. Y  l  Name of table to display : @1   Name(s) of columns to display (or ALL) :  @2  Sort order (optional list of column names) :  @3  Condition that selects rows to display (optional) :   @4ENDCPROMPT ST@1   SET      Use the SET command to change the current status of keyword   settings or special characters.   B   Keyword values can be set for USER, DATE, LINES, WIDTH, ECHO,   CASE, RULES, NULL, BELL, AUTOSKIP, REVERSE, MESSAGE,p
  CLEAR, MULTI, or ESCAPE.t  $  Special characters are:  BLANK, COMMA, DOLLAR, SEMI, QUOTES, and PLUS.    1  SET R:BASE KEYWORD  2  SET Special Character   Enter a choice (1 or 2): @1 ENDCSET @1 @2   SET      R:BASE status keywords are : DATE, USER, NULL, LINES, WIDTH, ECHO,J  CASE, RULES, BELL, AUTOSKIP, REVERSE, MESSAGE, CLEAR, MULTI, andR  ESCAPE. V  a  Keyword   : @1l  New value : @2qENDCySET @1=@2   SET      Special characters names are: BLANK, COMMA, DOLLAR, SEMI, QUOTES,   and PLUS.     Special character name    : @1  New value (one character) : @2ENDCSHOW @1   SHOW    Use the SHOW command to display the current status of system;  parameters and default conditions defined with the SET command. ?  e  Enter one of these R:BASE status keywords: DATE, USER, NULL, LINES,   WIDTH,  ECHO, CASE, RULES, BELL, AUTOSKIP, REVERSE, MESSAGE,
  CLEAR, MULTI, or ESCAPE.    Keyword for status display : @1 ENDCSUBTRACT @1 FROM @2 FORMING @3 USING @4   SUBTRACT     Use the SUBTRACT command to find rows in one table that do not'  match rows in another table, based on the values of common columns. B  Nonmatching rows are added to the new table. F  U  First table name  : @1d  Second table name : @2s  Name of new table : @3  List of column names to include in new table (optional) :   @4ENDCDEFINE ; OWNER @1 ; PROMPT DTABLES  TABLES     R:BASE restricts database structure changes to users with the 	  owner password.   Enter your owner password : @1  '  WARNING: Pressing [Return] is not a valid response to thisH           prompt for your user password. If you do not have^           a user password, type NONE.cENDCwTABLES ; @1 WITH @2 ; PROMPT DMODE  TABLES    Name of the new table : @1  List of column names to include in the new table :  @2ENDC
TALLY @1 FROM @2 WHERE @3   TALLY    *  Use the TALLY command to count how many values in a column are identical. M   TALLY displays each unique value and how many times it occurs.Q  m  Name of column to tally                     : @1  Name of table that includes column to tally : @2  Condition which selects rows to include in the tally (optional) :   @3ENDCUNION @1 WITH @2 FORMING @3 USING @4  UNION      UNION combines two tables and their matching columns, forming a $  third new table that contains all the rows and columns of the two I  original tables. You can select specific columns to appear in the n  new table with the optional column name list. Rows from each table  that have no matching values in the other table are included and  given null values in the new table.   
  First table name   : @1 
  Second table name  : @2 
  Name of new table  : @3   List of column names to include in new table (optional) :   @4ENDCUSER @1 ; PROMPT UN@2    UNLOAD'  M  Use the UNLOAD command to convert data and definitions into formats q  that can be processed by other programs or machines. UNLOAD also  transfers tables from one database to another.    R:BASE restricts the ability to unload a database to users with the 	  owner password.     WARNING: Pressing [Return] is not a valid response to this           prompt for your user password. If you do not have           a user password, type NONE.  5  Enter your owner password : @19  O  What is the purpose of this unload? c  1  Unload for reload to R:BASE |  2  Unload for transfer to another system   Enter a choice (1 or 2) : @2ENDCUNLOAD @1 FOR @2 USING @3 SORTED BY @4 WHERE @5   UNLOAD    How much to unload (DATA, SCHEMA, or ALL) : @1  Table name (do not use if you are unloading entire database) : @2 $   Name(s) of columns to unload (optional list of column names) :)  @3C  Sort order (optional list of column names) :H  @4e  Condition that selects rows to unload (optional) :j  @5oENDCUNLOAD DATA FOR @1 AS @2 @3 @4 USING @5 SORTED BY @6 WHERE @7   UNLOAD  	  Table name : @1   Format of unloaded file (ASCII, DIF, or MPLAN) : @2   If MULTIPLAN format, spreadsheet row           : @3   If MULTIPLAN Format, spreadsheet column        : @4 (   Name(s) of columns to unload (optional list of column names) :  @5G  Sort order (optional list of column names) :L  @6i  Condition that selects rows to unload (optional) :n  @7sENDCzUSER @1   USER  $  The USER command gives you an alternative to the SET USER command for   setting your current user password.     Enter your user password : @1 ENDCEND   END    6  The END command returns you from DEFINE mode to the PROMPT mode.:  I  Press [G] to execute. NENDCVPROMPT D@1b	  PROMPTED DEFINE n	     You are using prompts in the DEFINE mode.     To define columns, enter COLUMNS  To define a table after defining its columns, enter TABLES  To define tables, enter PASSWORDS   To leave the define module, enter END     Enter your choice: @1 ENDC