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.