Customizing SQL statements in the EGL wizards

When you are using an EGL wizard to create data parts from a relational table or create a Web application from a relational table, you can change the SQL statement that is associated with an action like read or update:
  1. Select an action from the Edit actions list, then click Edit SQL.
  2. Edit the SQL statement (as is possible for all actions except delete), then click Validate. Validation ensures that the statement has the correct syntax and adheres to the rules for host variable names. If the statement contains errors, a message is displayed. Correct the errors and validate again.

    Revert to Last changes the statement into its last valid modified version. Previous versions become unavailable after you close the dialog.

  3. Click Execute, then click Execute again.
  4. If the SQL statement requires values for host variables, the Specify Variable Values dialog is displayed. Double-click the Value field to enter the value of a host variable, then press the Enter key. When you have entered values for all host variables, click Finish.
    Note: For host variables defined as type character, you must enclose the value in single quotes.
  5. When you are finished executing the SQL statement, click Close.
  6. When you are finished editing the SQL statements, click OK.

Related concepts
EGL Data Parts wizard
EGL Data Parts and Pages wizard
SQL support

Related tasks
Creating a single-table EGL Web application
Creating EGL data parts from relational database tables
Creating, editing, or deleting a database connection for the EGL wizards
Setting EGL preferences

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.