Specifies whether or not the SQL module processor applies the
ANSI/ISO standard for updatable views to all views created during
compilation.
If you specify SQL92, SQL99, SQL89, or MIA, the SQL module
processor applies the ANSI/ISO standard for updatable views to
all views created during compilation. Views that do not comply
with the ANSI/ISO standard for updatable views cannot be updated.
The default is SQLV40.
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.
If you specify SQLV40, SQL does not apply the ANSI/ISO standard
for updatable views. Instead, 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 view that can be updated.
o The GROUP BY clause is not specified.
o The HAVING clause is not specified.