Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

ALL_CONSTRAINTS

TRANSACTION

CURRENCY to DIGIT

EDIT to VERIFY

RDB/VMS SQL SET — VMS RDB_3.1A

 SET +> CURRENCY SIGN currency-char -----------------------------+>
     +> DATE FORMAT +> DATE date-number -+------------>---------++
     |              |                    +->,  TIME time-number +|
     |              +> TIME time-number -+------------>---------++
     |                                   +->,  DATE date-number +|
     +> DICTIONARY --> path-name --------------------------------+
     +> DIGIT SEPARATOR digit-sep-char --------------------------+
     +> EDIT ---+--> KEEP ---> n --+-----------------------------+
     |          +--> NOKEEP -------+                             |
     |          +--> PURGE --------+                             |
     +> LANGUAGE language-name ----------------------------------+
     +> OUTPUT ----+-------->--------+---------------------------+
     |             +--> file-spec ---+                           |
     +> NOOUTPUT ------------------------------------------------+
     +> RADIX POINT radix-char ----------------------------------+
     +> VERIFY --------------------------------------------------+
     +> NOVERIFY ------------------------------------------------+

Additional information available:

ALL_CONSTRAINTSTRANSACTION

CURRENCY to DIGITEDIT to VERIFY

ALL_CONSTRAINTS

 Type HELP SET_ALL_CONSTRAINT at the SQL> prompt for help on SET
 ALL CONSTRAINTS.

CURRENCY to DIGIT

 SET CURRENCY SIGN specifies the character SQL displays for the
 dollar sign ($) edit string character in column definitions.

 SET DATE FORMAT specifies the input and display format for
 either date values, time values, or both.

 SET DICTIONARY changes your default data dictionary dictionary
 directory to the path name you specify.

 SET DIGIT SEPARATOR specifies the character SQL displays for the
 comma (,) edit string character in column definitions.

EDIT to VERIFY

 SET EDIT controls the size of the editing buffer that you create
 when you use the EDIT statement with a wildcard as the argument.
 The default is 20.  SET EDIT NOKEEP is equivalent to SET EDIT
 KEEP 0.  If you use this form of the statement and you type EDIT
 or EDIT *, your editing buffer is empty.  SET EDIT PURGE retains
 the value of the KEEP parameter but purges all the previous
 statements.

 SET LANGUAGE changes the language to be used for month
 abbreviations in date and time input and display.

 SET OUTPUT file-spec starts a log file of the SQL statements you
 issue and their results.  SET NOOUTPUT suspends writing to the
 output file.

 SET RADIX POINT specifies the character SQL displays for the
 decimal point (.) edit string character in column definitions.

 SET VERIFY displays indirect command files at your terminal as
 you run them.  SET NOVERIFY disables display or indirect command
 files.  NOVERIFY is the default setting.

TRANSACTION

 Type HELP SET_TRANSACTION at the SQL> prompt for help on SET
 TRANSACTION.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026