You can load an existing statement in the following ways:
From the File menu, select Load Statement.
On the tool bar, click the Load Statement button.
Double-click the name of a statement in the Statements tab.
Drag a statement from the Statements tab into the Table Diagram tab.
When the statement opens, the name of the statement, the statement type, the schema name, and the data source name appear just above the menu bar.
SQL Statements appear both in the Statement Builder and in the Proficy Portal client (Data Source Browser and Data Sources Tree) with icons that indicate the type of statement. The following table shows the icons and their associated statement types.
|
Icon |
SQL Statement Type |
|
|
SELECT statement |
|
|
Parameterized SELECT statement |
|
|
INSERT statement |
|
|
UPDATE statement |
|
|
DELETE statement |
|
|
CALL statement |
