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 --+---> 'literal' --------------+--> +---> parameter --------------+ +---> parameter-marker -------+ The value of runtime-options must be one of the following: o SQL92 o SQL89 o MIA o SQLV40