Internal Setup Commands - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Internal Setup

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Help
Version_SPI_custom
2018 (12.0)

File

Open — Allows you to open an external SQL file in the Query pane of the Database Type Test and Query window.  The encoding of the source SQL file must be Unicode LE.  You can then execute the retrieved SQL statements as needed.

Available when the Database Type Test and Query window is open and you are connected to the database. 

Close — Closes the Database Type Test and Query window.

Available when the Database Type Test and Query window is open.

Save As — Saves the results of an SQL Select command in a specified format.

Active only after you connect to a database.

Print — Prints the results of an SQL Select command.

Active only after you connect to a database.

Database Type Test and Query — Opens the Database Type Test and Query window to test your database connection and version compatibility.  You can also query your database from this window by means of SQL commands.

Printer Diagnostics — Opens the Printer Diagnostics dialog box, which displays details of your current default printer settings and allows you to specify the printing orientation.  From this dialog box, you can also launch the Properties dialog box if you need to change the printer settings.

Versions — Opens the Versions dialog box, where you compare Smart Instrumentation and template database versions with the version information file.

Action

The Action menu is available only when the Database Type Test and Query window is open.  Note that you can access most of these commands by clicking the icons that become active when you open this window.

(Database connection actions)

Use INI file — Copies the database settings from the Intools.ini file to the fields under the Connection setting group box.

Connect — Connects to the database indicated by the parameters.

(Database query actions) — Active only after you connect to a database.

Execute — Executes any SQL commands that you typed in the Query pane.

Settings

Available only from the Internal Setup window.

Create ODBC Profile — Creates an ODBC profile to configure Smart Instrumentation database files.

Rebuild Procedures and Triggers — Identifies abnormal database behavior and corrects it by rebuilding the stored procedures and triggers in the database.