Removing an SQL statement from an SQL-related EGL statement

EGL provides an implicit SQL statement for each SQL-related EGL input/output (I/O) statement. An implicit SQL statement can be appended to an EGL I/O statement making it an explicit SQL statement (see Constructing an explicit SQL statement from an implicit one). To remove the appended SQL statement, do as follows:

1. Open the EGL file that contains the explicit SQL 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.

2. Click on the explicit SQL statement, then right-click. A context menu displays.

3. Select SQL Statement > Remove. The EGL I/O statement remains.

Related concepts
SQL support

Related tasks
Constructing an explicit SQL statement from an implicit one
Resetting an explicit SQL statement
Validating an implicit or explicit SQL statement
Viewing the implicit SQL for an SQL-related EGL statement