RDB/VMS SQL SET — VMS RDB_4.1A
SET +> CURRENCY SIGN currency-char ----------------------+>
+> set-date-format ----------------------------------+
+> DICTIONARY --> path-name -------------------------+
+> DIGIT SEPARATOR digit-sep-char -------------------+
+> set-edit -----------------------------------------+
+> EXECUTE ------------------------------------------+
+> NOEXECUTE ----------------------------------------+
+> LANGUAGE language-name ---------------------------+
+> LINE LENGTH --> n --------------------------------+
+> set-output ---------------------------------------+
+> NOOUTPUT -----------------------------------------+
+> QUERY CONFIRM ------------------------------------+
+> QUERY LIMIT -+-> ROWS total-rows ---------------+-+
| +-> TIME total-seconds ------------+ |
+> RADIX POINT radix-char ---------------------------+
+> VERIFY -------------------------------------------+
+> NOVERIFY -----------------------------------------+
+> set-warning --------------------------------------+
+> DEFAULT CONSTRAINT MODE --+--------+-> ON --+-----+
+> FLAGGER ------------------+ +-> OFF -+
Additional information available:
ALIASALL_CONSTRAINTSANSICATALOGCONNECTDATE
SCHEMATRANSACTION
set date formatset editset outputset warningCURRENCY SIGN to DIGIT
EDIT to WARNING
set date format
set-date-format=
----> DATE FORMAT +> DATE date-number -+------------>---------++->
| +->, TIME time-number +|
+> TIME time-number -+------------>---------++
+->, DATE date-number +
set edit
set-edit=
--> EDIT ---+--> KEEP ---> n --+-->
+--> NOKEEP -------+
+--> PURGE --------+
set output
set-output=
----> OUTPUT ----+-------->--------+--->
+--> file-spec ---+
set warning
set-warning=
----> WARNING -+-> DEPRECATE ---+----->
+-> NODEPRECATE -+
ALIAS
Type HELP SET_ALIAS at the SQL prompt for help on SET ALIAS.
ALL_CONSTRAINTS
Type HELP SET_ALL_CONSTRAINT at the SQL> prompt for help on SET ALL CONSTRAINTS.
ANSI
Type HELP SET_ANSI at the SQL prompt for help on SET ANSI DATE, SET ANSI IDENTIFIERS, or SET ANSI QUOTING.
Additional information available:
DATE
Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI DATE.
IDENTIFIERS
Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI IDENTIFIERS.
QUOTING
Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI QUOTING.
CATALOG
Type HELP SET_CATALOG at the SQL prompt for help on SET CATALOG.
CONNECT
Type HELP SET_CONNECT at the SQL prompt for help on SET CONNECT.
CURRENCY SIGN 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 DEFAULT CONSTRAINT MODE changes the initial constraint setting for any transactions starting after the current transaction. Setting constraints ON causes all the affected constraints to be evaluated when the SET ALL CONSTRAINTS ON statement executes and causes any constraints selected for deferred evaluation by the execution of an SQL statement to be evaluated at the end of the SQL statement. Setting constraints OFF causes constraint evaluation to be deferred until commit time. Before you execute the SET DEFAULT CONSTRAINT MODE statement, the default mode for constraints will be set at OFF. After you execute the SET DEFAULT CONSTRAINT MODE statement, any subsequent transactions will have the initial constraint evaluation mode that you set. 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.
DATE
Type HELP SET_DATE_FORMAT at the SQL> prompt for help on SET DATE FORMAT.
EDIT to WARNING
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 EXECUTE/NOEXECUTE controls whether or not SQL executes statements in an interactive SQL session. If you specify SET NOEXECUTE, you could check statements for correct syntax or deprecated feature messages without executing the statements. SET EXECUTE is the default. SET FLAGGER controls the output of informational messages that indicate Digital extensions to ANSI/ISO standard syntax. If you specify SET FLAGGER ON, SQL sends you an informational message if you issue a subsequent interactive SQL statement that contains nonstandard syntax. SET LANGUAGE changes the language to be used for month abbreviations in date and time input and display. For Field Test 1, this statement cannot be used to format columns of data type DATE ANSI. SET LINE LENGTH n specifies an alternate line length (n) for SQL output. For n, you may use any number up to 512. 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 QUERY CONFIRM prompts you with the the estimated disk I/O operations and number of rows returned before executing the query. SET QUERY LIMIT allows you to specify a default number of rows returned by query or a default number of seconds allowed to compile the query. 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. SET WARNING DEPRECATE causes SQL to display diagnostic messages when you enter statements containing obsolete SQL syntax. SET WARNING NODEPRECATE suppresses such messages. SET WARNING DEPRECATE is the default.
SCHEMA
Type HELP SET_SCHEMA at the SQL prompt for help on SET SCHEMA.
TRANSACTION
Type HELP SET_TRANSACTION at the SQL prompt for help on SET TRANSACTION.