o Controls the DEC DATATRIEVE response to ABORT statements.
o Sets the keypad mode (application or numeric) within DEC
DATATRIEVE.
o Sets the maximum number of columns per page for DEC DATATRIEVE
output.
o Establishes your default directory in the Oracle
CDD/Repository data dictionary.
o Determines whether DEC DATATRIEVE creates a DTREDIT.DTR backup
file when you edit dictionary objects.
o Determines whether DEC DATATRIEVE uses its forms interface to
control the video display of your terminal.
o Starts DEC DATATRIEVE Guide Mode.
o Determines whether DEC DATATRIEVE recognizes null values of
relational databases.
o Permits or inhibits automatic syntax prompting for continued
commands and statements.
o Permits or inhibits creation of an implicit inner print
list in a PRINT statement and an implicit ANY in a Boolean
expression.
o Determines whether a semicolon is required at the end of each
command or statement.
o Controls whether commands and statements in command files are
displayed when the command file is invoked
Format
{ [NO] ABORT }
{ [NO] APPLICATION_KEYPAD }
{ COLUMNS_PAGE=n }
{ }
{ [NO] CDD }
{ DICTIONARY path-name }
{ [NO] EDIT_BACKUP }
{ [NO] FORM }
{ }
{ [NO] GRID }
{ GUIDE [ADVANCED] }
{ KEYDEFS file-spec }
SET { } [,...]
{ [NO] LOCK_WAIT }
{ [NO] NULLS }
{ PLOTS path-name }
{ }
{ [NO] PROMPT }
{ [NO] SEARCH }
{ [NO] SEMICOLON }
{ }
{ [NO] VARIABLES PROCEDURES }
{ [NO] VERIFY }
{ NOVERIFY }
{ }
To change settings for HELP:
{ [NO] HELP_PROMPT }
SET { [NO] HELP_WINDOW } [,...]
{ HELP_LINES n TO m }
{ }
1 – Arguments
ABORT
Causes DEC DATATRIEVE to abort the remainder of a procedure or
command file when DEC DATATRIEVE executes an ABORT statement,
when you enter a CTRL/Z to a prompt, or when a syntax or logical
error occurs during the execution of a command or statement.
The exception to the logical error condition is the DELETE
command. If you list two or more objects as arguments for the
DELETE command, DEC DATATRIEVE does not abort if it fails to find
an object of a specified name. Instead, DEC DATATRIEVE continues
to delete the remaining objects in the list.
NO ABORT
Causes DEC DATATRIEVE, when processing a procedure or a command
file, to abort only the one statement containing an ABORT
statement. SET NO ABORT also causes DEC DATATRIEVE to take the
same action when you respond with a CTRL/Z to a prompt in a
procedure or command file. DEC DATATRIEVE then executes the next
command or statement in the procedure or command file. SET NO
ABORT is in effect when you start a DEC DATATRIEVE session.
APPLICATION_KEYPAD
Sets the keypad mode as application keypad within DEC DATATRIEVE.
The default keypad mode for DEC DATATRIEVE is numeric keypad
mode.
You can also set the keypad mode using the function FN$KEYPAD_
MODE.
This command is not available in a DECwindows Motif environment.
NO APPLICATION_KEYPAD
Sets the keypad mode as numeric keypad within DEC DATATRIEVE.
The default keypad mode for DEC DATATRIEVE is numeric keypad
mode.
You can also set the keypad mode using the function FN$KEYPAD_
MODE.
This command is not available in a DECwindows Motif environment.
COLUMNS_PAGE = n
Establishes the number of columns per page for DEC DATATRIEVE
output and the default page width for the Report Writer. When you
start your session, the default COLUMNS_PAGE setting is 80.
To set the terminal's width, use the DEC DATATRIEVE function
FN$WIDTH.
DICTIONARY path-name
Causes DEC DATATRIEVE to set your default directory node of the
Oracle CDD/Repository data dictionary to the node specified by
the dictionary path name. When you start your DEC DATATRIEVE
session, your default Oracle CDD/Repository directory is
either CDD$TOP or the directory designated by the logical name
CDD$DEFAULT.
SET DICTIONARY accepts both DMU and CDO style path names.
EDIT_BACKUP
Causes DEC DATATRIEVE to save the original definition in the
Oracle CDD/Repository data dictionary when you use the EDIT
command to edit a dictionary object. When you start your DEC
DATATRIEVE session, SET EDIT_BACKUP is in effect. Use the SHOW
EDIT command to see whether or not SET EDIT_BACKUP is currently
in effect.
NO EDIT_BACKUP
Causes DEC DATATRIEVE to delete the highest version of the object
in the Oracle CDD/Repository data dictionary, or the version you
specify, and replace it with the definition in the edit buffer
when you use the EDIT command to edit a dictionary object.
FORM
Determines whether DEC DATATRIEVE uses its forms interface when
you use the PRINT, MODIFY, and STORE statements. For terminals
supported by the forms product you are using, SET FORM causes
DEC DATATRIEVE to display and use forms when you enter the PRINT,
MODIFY, or STORE statement.
When you start your DEC DATATRIEVE session, SET FORM is in
effect.
NO FORM
Prevents DEC DATATRIEVE from using its forms interface. If SET
NO FORM is in effect when you use the PRINT, MODIFY, or STORE
statements, DEC DATATRIEVE does not use the forms interface.
GRID
Causes a client application (DEC DATATRIEVE Client for Windows or
programs calling DEC DATATRIEVE) to display the output of a PRINT
statement on the grid (Dataset Viewer). If the output is directed
to a file, that file contains all the necessary tab characters
that make it readable by other PC applications (e.g. Excel[R]).
This command is for client applications only, and it's ignored by
the DEC DATATRIEVE server if this is not connected to a client.
NO CDD
Specifies whether DEC DATATRIEVE should attach to Oracle CDD/Repository
or use textfile-based dictionary only. When this qualifier is missing,
the DEC DATATRIEVE behaviour depends on the equivalent string of
the logical name DTR$ENVIRONMENT: if the equivalent string contains
/NOCDD , no attachment to Oracle CDD/Repository occurs.
If DTR$ENVIRONMENT is not defined, the DEC DATATRIEVE behaviour depends
on the configuration selected at installation time.
If Oracle CDD/Repository is linked to DEC DATATRIEVE at installation time
its use can dynamically be disabled using the DATATRIEVE SET NO CDD
command, which switches to the textfile-based dictionary.
NO GRID
Causes a client application (DEC DATATRIEVE Client for Windows or
programs calling DEC DATATRIEVE) to display the output of a PRINT
statement on the Output window. SET NO GRID is the default. This
command is for client applications only, and it is ignored by the
server if this is not connected to a client.
GUIDE
Starts Guide Mode, the tutorial mode of DEC DATATRIEVE. Refer to
the DEC DATATRIEVE User's Guide for a description of Guide Mode.
KEYDEFS file-spec
Lets you define multiple keypad keys from a file containing
DCL DEFINE/KEY commands (see the OpenVMS documentation for more
information on the DEFINE/KEY command). By using SET KEYDEFS, you
do not have to make multiple calls to the FN$DEFINE_KEY function.
The file specification is the full DCL file specification for the
file containing the DCL DEFINE/KEY commands.
This command is not available in a DECwindows Motif environment.
LOCK_WAIT
When two applications try to access the same file, RMS may lock a
record that DEC DATATRIEVE needs to access. DEC DATATRIEVE tries
for 12 seconds to access a locked record. SET LOCK_WAIT causes
DEC DATATRIEVE to turn control over to RMS after this period. RMS
then waits for the locked record until it is released, or until
RMS sends you a deadlock message. The default is SET NO LOCK_
WAIT.
NO LOCK_WAIT
Instructs DEC DATATRIEVE not to try to access a locked record
after 12 seconds. At the end of this period, you receive an RMS
message informing you that the record is locked. When you begin
your DEC DATATRIEVE session, SET NO LOCK_WAIT is in effect.
NULLS
When the you issue a SET NULLS command, DEC DATATRIEVE recognizes
null values of relational databases as such. SET NULLS is the
default.
NO NULLS
When you issue a SET NO NULLS command, DEC DATATRIEVE does
not recognize null values of relational databases as such,
it returns the type-dependent default values of relational
databases. You can examine the current condition with the SHOW
SET_UP command.
PLOTS
Establishes the default Oracle CDD/Repository DMU data dictionary
directory for your DEC DATATRIEVE plot definitions.
PROMPT
Causes DEC DATATRIEVE to prompt for elements needed to complete
the syntax of the current command or statement. When you press
the RETURN key before completing a command or statement, DEC
DATATRIEVE prompts you for the next syntactic element of that
statement or command. The prompt takes the following form:
[Looking for element]
At the start of a DEC DATATRIEVE session, SET PROMPT is in
effect.
NO PROMPT
Prevents DEC DATATRIEVE from prompting for elements needed to
complete the syntax of the current command or statement.
SEARCH
Causes the DEC DATATRIEVE Context Searcher to create implicit
inner print lists in PRINT statements and implicit ANYs in
Boolean expressions. When you work with Oracle CODASYL DBMS
domains, the SET SEARCH command causes the DEC DATATRIEVE Context
Searcher to walk sets to look for a context to resolve references
to field names.
NO SEARCH
Prevents the DEC DATATRIEVE Context Searcher from creating
implicit inner print lists in PRINT statements and implicit ANYs
in Boolean expressions. At the start of a DEC DATATRIEVE session,
SET NO SEARCH is in effect.
SEMICOLON
Causes DEC DATATRIEVE to require a semicolon at the end of
commands or statements.
NO SEMICOLON
Causes DEC DATATRIEVE to make semicolons at the end of commands
or statements optional. At the start of a DEC DATATRIEVE session,
SET NO SEMICOLON is in effect.
VARIABLES PROCEDURES
Allows you to use variables as procedures: you can store in a
DEC DATATRIEVE variable commands and statements. You can then
execute the variable as if it was a procedure. Variables declared
as procedures are not stored in the Oracle CDD/Repository.
NO VARIABLES PROCEDURES
Causes variables to be interpreted as variables and not as
procedures. At the start of your DEC DATATRIEVE session, SET
NO VARIABLES PROCEDURES is the default.
VERIFY
Causes lines from command files to be displayed when a command
file is invoked.
NO VERIFY
Suppresses the display of lines from command files when a command
file is invoked. At the start of your DEC DATATRIEVE session, the
current setting for SET VERIFY/NOVERIFY at the DCL level is in
effect.
HELP_PROMPT
Causes DEC DATATRIEVE to prompt for the topic or subtopic when
help text is displayed.
NO HELP_PROMPT
Suppresses the prompting for the topic or subtopic when help text
is displayed.
HELP_WINDOW
Causes help text to be displayed in a scrolling region of a video
terminal.
NO HELP_WINDOW
Causes help text to be displayed in a nonscrolling region of a
video terminal.
HELP_LINES n TO m
Sets the lines for scrolling help text between lines n and m,
where n represents the beginning of the scrolling region and m
represents the end.
2 – Examples
The following example displays the default settings and change
the default settings with one SET statement:
DTR> SHOW SET_UP
Set-up:
Columns_page: 80
No abort
Prompt
No search
Form
No verify
No semicolon
No lock_wait
NULLs support
Application keypad mode
DTR> SET COLUMNS_PAGE = 132, ABORT, NO PROMPT, SEARCH,
[Looking for SET option]
CON> 9 NO FORM, VERIFY, SEMICOLON, LOCK_WAIT, NO APPLICATION_KEYPAD
DTR>SHOW SET_UP
Set-up:
Columns_page: 132
Abort
No prompt
Search
No form
Verify
Semicolon
Lock_wait
NULLs support
Numeric keypad mode
DTR>
The following example sets your default dictionary directory at
CDD$TOP and uses a variety of path names to change your default
directory:
DTR> SET DICTIONARY CDD$TOP
DTR> SET DICTIONARY DTR$LIB.DEMO
DTR> SHOW DICTIONARY
The default directory is CDD$TOP.DTR$LIB.DEMO
DTR> SHOW DICTIONARIES
Dictionaries:
DTR> SET DICTIONARY -.-;
DTR> SHOW DICTIONARY
The default directory is CDD$TOP
DTR> SET DICTIONARY CDD$TOP.DTR32
Element "CDD$TOP.DTR32.JONES" not found in dictionary.
DTR> SET DICTIONARY CDD$TOP.DTR32.TEST
DTR> SHOW DICTIONARIES
Dictionaries:
DTR> SET DEF -; SHOW DICTIONARY
The default directory is CDD$TOP.DTR32
DTR> SHOW DICTIONARIES
Dictionaries:
AWS BRADS BRENT DBF
DDD DEMO DENN DETRIC
DUNCAN JAS KELLERMAN LANDAU
MARISON PLOTS STRONG TEST
WAYNE
DTR> SET DICTIONARY WAYNE
DTR> SET DICTIONARY DISK1:[SWANSON.DTRWORK]TEST.NEWDICT
DTR>
The following example uses the SET SEARCH command to walk sets in
a Oracle CODASYL DBMS database:
DTR> READY SUPPLIES, VENDORS, PART_S
DTR> SET SEARCH
DTR> PRINT VEND_NAME, PART_DESC OF
[Looking for name of domain, collection, or list]
CON> VENDORS WITH VEND_NAME = "QUALITY COMPS"
Not enough context. Some field names resolved by Context Searcher.
--------------Vendor Name---------------
QUALITY COMPS
VT100 KEYBOARD ASSY
NUMERIC KEYPAD FRAME
VT52 HOUSING
When SET SEARCH is not in effect, you need to provide explicitly
the inner print lists to give DEC DATATRIEVE the necessary
context, as follows:
DTR> SET NO SEARCH
DTR> PRINT VEND_NAME, ALL ALL PART_DESC OF PART_S OWNER OF
[Looking for set name]
CON> PART_INFO OF SUPPLIES MEMBER OF VENDOR_SUPPLY OF
[Looking for name of domain, collection, or list]
CON> VENDORS WITH VEND_NAME = "QUALITY COMPS"
--------------Vendor Name---------------
QUALITY COMPS
VT100 KEYBOARD ASSY
NUMERIC KEYPAD FRAME
VT52 HOUSING
DTR>