Editing the SQL properties of a query

You must have the SQL Editor privilege. You must also have a solid knowledge of SQL and your underlying HCL Compass database before editing the SQL properties of a query. After you modify the SQL properties, you can no longer edit the query from the HCL Compass user interface.

Before you begin

When editing the SQL properties of a query that is not mastered by the current replica, you must ensure that your database type is the same as the type where the query was originally created.

About this task

To modify the SQL properties of a query:

Procedure

  1. Ensure that View > View SQL pane is selected.
  2. Run a query.
    The result set appears on the Result set page in the Query window.
  3. In the Query window, select the SQL editor tab.
  4. Modify the SQL properties of the query.
  5. Rerun the query.