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

Intergraph Smart Instrumentation Internal Setup

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Help
Version_SPI_custom
2018 (12.0)

The following SQL Select command retrieves the current software version and domain name from the Admin schema tables:

Select rev_software, proj_name from project;

The following SQL Select command retrieves loop numbers and their associated instrument tag numbers from the Domain schema tables:

Select component.cmpnt_name, loop.loop_name from component, loop where component.loop_id = loop.loop_id;

or:

Select c.cmpnt_name, l.loop_name from component c, loop l where c.loop_id = l.loop_id;

  • End each command with a semicolon (;).

  • In this example, the where argument ensures that the tag numbers appear with the correct relationship to the loops to which they belong.