Execute a SQL Command - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide (2019)

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.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.  For details, 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.

      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.