Chapter 4 Building an Information Liquidity Model

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 a database symbol contextual menu and from a replication process contextual menu.

For more information about the replication process, see the "Defining Replication Processes" section.

In the Execute SQL Query dialog box, you can use the following tools and accelerators from the Edit/Run Script editor toolbar:

Tool Description Accelerator

Editor Menu
Note: When you use the Find feature, the parameter "Regular expression" allows the use of wildcards in the search expression. For more information, see Visual Basic documentation 		shift + F11

Edit With. Opens the previously defined default editor or allows you to select another editor if you click the down arrow beside this tool ctrl + E

Run. Executes the current script F5

For more information about defining a default editor, see the "Defining a text editor" section in the "Using the PowerDesigner Interface" chapter in the General Features Guide .

Script bookmarks

In the Edit/Run Script editor window, you can add and remove bookmarks at specific points in the code and then navigate forwards or backwards from bookmark to bookmark:

Accelerator Description
ctrl + F2 Adds a new bookmark. A blue bookmark box is displayed. If you repeat this action from the same position, the bookmark is deleted and the blue marker is no longer displayed
F2 Jumps to bookmark
shift + F2 Jumps to previous bookmark

Steps To execute SQL queries in an ILM:

  1. Right-click a database or replication process symbol in the diagram, and select Execute SQL.

    A dialog box asks you to identify a data source and connection parameters.
  2. Select the Machine data source radio button.

    Select a data source from the list.

    or

    Select the File data source radio button.

    Browse to the directory containing the.DSN file.

    Select the.DSN file.
  3. Type your user ID and password.
  4. Click Connect and, if prompted by your data source, type additional connection parameters.

    The Execute Query dialog box is displayed.
  5. Type one or more SQL queries in the window.

    The syntax of some SQL queries may be DBMS dependent.
  6. Click the Run button.

    A list displays the results of your queries.
  7. Click Close to quit the Execute Query dialog box.

 

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