SQL$HELP72.HLB  —  SET_DIALECT, Arguments  SQL89_MIA
    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.
Close Help