Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

ALIAS

ALL_CONSTRAINTS

ANSI

CATALOG

CONNECT

DATE

SCHEMA

TRANSACTION

set date format

set edit

set output

set warning

CURRENCY SIGN to DIGIT

EDIT to WARNING

DATE

IDENTIFIERS

QUOTING

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:

DATEIDENTIFIERSQUOTING

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.

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