Executing SQL Statements

Use Sybase Control Center to execute SQL statements on one or more Adaptive Servers.

You can use the Execute SQL view to run 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, SCC displays an error.

  1. In the Administration Console, select one or more servers, click the drop-down arrow, and select Execute SQL.
  2. Enter the SQL statements.
  3. Click Execute.
    The query runs on all the servers you selected and results appear in the bottom portion of the view. The view includes a results tab for each server. On the tabs,
    • A green check indicates a successful query.
    • A red X indicates an error. A tab with a red X also displays an error message.