Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > SQL Option for DB2 > Reference > XDB Directive Options > STRICT-DB2

STRICT-DB2

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.