Specifies the following behavior:
o The length of character string parameters, columns, and
domains is interpreted as octets, rather than characters.
o Double quotation marks are interpreted as string literals.
o Keywords can be used as identifiers.
o The ANSI/ISO SQL standard for updatable views is not
applied. Instead, SQL considers views that meet the following
conditions to be updatable:
- The DISTINCT keyword is not specified.
- 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.
o The DATE and CURRENT_TIMESTAMP data types are interpreted as
VMS format. The VMS format DATE and CURRENT_TIMESTAMP contain
YEAR TO SECOND fields.
o The constraint evaluation time is DEFERRABLE INITIALLY
DEFERRED.
The default is SQLV40.