Executing SQL Commands - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Internal Setup

Intergraph Smart Instrumentation
2018 (12.0)

You can execute SQL commands to retrieve data from the database, or to update values in the database.  After retrieving data, you can save it in several formats such as Excel spreadsheets, PowerSoft reports, SQL, and so forth.  You execute SQL commands in the Database Type Test and Query window, in which you can either type an SQL command in the Query pane or load SQL commands from an external SQL file, provided that the file encoding is Unicode LE.

In the Internal Setup Utility, it is possible to run certain SQL commands generated by the DBChecker Utility. However, when using the Internal Setup Utility on the SQL Server platform, commands that contain 'go' do not run. To be able to run these commands in the Internal Setup Utility, change all the occurrences of 'go' with ';'.