RDB/VMS SQL SET_DIALECT — VMS RDB_4.2
SET DIALECT ───> runtime-options ───────> typebox (;) 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
──┬───> typebox (')literal' ──────────────┬──>
├───> parameter ──────────────┤
└───> parameter-marker ───────┘
The value of runtime-options must be one of the following:
o SQL92
o SQL89
o MIA
o SQLV40