Write data from a POD file to a database - Intergraph Spoolgen - Help

Intergraph Spoolgen Help

Language
English
Product
Intergraph Spoolgen
Search by Category
Help
SmartPlant Foundation / SDx Version
10
I-Configure Version
6.0(2016)
Isogen Version
13.0(2016)
Smart Isometrics Version
7.2
Spoolgen Version
9.2

You can use INSERT, UPDATE, and DELETE commands within a SQL statement to update data in an external table. In these instances, no data is copied into the POD file.

Example 1: Delete database records

Example 2: Insert new records into a table

Example 3: Update existing records in a table

  • We recommend that you avoid using an Excel spreadsheet as the database because it does not support all SQL statements.

  • Example 2 and Example 3 use the conventions listed below:

    • TABLE is the name of an existing database table.

    • Field1, Field2, and Field3 are the names of the columns in the database that you want to populate.

    • POD_property1, POD_property2 are the values in the POD file that you want to store in the external database.

  • In Example 3, the WHERE clause must identify a single row in the table to be updated.

  • Because DELETE, INSERT, and UPDATE commands do not return any data produce an error message in the GED log file. None of these commands return any data, which GED expects. Consequently, you can ignore this error.