Database Type Test and Query Window - 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)

You use this window to connect to a database and to run SQL commands.

On the menu bar, click File > Database Type Test and Query to open this window.

Database type

In this group box, you select the platform on which your database runs.  The following options are available:

  • Oracle

  • SQL Server

If you click Actions > Use INI File, the software selects the database type automatically.

ODBC driver — Accept the default value for the database platform, or type a different value.  If your database is Oracle, you must enter the DBMS parameter of your Oracle version.  For example, for Oracle 11g, enter ORA.  If you click Actions > Use INI File, the software retrieves the DBMS parameter value from the [Database] section of Intools.ini file and displays this value in the ODBC driver box automatically.

When the database platform is SQL Server, make sure that the ODBC driver box displays MSS in upper case.  In the Intools.ini file, the string DBMS=MSS must display MSS in upper case; otherwise, it is not possible to work with specifications in Smart Instrumentation.

Connection settings

Displays the connection settings retrieved from the Intools.ini file or allows you to enter the connection settings manually if you need to connect to another database.

Schema logon name — Allows you to type the logon name of the Admin or Domain schema.

Schema logon password — Allows you to type the logon password of the Admin or Domain schema.  The password characters appear masked.

Server name — Allows you to type the Oracle instance alias for the server to which you want to connect.

Only required when the database type is Oracle.

Database name — Allows you to type the Oracle instance alias for the database to which you want to connect.  The alias name is the same for both boxes.

Only required when the database type is Oracle.

DBParm — Displays the connection string as defined for the DBParm parameter under the [Database] section of the Intools.ini file.

Only required when the database type is SQL Server.

On SQL Server, if you first connected to the Admin schema by using the Intools.ini file parameters, when connecting to a Domain schema on SQL Server, you must manually change the UID and PWD values to match the displayed target Domain schema logon name and password respectively.

Auto commit — Allows you to execute a batch of SQL commands.  If you clear the check box, when executing SQL commands, the software prompts you to execute each SQL command manually.

Query — Allow you to enter the SQL command that you want to execute for the database to which you are connected.

Results — Displays the result of making a database connection or executing SQL commands.  On connecting to the database, a zero (0) parameter indicates a successful connection.

Database Type Test and Query Toolbar

Use .INI — Allows you to copy the database settings from the Intools.ini file to the boxes in the Connection setting dialog box.

Connect — Connects to the database specified in the Database type and Connection setting parameters.

The following icons are active only after you connect to a database.

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

Open — Opens an .sql file.

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

Print — Print the results of an SQL Select command.