Editing a query as SQL text

To edit a query as SQL text, you must have the SQL Editor privilege.

Before you begin

When you create a query, it is stored as a set of Compass parameters. To edit a query as SQL text, you must first convert it. Once converted, you cannot revert the query to the parameter form.

Procedure

To edit a query as SQL text:
  1. Convert the query to SQL text. In the Eclipse Navigator, right-click the query name and click SQL > Convert to SQL Query.
  2. Edit the SQL query text.
    1. In the SQL Navigator, right-click the query name and click SQL > View SQL.
      The SQL text appears in the View SQL Query.
    2. Click Edit SQL Query on the view toolbar.
  3. When you are done, click Save.