Save SQL Results in a Specified File Format - 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
12.0(2018)
  1. Execute an SQL Select command.

  2. With the SQL Result dialog box open, click File > Save As.

  3. On the Save As dialog box, select one of the following data formats:

    • Original: Saves the data in all the fields, including the ones that are not visible in the preview, for example, internal database ID numbers.  This option is recommended if you want to save the file in .psr or .sql format, or if you want to re- import the data into Smart Instrumentation at a later stage.

    • Data Only: Saves only the data that is visible in the preview. This option is recommended for easier viewing of the data, and enables you to manipulate the headers and select the columns you want to display.

  4. Click OK and navigate to the location where you want to save the file.

  5. Select the required file format and type the name of the file, then click Save.

  • You can save a result in the original format as an SQL file under the name of the table that you specified in the Select command.  When you run the SQL file, it creates the table.  You can delete all the data except for the set of values under the first insert into section and run the file as a script to insert the zero (default) line if it is missing.

  • If you save SQL results in SQL format and you intend to open the SQL file in the Internal Setup Utility later, make sure you select the correct encoding, which is Unicode LE.