Causes the SQL Option Server to return DB2 error codes and messages when compiling and running, and to close all open cursors at COMMIT and ROLLBACK (the DB2 standard).
Restriction:This topic applies to Windows environments only.
Syntax:
[NO]DB2
Parameters:
None
Properties:
Default:
DB2
Comments:
The DB2 directive combines the DB2CLOSE and DB2ERROR directive. If the WITH HOLD clause is included in your SQL statement, cursors remain open after a COMMIT, even if the DB2 preprocessor directive is specified.
Comments:
The DB2 directive combines the DB2CLOSE and DB2ERROR directive. If the WITH HOLD clause is included in your SQL statement, cursors remain open after a COMMIT, even if the DB2 preprocessor directive is specified.