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

VALIDATE

Syntax:

[NO]VALIDATE

Parameters:

None

Properties:

Default:

VALIDATE if in DB2 V6 mode or NOVALIDATE if in DB2 V5 mode.

Comments:

When VALIDATE is specified, the SQL Option preprocessor attempts to log on to the SQL Option Server where it checks whether SQL statements can be executed and whether all referenced tables and columns are present. Note that the SQL Option Server must be available when using VALIDATE or a COBSQ0013W error occurs.