1  –  parameter

    Specifies the value of runtime-options, which must be one of the
    following:

    o  SQL99

    o  SQL92

    o  SQL89

    o  MIA

    o  SQLV40

2  –  parameter-marker

    Specifies the value of runtime-options, which must be one of the
    following:

    o  SQL99

    o  SQL92

    o  SQL89

    o  MIA

    o  SQLV40

3  –  SQL99 or SQL92

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

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

    o  The DISTINCT keyword is not specified.

    o  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.

    o  The FROM clause refers to only one table. This table must be
       either a base table or a derived table that can be updated.

    o  The WHERE clause does not contain a subquery.

    o  The GROUP BY clause is not specified.

    o  The HAVING clause is not specified.

4  –  SQLV40

    Specifies that the ANSI/ISO SQL standard for updatable views is
    not applied.

    SQL considers views that meet the following conditions to be
    updatable:

    o  The DISTINCT keyword is not specified.

    o  The FROM clause refers to only one table. This table must be
       either a base table or a derived table that can be updated.

    o  The WHERE clause does not contain a subquery.

    o  The GROUP BY clause is not specified.

    o  The HAVING clause is not specified.

    The default is SQLV40.

5  –  'string-literal'

    Specifies the value of runtime-options, which must be one of the
    following:

    o  SQL99

    o  SQL92

    o  SQL89

    o  MIA

    o  SQLV40