The DB2 version syntax checking to use. Values are V5 (to use DB2 V5 rules), V6 (to use DB2 V6 syntax checking) or V7 (to use DB2 V7 syntax checking).
Properties:
Default:
V7
Comments:
DB2 V6 or later causes VALIDATE to be turned on by default. This is because some of the syntax checking takes place on the server when in DB2 V6 mode or later.
You need to specify NOVALIDATE if you do not want SQL statements to be validated. Note that doing this could cause many errors to not be reported until the SQL statement is executed. VALIDATE also requires all referenced tables and columns to be defined.
Comments:
DB2 V6 or later causes VALIDATE to be turned on by default. This is because some of the syntax checking takes place on the server when in DB2 V6 mode or later.
You need to specify NOVALIDATE if you do not want SQL statements to be validated. Note that doing this could cause many errors to not be reported until the SQL statement is executed. VALIDATE also requires all referenced tables and columns to be defined.