Execute a SQL Command - Intergraph Smart Instrumentation - Administration & Configuration

SmartPlant Instrumentation Configuration and Maintenance Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
2016 SP1 (11.0.1)
  1. On the menu bar, click File > Database Type Test and Query.

  2. Do one of the following:

    • Define connection parameters for the Admin schema by clicking Actions > Use INI File on the menu bar or by clicking on the toolbar.

    • Define connection parameters for the appropriate Domain schema. See Testing the Database Connection Common Tasks.

  3. Do one of the following:

    • On the menu bar, click Actions > Connect.

    • On the toolbar, click .

  4. Do one of the following:

    • Under Query, type the SQL command that you want to execute. End each command with a ; (semicolon) and do not type more than one SQL Select command.

    • On the menu bar, click File > Open, and then, select an external SQL file with the .sql extension.

    SHARED Tip The encoding of the source SQL file must be Unicode LE. Any other SQL file encoding is not supported.

  5. Do one of the following:

    • On the menu bar, click Actions > Execute.