Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL SET_ANSI — VMS RDB_4.1_M

 SET ANSI -+-> DATE --------+-+> ON -+-> ;
           +-> IDENTIFIERS -+ +> OFF +
           +-> QUOTING -----+
 You can use the SET ANSI statements in dynamic or interactive
 SQL.

 SET ANSI DATE changes the default DATE and CURRENT_TIMESTAMP
 format from VMS to ANSI.  You must issue this statement before
 creating fields with these data types:  you cannot use it to
 change the data type of fields already created.

 SET ANSI IDENTIFIERS specifies whether or not SQL checks
 statements that use reserved words as user-supplied names and
 issues informational messages after such statements.

 SET ANSI QUOTING allows you to use quote characters around an
 identifier, so that you can qualify schema names with both the
 alias and the catalog name.  You must set ANSI QUOTING on when
 using multischema databases.

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