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