New

Creates a new statement and adds it to the current SAM.

Open

Opens an existing SQL statement.

Description

Adds a description to a SQL statement.

Delete

Deletes the selected SQL statement from the SAM.

Tables

Lets you select tables and columns from the current database for inclusion in the current SQL SELECT, INSERT, UPDATE, or DELETE statement.

Where

Creates a WHERE clause, which specifies the search conditions for a SELECT, UPDATE, or DELETE statement. These conditions determine which rows will be retrieved from the database.

Join

Creates a join clause between two selected tables. A join allows you to get data from multiple tables via a single SQL statement.

Group by

Creates a GROUP BY clause for a SELECT statement, which divides a result set into groups of rows.

Order by

Creates an ORDER BY clause, which sorts the rows of your result set.

Run

Dynamically runs the current SQL statement (except for positioned UPDATE and positioned DELETE statements). Displays the results and, if appropriate, lets you commit or rollback the database changes.

Link variables

Links EASEL variables with selected output columns or SQL statement input parameters.

Code generation options

Lets you specify EASEL code generation options for each SQL statement you create.

Import

Copies a SQL statement from the clipboard or from a file into the current SAM.

Export

Copies the current SQL statement to the clipboard or to a file.

Statement display

Displays only the selected types of SQL statements in the Statement drop-down list or in the Open SQL Statement dialog box.