SQL$HELP72.HLB  —  SET_ANSI
    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
Environment Format Arguments Example
Close Help