Chapter 3 Building Information Liquidity Diagrams

Executing SQL queries in an ILM

You can send SQL queries to a connected data source and display the results.

This feature is available from the database and replication process (see Replication Processes (ILM)) contextual menus.

To execute a SQL query:

1. Right-click a database or replication process in the diagram or Browser, and select Execute SQL. If you are not already connected to the data source, the Connect to Data Source window will open. Choose your connection profile and click Connect to proceed to the Execute SQL Query dialog.
2. Type one or more SQL statements in the window, and click Run to apply them to the data source.
   
   The query results are displayed in the Results window.

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