Specifies the following behavior:

    o  The length of character string parameters, columns, and
       domains is interpreted as characters, rather than octets.

    o  Double quotation marks are interpreted as delimited
       identifiers.

    o  Keywords cannot be used as identifiers unless they are
       enclosed within double quotation marks.

    o  The ANSI/ISO SQL standard for updatable views is applied to
       all views created during compilation. Views that do not comply
       with the ANSI/ISO SQL standard for updatable views cannot be
       updated.

       The ANSI/ISO SQL standard for updatable views requires the
       following conditions to be met in the SELECT statement:

       -  The DISTINCT keyword is not specified.

       -  Only column names can appear in the select list. Each
          column name can appear only once. Functions and expressions
          such as max(column_name) or column_name +1 cannot appear in
          the select list.

       -  The FROM clause refers to only one table. This table must
          be either a base table, global temporary table, local
          temporary table, or a derived table that can be updated.

       -  The WHERE clause does not contain a subquery.

       -  The GROUP BY clause is not specified.

       -  The HAVING clause is not specified.

    o  The DATE and CURRENT_TIMESTAMP data types are interpreted as
       SQL format. The SQL (ANSI) format DATE contains only the YEAR
       TO DAY fields.

    o  Conversions between character data types when storing data
       or retrieving data raise exceptions or warnings in certain
       situations. For further explanation of these situations, see
       the Data_Types HELP topic.

    o  You can specify DECIMAL or NUMERIC for formal parameters in
       SQL modules and declare host language parameters with packed
       decimal or signed numeric storage format. SQL generates
       an error message if you attempt to exceed the precision
       specified.

    o  The USER keyword specifies the current active user name for a
       request.

    o  A warning is generated when a NULL value is eliminated from a
       SET function.

    o  The WITH CHECK OPTION clause on views returns a discrete error
       code from an integrity constraint failure.

    o  An exception is generated with terminated C strings that are
       not NULL.

    o  The default on constraint evaluation time is set to NOT
       DEFERRABLE INITIALLY IMMEDIATE.