Chapter 3 Basic Repository Tasks

Querying the Repository using SQL

You can run standard SQL SELECT queries against the repository through the Execute Query window. If you want to execute more complex queries, you should use your DBMS query editor.

Note   SQL queries and the Repository Proxy
You cannot execute SQL queries while using the repository proxy.

Steps To execute SQL queries:

  1. Select Repository→Execute SQL to open the Execute Query window.

    Note   If you are not connected
    The Connect dialog box opens if you are not connected to the repository. Enter the connection parameters and click OK to connect.


  2. Enter one or more SQL queries in the appropriate syntax for your DBMS in the window and click the Execute button.

    The results of your query are displayed in the Results pane.
  3. Click Close to exit the Execute Query dialog box.

 

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