Loading Existing Statements

You can load an existing statement in the following ways:

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.

Statement Icons

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.


SQL Statement Type

SELECT statement

Parameterized SELECT statement

INSERT statement

UPDATE statement

DELETE statement

CALL statement

See Also

To load an existing statement