Tuning Generated SQL Statements - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

The first time, the SQL statement shown in the SQL-Text field is created by the software. Later, it is possible to modify it. Double-clicking in this field opens Window 7, where the PDS PDL procedures are displayed.

By clicking the View PPP button on PDS 20.10 Window 2, you jump to the block where you can maintain PDS PDL procedures. When using this button, Smart Materials will try to find an existing PDL procedure with the specific PDL header name.

The PDL procedure name is unique within a project. If you try to insert a second identical one, you will get an error message. You can choose the name of an existing PDL header for your procedure via LOV or create your own name. The PDL procedure does not keep the information from which PDL rule (PDS 20.01) or from which PDL header result it was derived (except the PDL header name if you want it). In enter query mode, you can use the LOV to retrieve a list of all existing PDL procedure names.

To save the PDL procedure to a certain result, select the Save to Result check box at the bottom of the screen. You can leave the PDL Rule Code and the PDL Header Name fields empty to copy the procedure back to the actual header result. Alternatively, choose a destination using the LOV.

SHARED Tip You can distribute one procedure to several header results by just re-checking the Save to Result check box after a successful commit operation.