Executing a SQL Query

Execute an ad hoc SQL query or a stored procedure against one or more 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 to perform the actions in the query, you will see an error.

  1. In the Perspective Resources view, select one or more resources and select Resource > Administration Console.
  2. In the left pane of the Administration Console, select IQ Servers.
  3. In the right pane, select the Sybase IQ resources.
  4. From the Administration Console menu bar, select Resource > Execute SQL.
    The Execute SQL view opens.
  5. Enter a query or the name of a stored procedure in the SQL Statements box and click Execute.
    The query runs on all the 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: Manage and Monitor the Sybase IQ Environment