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:
- Select an action from the Edit actions list, then click Edit
SQL.
- 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.
- Click Execute, then click Execute again.
- 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.
- When you are finished executing the SQL statement, click Close.
- When you are finished editing the SQL statements, click OK.