Creating Stored Statements

  1. To create a new stored statement, do one of the following:
  2. On the Stored Statement tab, specify the Name and Schema for the stored statement.
  3. In the Query field, type the text of the stored statement.
  4. Optionally, specify one or more parameters in the Parameters field.
  5. To test the statement, click the Execute icon.
  6. To view the CREATE, DROP, and ALTER statements for the stored statement, click the SQL tab.