When you compile a SAM, DB/Assist automatically verifies each statement in the SAM with DB2. This performs the same functions as the DB2 Precompiler.

Specifically, verifying the SAM includes the following actions:

•Registering all referenced variables linked to each statement with DB2.

•Checking that the syntax of each SQL statement in the SAM is valid according to DB2. This gives the same result as selecting the Validate push button while building a statement, as described in Validating Statement Syntax.

•Ensuring that a variable of the appropriate type is linked to each input or output column in a statement.

In most cases, DB/Assist verifies statements automatically as part of the compile process. However, you can also verify a SAM without generating and compiling ESL action routines. This is useful if you want to check whether the compile is likely to succeed, but are not yet ready to generate code into your Workbench project.

To verify a SAM without generating ESL code, follow these steps:

1.If you have not already done so, open the SAM that you want to verify (as described in Opening an Existing SAM).

2.Make sure that you have linked variables to each statement in the SAM (as described in Linking Variables to SQL Statements).

3.Select SQL Access Module Ø Verify. The Log window appears with information about the verification.

4.Check the Log window and Status Area messages for information about the verification.

5.Double-dick on the system menu to close the Log window.