Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > XDB Directive Options > DB2VER

DB2VER

Specifies the DB2 version used by the SQL Option preprocessor for syntax checking.

Restriction: This topic applies to Windows environments only.

Syntax:

DB2VER={V7 | V8 | V9}

Parameters:

V7: Use DB2 V7 rules for syntax checking.
V8: Use DB2 V8 rules for syntax checking.
V9: Use DB2 V9 rules for syntax checking.

Properties:

Default:

Comments:

Because some syntax checking takes place on the server when using DB2 V7 or later, VALIDATE is turned on by default.

Specify NOVALIDATE if you do not want SQL statements to be validated. Be aware that doing this could cause errors that are reported only after the SQL statement is executed. VALIDATE also requires all referenced tables and columns to be defined.