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

VALIDATE

Causes the SQL Option preprocessor to verify all data objects referenced in your program's embedded SQL statements against the SQL Option system tables.

Syntax:

[NO]VALIDATE

Parameters:

None

Properties:

Default:

VALIDATE if in DB2 V6 mode or NOVALIDATE if in DB2 V5 mode (applies to Windows environments only).

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.