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