Use the SHOW command to display the status of system parameters, format conditions, and default conditions.
Options
CHARACTERS
Shows the current settings for the BLANK, DELIMIT, LINEEND, MANY, PLUS, QUOTES, SEMI, and SINGLE special characters.
keyword
Shows the current setting for the environment condition specified in the keyword option.
About the SHOW Command
Use any of the SET keywords in a SHOW command to display an environment setting. You can also display special characters and environment settings using Utilities: Settings.
The following commands are not displayed in a standard SHOW and must be requested manually.
Examples
The following command displays all characters and settings.
SHOW
The following command displays settings for the special characters BLANK, DELIMIT, LINEEND, MANY, PLUS, QUOTES, SEMI, and SINGLE.
SHOW CHARACTERS
The following command displays the status of rules checking.
SHOW RULES
The following command displays the current user identifier.
SHOW USER
The following command displays the front end build of the product.
SHOW BUILD
R:BASE for Windows
What follows is the output from a SHOW command in R:BASE for Windows
BLANK
DELIMIT ,
LINEEND þ
SEMI ;
QUOTES '
PLUS +
SINGLE _
MANY %
IDQUOTES `
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
TIME format HH:MM:SS
TIME sequence HHMMSS
LINES/page 20
WIDTH/line 79
TOLERANCE 0.
NULL symbol -0-
Lock WAIT time 2
Lock INTERVAL time (in .1 sec) 5
REFRESH TIME 0
MAXTRANS 10
EDIT verification level COLUMN
FILES 5
PRINTER
NOTE column PADding percentage 10
CURRENCY SYMBOL '$'
CURRENCY LOCATION PREF
CURRENCY DIGITS 2
CURRENCY CONVENTION B
(AND ) ON Use SQL precedence for ANDs and ORs
(ANSI ) ON ANSI SQL name restrictions
(AUTOCOMM ) OFF AUTOmatically COMMit after each command
(AUTOSKIP ) OFF AUTOmatically SKIP to the next field when editing
(BELL ) ON Sound the BELL on an error
(CAPTION ) ON Display caption on DIALOG, PAUSE
(CASE ) OFF Distinguish between UPPER and lower CASE
(CLEAR ) ON CLEAR data buffers after modifications
(DEBUG ) OFF Debug command is effective
(ECHO ) OFF ECHO input from command files
(EQNULL ) OFF Treat null EQual NULL as a match
(EOFCHAR ) ON Add EOF CHARacter to the end of output files
(ERROR ) ON Display ERROR messages during processing
(ESCAPE ) ON ESCAPE allowed to abort processing
(EXPLODE ) OFF Exploding windows on dialog boxes
(FEEDBACK ) OFF Display FEEDBACK status during command processing
(FIXED ) OFF Delete header space for SELECT
(HEADINGS ) ON Display column HEADINGS on SELECT and TALLY commands
(INSERT ) ON Use INSERT key as a toggle
(INTENSITY) ON Intensity field in form
(LAYOUT ) OFF Save the LAYOUT of data displayed on Browse/Edit
(MANOPT ) OFF Disable optimizer table reordering
(OLDLINE ) ON Use OLD style vertical LINE processing in reports
(ONELINE ) OFF Display only one line per row in select output
(MDI ) ON Default startup mode for forms will be MDI
(MESSAGES ) ON Display informational MESSAGES during processing
(MIRROR ) OFF Maintains MIRROR images of database files
(MULTI ) ON MULTI-user database access capability
(POSFIXED ) ON POSition DIALOG, PAUSE based on FIXED OEM font size
(REVERSE ) ON REVERSE video highlighting on data entry/edit
(ROWLOCKS ) ON ROW LOCK database access capability
(RULES ) ON Check data validation RULES
(SCRATCH ) ON SCRATCH files on same path as the database
(SORT ) OFF Optimize SORTing to minimize disk space used
(SORTMENU ) ON Sort menu items for selected menu types
(STATICDB ) OFF STATIC DataBase schema mode
(TRANSACT ) OFF Connect in TRANSACTion mode
(WALKMENU ) OFF Search menus based on multiple keystrokes
(WINBEEP ) OFF Use selected WINdows BEEPs for beep sound
(WRAP ) ON Word WRAP text for display and edit
(WRITECHK ) OFF Verify each WRITE to disk
(ZERO ) OFF Treat nulls as ZERO in numeric calculations
(ZOOMEDIT ) ON Convert LINEEND to CR and back on ZOOMed EDIT fields
R:BASE for DOS
What follows is the output from a SHOW command in R:BASE for DOS
BLANK
DELIMIT ,
LINEEND ^
SEMI ;
QUOTES '
PLUS +
SINGLE _
MANY %
IDQUOTES `
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
TIME format HH:MM:SS
TIME sequence HHMMSS
LINES/page 20
WIDTH/line 79
TOLERANCE 0.
NULL symbol -0-
Lock WAIT time 4
Lock INTERVAL time (in .1 sec) 5
REFRESH TIME 0
MAXTRANS 201
EDIT verification level COLUMN
FILES 5
PRINTER HPLASER1
NOTE column PADding percentage 10
CURRENCY SYMBOL '$'
CURRENCY LOCATION PREF
CURRENCY DIGITS 2
CURRENCY CONVENTION B
(AND ) ON Use SQL precedence for ANDs and ORs
(ANSI ) ON ANSI SQL name restrictions
(AUTOCOMM ) OFF AUTOmatically COMMit after each command
(AUTOSKIP ) OFF AUTOmatically SKIP to the next field when editing
(BELL ) ON Sound the BELL on an error
(CASE ) OFF Distinguish between UPPER and lower CASE
(CLEAR ) ON CLEAR data buffers after modifications
(DEBUG ) OFF Debug command is effective
(ECHO ) OFF ECHO input from command files
(EQNULL ) OFF Treat null EQual NULL as a match
(EOFCHAR ) ON Add EOF CHARacter to the end of output files
(ERROR ) ON Display ERROR messages during processing
(ESCAPE ) ON ESCAPE allowed to abort processing
(EXPLODE ) OFF Exploding windows on dialog boxes
(FEEDBACK ) OFF Display FEEDBACK status during command processing
(HEADINGS ) ON Display column HEADINGS on SELECT and TALLY commands
(INSERT ) ON Use INSERT key as a toggle
(LAYOUT ) OFF Save the LAYOUT of data displayed on Browse/Edit
(MANOPT ) OFF Disable optimizer table reordering
(OLDLINE ) ON Use OLD style vertical LINE processing in reports
(ONELINE ) OFF Display only one line per row in select output
(MDI ) ON Default startup mode for forms will be MDI
(MESSAGES ) ON Display informational MESSAGES during processing
(MIRROR ) OFF Maintains MIRROR images of database files
(MULTI ) ON MULTI-user database access capability
(REVERSE ) ON REVERSE video highlighting on data entry/edit
(ROWLOCKS ) ON ROW LOCK database access capability
(RULES ) ON Check data validation RULES
(SCRATCH ) ON SCRATCH files on same path as the database
(SORT ) OFF Optimize SORTing to minimize disk space used
(SORTMENU ) ON Sort menu items for selected menu types
(STATICDB ) OFF STATIC DataBase schema mode
(TRANSACT ) OFF Connect in TRANSACTion mode
(WALKMENU ) OFF Search menus based on multiple keystrokes
(WRAP ) ON Word WRAP text for display and edit
(WRITECHK ) OFF Verify each WRITE to disk
(ZERO ) OFF Treat nulls as ZERO in numeric calculations
(ZOOMEDIT ) ON Convert LINEEND to CR and back on ZOOMed EDIT fields
