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