After you build an SQL statement, you must link variables to each column in the statement. You can then compile the SAM containing this statement as part of your ESL Application.

When you compile the SAM, DB/Assist generates code that fetches rows from the database into the specified ESL variables. You can display or manipulate these variables from your ESL program.

You can also pass values to your database through ESL variables that are linked to columns in INSERT statements, UPDATE statements, WHERE clauses, and HAVING clauses.

To link statement columns to ESL variables, you must complete the Link Variables dialog box as described in Linking Variables.