Chapter 6 Managing Repository Documents

Executing SQL Queries

The Execute Query dialog box lets you type SELECT queries to execute in the repository, other queries may be rolled back.

If you want to execute other types of queries, you should use Interactive SQL if you are using Adaptive Server Anywhere or the query editor of your database.

You cannot execute SQL queries while using the repository proxy.

To execute SQL queries:

1. Select Repository→Execute SQL.
   
   The Connect dialog box is displayed if you are not connected to the repository, type the connection parameters and click OK.
   
   The Execute Query dialog box is displayed.
   
2. Type one or more SQL queries in the window.
   
   The syntax of some SQL queries may be DBMS dependent.
3. Click the Execute button.
   
   A list displays the results of your queries in the lower part of the dialog box.
4. Click Close to exit the Execute Query dialog box.

Copyright (C) 2006. Sybase Inc. All rights reserved.