Specifies whether or not SQL behavior in certain instances
complies with the ANSI/ISO SQL standard. The current default
behavior in these instances is noncompliant.
NOTE
SQL provides the following new statements to replace the SET
ANSI statement:
o SET DEFAULT DATE FORMAT replaces SET ANSI DATE; see the
SET DEFAULT DATE FORMAT statement.
o SET KEYWORD RULES replaces SET ANSI IDENTIFIERS; see the
SET_KEYWORD_RULES statement.
o SET QUOTING RULES replaces SET ANSI QUOTING; see the SET_
QUOTING_RULES statement.
o SET VIEW UPDATE RULES is new; see the SET_VIEW_UPDATE_
RULES statement.
In addition, SQL provides the SET DIALECT statement to
let you specify, with one statement, settings for all of
these statements. See the SET_DIALECT statement for more
information.
SQL does not return a deprecated feature message if you use
the SET ANSI statement.
Additional Information:
explode
extract