Previous Topic Next topic Print topic


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.

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.

Previous Topic Next topic Print topic