STRICT-DB2

Enforces strict support for certain DB2 features that are generally permitted in default DB2 mode.

Syntax:

[NO]STRICT-DB2

Parameters:

None

Properties:

Default: NOSTRICT-DB2

Comments:

Mainframe DB2 does not let you declare a cursor before including the SQLCA (something allowed by the DB2 mode of SQL Option. STRICT-DB2 forces SQL Option (when running in DB2 mode) to generate an error in this circumstance. STRICT-DB2 also ensures that an SQLCA is provided by the program.