Examples of SQL 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)

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.