Viewing the SQL SELECT statement for an SQL record

EGL provides an implicit SQL SELECT statement for a given SQL record part. To view the implicit SQL SELECT statement, do as follows:

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

2. Click inside the SQL record part, then right-click. A context menu displays.

3. Select SQL Record > View Default Select.

4. To validate the SQL SELECT statement against a database, click 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
Validating the SQL SELECT statement for an SQL record

Related reference
SQL record part in EGL source format