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.