Specifies the DB2 version used by the SQL Option preprocessor for syntax checking.
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:
V8
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.
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.