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.