Display Smart Instrumentation Data by Executing an SQL Statement - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help
Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

Use this procedure to display selected rows or a specific Smart Instrumentation database table by executing an SQL statement.

  1. After connecting to the Smart Instrumentation database, on the main InfoMaker window menu bar, select Tools > Database Painter.

  2. In the tree view, double-click the appropriate Smart Instrumentation database profile.

  3. To display selected rows of a table, in the ISQL Session pane (bottom right pane by default), select the ISQL Session tab.

  4. Type a Select statement.

    If you are connected to the Admin schema of Smart Instrumentation and want to select rows from a Domain schema table, you must include the Domain schema name in the SQL statement using the following syntax <Domain schema name>.<SQL Statement>;

  5. After typing the SQL statement, right-click the statement, and then, select Execute.