Executing a SQL Query

Execute an ad hoc SQL query or a stored procedure against one or more SAP Sybase IQ servers.

You can use the Execute SQL view to execute any valid SQL statement, including queries and stored procedures. Anyone can launch a query; no permissions are required. However, if you do not have authority (15.3, 15.4) or system privilege (16.0) to perform the actions in the query, you will see an error. The query executes with the user's current permissions.

  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane of the Administration Console, select IQ Servers.
  3. In the right pane, select the SAP Sybase IQ resources.
  4. From the Administration Console menu bar, select Resource > Execute SQL.
    The Execute SQL view appears.
  5. In the SQL Statements box, enter a query or the name of a stored procedure and click Execute.
    The query runs on all the SAP Sybase IQ servers you selected and results appear in the bottom portion of the view. If you selected more than one server, the view includes a results tab for each simplex or multiplex node. On the tabs,
    • A green check indicates a successful query.
    • A red X indicates an error.
Parent topic: Administer and Monitor SAP Sybase IQ