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