Internal Setup Commands - 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)

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 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 database files.

Rebuild Procedures and Triggers

Identifies abnormal database behavior and corrects it by rebuilding the stored procedures and triggers in the database.