Validating the SQL SELECT statement for an SQL record
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.
Related concepts
SQL support
Related tasks
Viewing the SQL SELECT statement for an SQL record
Related reference
SQL record part in EGL source format