SQL$HELP72.HLB  —  SET_SQLDA, Arguments  ENABLE
    The ENABLE clause activates one of the following behaviors for
    Dynamic SQL.

    -  INSERT RETURNING - The default behavior of INSERT ...
       RETURNING when executed by dynamic SQL is to place parameters
       from the RETURNING INTO clause in to the INPUT SQLDA. This
       behavior is maintained for backward compatibility. This option
       allows the programmer to force different (and corrected)
       behavior for the non-compound use of this statement.

                                      NOTE

          If the INSERT RETURNING statement is included in a
          compound statement then the parameters are handled
          correctly.

    -  NAMED MARKERS - as well as traditional parameters markers
       (?). Dynamic SQL will now accept named, host-variable style
       parameter markers. See the Usage Notes for further details and
       examples.

    -  ROWID TYPE - returns DBKEY values as a special type (SQLDA_
       ROWID, 455) to make processing of the DBKEY values easier.
       For instance, in prior releases the SQLDA name field (SQLNAME)
       for DBKEY entries in the SQLDA was the only way to distinguish
       these values from other CHAR or VARCHAR columns - it would be
       either DBKEY or ROWID. If a query renamed the DBKEY column,
       then the application had no information in the SQLDA to
       indicate that the CHAR or VARCHAR value was binary data. In
       all respects, the SQLDA_ROWID type appears as a fixed length
       string of octets (possibly containing octets of zero which the
       C language would treat as a NULL terminator for a string).
Close Help