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:
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.