Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

runtime options

RDB/VMS SQL SET_DIALECT — VMS RDB_4.2

 SET DIALECT ---> runtime-options -------> ;

 SET DIALECT specifies the settings of the current connection for
 the following characteristics:

  o  Whether the length of character string parameters, columns,
     and domains are interpreted as characters or octets.

  o  Whether double quotation marks are interpreted as string
     literals or delimited identifiers.

  o  Whether or not identifiers may be keywords.

  o  Which views are read-only.

  o  Whether columns with the DATE or CURRENT_TIMESTAMP data type
     are interpreted as VMS or SQL92 format.


 The DIALECT clause lets you specify the a number of settings
 with one clause, instead of specifying each setting
 individually.

 You can use the SET DIALECT statement with interactive and
 dynamic SQL only.

Additional information available:

runtime options

runtime options

 runtime-options

 --+---> 'literal' --------------+-->
   +---> parameter --------------+
   +---> parameter-marker -------+

 The value of runtime-options must be one of the following:

  o  SQL92

  o  SQL89

  o  MIA

  o  SQLV40

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