Validating an implicit or explicit SQL statement
To validate an implicit or explicit SQL statement against a database, do as follows:
- Open the EGL file that contains the SQL-related EGL statement or 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.
- Click the EGL statement or SQL statement, then right-click. A context menu displays.
- Select SQL Statement > Validate.
Note: Before using the validate function, DB2 UDB users must set the DEFERREDPREPARE option. You can set this option interactively in the CLP (DB2 command line processor) using the db2 update cli cfg for section COMMON using DEFERREDPREPARE 0 command. This command will put the keyword under the COMMON section. Execute the command db2 get cli cfg for section common to verify that the keyword is being picked up.
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
Resetting an explicit SQL statement
Viewing the implicit SQL for an SQL-related EGL statement