SET ┬> 
C
U
R
R
E
N
C
Y
S
I
G
N currency-char ──────────────────────┬>typebox (;)
     ├> set-date-format ──────────────────────────────────┤
     ├> 
D
I
C
T
I
O
N
A
R
Y ──> path-name ─────────────────────────┤
     ├> 
D
I
G
I
T 
S
E
P
A
R
A
T
O
R digit-sep-char ───────────────────┤
     ├> set-edit ─────────────────────────────────────────┤
     ├> 
E
X
E
C
U
T
E ──────────────────────────────────────────┤
     ├> 
N
O
E
X
E
C
U
T
E ────────────────────────────────────────┤
     ├> 
L
A
N
G
U
A
G
E language-name ───────────────────────────┤
     ├> 
L
I
N
E 
L
E
N
G
T
H ──> n ────────────────────────────────┤
     ├> set-output ───────────────────────────────────────┤
     ├> 
N
O
O
U
T
P
U
T ─────────────────────────────────────────┤
     ├> set-query ────────────────────────────────────────┤
     ├> 
R
A
D
I
X typebox (P)typebox (O)typebox (I)typebox (N)typebox (T) radix-char ───────────────────────────┤
     ├> 
V
E
R
I
F
Y ───────────────────────────────────────────┤
     ├> 
N
O
V
E
R
I
F
Y ─────────────────────────────────────────┤
     ├> set-warning ──────────────────────────────────────┤
     ├> 
D
E
F
A
U
L
T 
C
O
N
S
T
R
A
I
N
T typebox (M)typebox (O)typebox (D)typebox (E) ──┬────────┬─> 
O
N ──┬─────┘
     └> 
F
L
A
G
G
E
R ──────────────────┘        └─> 
O
F
F ─┘

Additional information available:

ALIASALL_CONSTRAINTSANSICATALOGCHARACTER_LENGTH
CONNECTDATEDEFAULT_CHARACTER_SETDEFAULT_DATE_FORMAT
DIALECTIDENTIFIER_CHARACTER_SETKEYWORD_RULESLITERAL_CHARACTER_SET
NAMESNATIONAL_CHARACTER_SETQUOTING_RULESSCHEMA
TRANSACTIONVIEW_UPDATE_RULES

set date formatset editset outputset queryset warningCURRENCY SIGN to DIGIT
EDIT to WARNING

 set-date-format =

 ──> 
D
A
T
E 
F
O
R
M
A
T ┬> 
D
A
T
E date-number ─┬───────────>─────────┬┬─>
                 │                    └─>, 
T
I
M
E time-number ┘│
                 └> 
T
I
M
E time-number ─┬───────────>─────────┬┘
                                      └─>, 
D
A
T
E date-number ┘

 set-edit=
 ──> 
E
D
I
T ───┬──> 
K
E
E
P ───> n ──┬──>
             ├──> 
N
O
K
E
E
P ───────┤
             └──> 
P
U
R
G
E ────────┘

 set-output=
 ────> 
O
U
T
P
U
T ────┬────────>────────┬───>
                  └──> file-spec ───┘

 set-query =

 ───> 
Q
U
E
R
Y ─┬─> 
C
O
N
F
I
R
M ──────────────────────────────┬─>
             ├─> 
N
O
C
O
N
F
I
R
M ────────────────────────────┤
             └─> 
L
I
M
I
T ───┬──> 
R
O
W
S total-rows ────────┤
                          ├──> 
T
I
M
E total-seconds ─────┤
                          └──> 
C
P
U 
T
I
M
E total-seconds ─┘

 set-warning=
 ────> 
W
A
R
N
I
N
G ─┬─> 
D
E
P
R
E
C
A
T
E ───┬─────>
                └─> 
N
O
D
E
P
R
E
C
A
T
E ─┘

 Type HELP SET_ALIAS at the SQL prompt for help on SET ALIAS.

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

 Type HELP SET_ANSI at the SQL prompt for help on SET ANSI DATE,
 SET ANSI IDENTIFIERS, or SET ANSI QUOTING.

Additional information available:

DATEIDENTIFIERSQUOTING

 Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI DATE.

 Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI
 IDENTIFIERS.

 Type HELP SET_ANSI at the SQL> prompt for help on SET ANSI
 QUOTING.

 Type HELP SET_CATALOG at the SQL prompt for help on SET CATALOG.

 Type HELP SET_CHARACTER_LENGTH at the SQL prompt for help on SET
 CHARACTER LENGTH.

 Type HELP SET_CONNECT at the SQL prompt for help on SET CONNECT.

 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.

 Type HELP SET_DATE_FORMAT at the SQL> prompt for help on SET
 DATE FORMAT.

 Type HELP SET_DEFAULT_CHARACTER_SET at the SQL prompt for help
 on SET DEFAULT CHARACTER SET.

 Type HELP SET_DEFAULT_DATE_FORMAT at the SQL prompt for help on
 SET DEFAULT DATE FORMAT.

 Type HELP SET_DIALECT at the SQL prompt for help on SET DIALECT.

 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 limits to restrict the
 output generated by a query.  The arguments to SET QUERY LIMIT
 are:

  o  CPU TIME total-seconds

     You can restrict amount of CPU time used to optimize a query
     for execution.  If the query is not optimized and prepared
     for execution before the CPU time limit is reached, an error
     message is returned.  The default is unlimited CPU time for
     the query compile.  Dynamic SQL options are inherited from
     the compilation qualifier.

  o  ROWS total-rows

     You can restrict output by limiting the number of rows a
     query can return.  The optimizer counts each row returned by
     the query and stops execution when the row limit is reached.
     The default is an unlimited number of record fetches.
     Dynamic SQL options are inherited from the compilation
     qualifier.

  o  TIME total-seconds

     You can restrict the amount of time used to optimize a query
     for execution.  If the query is not optimized and prepared
     for execution before the total elapsed time limit is
     reached, an error message is returned.  The default is
     unlimited time for the query compile.  Dynamic SQL options
     are inherited from the compilation qualifier.


 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.

 Type HELP SET_IDENTIFIER_CHARACTER_SET at the SQL prompt for
 help on SET IDENTIFIER CHARACTER SET.

 Type HELP SET_KEYWORD_RULES at the SQL prompt for help on SET
 KEYWORD RULES.

 Type HELP SET_LITERAL_CHARACTER_SET at the SQL prompt for help
 on SET LITERAL CHARACTER SET.

 Type HELP SET_NAMES at the SQL prompt for help on SET NAMES.

 Type HELP SET_NATIONAL_CHARACTER_SET at the SQL prompt for help
 on SET NATIONAL CHARACTER SET.

 Type HELP SET_QUOTING_RULES at the SQL prompt for help on SET
 QUOTING RULES.

 Type HELP SET_SCHEMA at the SQL prompt for help on SET SCHEMA.

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

 Type HELP SET_VIEW_UPDATE_RULES at the SQL prompt for help on
 SET VIEW UPDATE RULES.