(B)0[m[4mSET[m wq> [4mCOMMAND[m qwq> [4mEXECUTE[m qqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
x mq> [4mNOEXECUTE[m qqj x
tq> [4mDATE_FORMAT[m wq> [4mDATE[m date-number wqqqqqqqqqqq>qqqqqqqqqwqu
x x mq> [4mTIME[m time-number qj x
x mq> [4mTIME[m time-number wqqqqqqqqqqq>qqqqqqqqqwqu
x mq> [4mDATE[m date-number qj x
tq> [4mDICTIONARY[m qqq> path-name qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
tq> [4mEDIT[m qqqwqq> [4mKEEP[m qqq> n qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
x tqq> [4mNOKEEP[m qqqqqqqu x
x mqq> [4mPURGE[m qqqqqqqqj x
tq> [4mLANGUAGE[m language-name qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
tq> [4mLINE_LENGTH[m qqqq> n qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
tq> [4mOUTPUT[m qqqqwqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqu
x mqq> file-spec qqqj x
tq> [4mNOOUTPUT[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
tq> [4mRADIX_POINT[m radix-char qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
tq> [4mVERIFY[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
mq> [4mNOVERIFY[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
Changes the characteristics of RDO terminal sessions. You can
control:
o The execution of RDO data manipulation statements
o The display format for date values
o The number of statements to be included in the editing buffer
o The language to be used for date and time input and display
o The line length for RDO output (limited to 512 bytes)
o The default directory in the data dictionary
o The file in which the session is recorded
o The character representing the radix point in output displays
o The display of statements from a command file
1 – More
If you have invoked a database, you have the necessary privileges
to use the SET statement.
2 – COMMAND
Specifies whether data manipulation queries you enter in an RDO
session are executed (SET COMMAND EXECUTE) or not executed (SET
COMMAND NOEXECUTE). SET COMMAND EXECUTE is the default.
2.1 – EXECUTE
Instructs RDO to execute the data manipulation statements you
issue in an interactive RDO session.
The SET COMMAND EXECUTE statement is available only in RDO.
2.2 – NOEXECUTE
Instructs RDO not to execute the data manipulation statements you
issue in an interactive RDO session. You can use the NOEXECUTE
option in conjunction with RDMS$DEBUG_FLAGS to examine the
estimated cost and access strategy associated with a query.
Although the query will not be executed, the access strategies
will still be displayed. See the Oracle Rdb Guide to Database
Maintenance and Performance for information on using RDMS$DEBUG_
FLAGS.
The SET COMMAND EXECUTE statement is available only in RDO.
3 – DATE_FORMAT
Specifies the output display format for date values. The date-
number argument corresponds to numbers in the date format logical
names used in the OpenVMS Run-Time Library routines.
Example:
RDO> SET DATE_FORMAT DATE 6
4 – DICTIONARY
Changes your default data dictionary to the path name you
specify.
Example:
RDO> SET DICTIONARY 'DISK1:[DICTIONARY]CORP.DEPT3'
5 – EDIT
Controls the size of the editing buffer that you create when you
use the EDIT statement with a wildcard as the parameter:
SET EDIT KEEP n Keep the previous n statements. Default: 20.
SET EDIT NOKEEP Do not save previous commands as they are
typed.
SET EDIT PURGE Continue to save commands, but purge buffer
now
6 – LANGUAGE
Changes the language to be used in date and time input and
display. Valid entries for the language-name argument are the
names of the collating sequences used by the OpenVMS National
Character Set Utility.
Example:
RDO> SET LANGUAGE FRENCH
7 – LINE LENGTH n
Sets the line length for RDO output. Use this option to specify
an alternate width when output is going to a file or alternate
output device. You can specify any number for n up to 512.
You can put a pair or set of SET LINE_LENGTH statements into a
nested FOR loop to change the line length during the loop.
8 – OUTPUT
Names the default target for output. The default file type is
LIS.
If you specify SET OUTPUT with a file name, RDO writes its output
to a log file that you specify. The output is also written to
SYS$OUTPUT, which is usually the terminal. If you do not specify
a file name, RDO writes the output only to SYS$OUTPUT. The log
file contains both statements and results. SET OUTPUT lets you
check the results of command procedures run in batch mode.
Example:
RDO> SET OUTPUT DISK2:[DEPT3]PERSONNEL.LOG
9 – NOOUTPUT
Closes the log file you named in the SET OUTPUT statement.
10 – RADIX_POINT
Changes the output displaying the radix point to the specified
character. The radix point is the symbol that separates units
from decimal fractions. For example, in the number 98.6, the
period is the radix point.
Example:
RDO> SET RADIX_POINT ,
11 – VERIFY
If you specify SET VERIFY, RDO displays indirect command files at
your terminal as you run them.
If you specify SET NOVERIFY, RDO does not display indirect
command files. NOVERIFY is the default setting.