Constructing an explicit SQL statement from an implicit one
EGL provides an implicit SQL statement for each SQL-related EGL input/output (I/O) statement. To construct an explicit SQL statement from an implicit one, do as follows:
- Open the EGL file that contains the EGL I/O statement. If you do not have the file open, right-click on the EGL file in the Project Explorer, then select Open With > EGL Editor.
- Click on the EGL I/O statement, then right-click. A context menu displays.
- To construct an explicit SQL statement without an INTO clause, select SQL Statement > Add. To construct an explicit SQL statement with an INTO clause, select SQL Statement > Add with Into. The implicit SQL statement is appended to the EGL I/O statement making it an explicit SQL statement.
Note: The INTO clause is only valid with open, get, and get next statements.
Related concepts
SQL support
Related tasks
Removing an SQL statement from an SQL-related EGL statement
Resetting an explicit SQL statement
Validating an implicit or explicit SQL statement
Viewing the implicit SQL for an SQL-related EGL statement