Examples of SQL Commands - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide

Language
English (United States)
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
13.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.