When you select SQL Access Module Ø Compile or the Compile button to compile a SAM; DB/Assist performs the following actions, in this order:
1.Registers all referenced variables linked to each statement with DB2.
2.Validates the SQL syntax of each statement in the SAM
3.Ensures that a variable of the appropriate type is linked to each input or output column in a statement.
4.Generates ESL action routines for each valid SQL statement in the SAM
5.Compiles the generated ESL actions routines into a file that you specify.
6.Creates a bind file for the SAM and, if checked in the Bind Options dialog box, a database access package.
The following sections give more information about how DB/Assist compiles SAMs.
