Resetting an explicit SQL 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. If you change the explicit SQL statement, do as follows to return to an SQL statement based on the implicit SQL:

  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 > Reset.

Related concepts
SQL support

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

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.