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.
If you specify MIA, SQL sets the character sets as follows:
o Default character set: KATAKANA
o National character set: KANJI
o Identifier character set: DEC_KANJI
o Literal character set: KATAKANA
o The constraint evaluation time is DEFERRABLE INITIALLY
DEFERRED.