Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Accessing a database

Executing SQL queries

Executing SQL queries

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

• To execute SQL queries:
  1. Select Database-->Execute SQL.

     A dialog box asks you to identify a data source and connection parameters.

     

  2. Select a data source from the dropdown listbox.

  3. Type your user name and password.

  4. Click Connect and, if prompted by your data source, enter additional connection parameters.

     A Queries window appears.

     

  5. Type one or more SQL queries in the window.

     The syntax of some SQL queries may be DBMS-dependent.

  6. Click the Execute button.

     A list displays the results of your queries.

     

  7. Click Close.

     You return to the queries window.

  8. Click Cancel.