EGL provides an implicit SQL SELECT statement for a given SQL record part.
To validate the implicit SQL SELECT statement against a database, do as follows:
- Open the EGL file that contains the SQL record part. 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 inside the SQL record part, then right-click. A context menu displays.
- Select SQL Record > Validate Default
Select.
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.