Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL SET_ANSI — VMS RDB_4.2

 SET ANSI ─┬─> 
D

A

T

E
────────┬─┬> 
O

N
─┬─> typebox (;) ├─> 
I

D

E

N

T

I

F

I

E

R

S
─┤ └> 
O

F

F
┘ └─> 
Q

U

O

T

I

N

G
─────┘ 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