Creating Stored Statements
To create a new stored statement, do one of the following:
Right-click on the Database or Stored Statement icon in the left panel, and choose
New->Stored Statement
.
Highlight the Stored Statement node in the left panel, and choose
New->Stored Statement
from the Edit menu or from the right panel (click the Stored Statement icon or
New
button).
The definition form displays in the right panel.
On the
Stored Statement
tab, specify the Name and Schema for the stored statement.
In the
Query
field, type the text of the stored statement.
Optionally, specify one or more parameters in the
Parameters
field.
To test the statement, click the Execute icon.
To view the CREATE, DROP, and ALTER statements for the stored statement, click the
SQL
tab.
Version 5.2
[prev]
|
[next]