The SQL Statement button bar gives you quick access to DB/Assist dialog boxes for creating, maintaining, and running SQL statements.
SQL Statement Button Bar
The following table describes the buttons that appear on the SQL Statement button bar, from left to right.
Select this button ... |
To ... |
New Statement |
Display the New SQL Statement dialog box to create a new statement. |
Tables |
Display the SELECT/FROM Clause, UPDATE/SET Clause, DELETE/FROM Clause, or INSERT/INTO Clause dialog box to select tables and columns from the database. |
Where |
Display the WHERE Clause or WHERE CURRENT OF Clause dialog box to specify search conditions for a statement. |
Join |
Display the Join Clause dialog box to build a join clause for a SELECT statement. |
Group by |
Display the GROUP BY Clause dialog box to build a GROUP BY clause for a SELECT statement. |
Order by |
Display the ORDER BY Clause dialog box to build an ORDER BY clause for a SELECT statement. |
Run |
Dynamically run a statement to display the results and commit or rollback the database changes. |
Link variables |
Display the Link Variables dialog box to link ESL variables to each column in a statement. |
In addition to the buttons described in the preceding table, the SQL Statement button bar also contains the following fields:
•Statement drop-down list, which contains the names of the SQL statements in the current SAM You can select a statement from this list to open it, as described in Opening an Existing SQL Statement.
•Statement Type field, which displays the type of the current SQL statement. This field is located to the immediate right of the Statement drop-down list.