Add Stored Procedures Dialog Box
You can use the Add Stored Procedures dialog box to add stored procedures from the database to a catalog. This topic describes the options in the dialog box.
Designer displays the Add Stored Procedure dialog box when you right-click a JDBC connection node and then select Add Stored Procedure from the shortcut menu in the Catalog Manager.
You see the following options in the dialog box:
The drop-down list displays all the catalogs in the database. Select the catalog that contains the required stored procedures.
The box lists all the stored procedures in the selected catalog in a three-level tree. The top level is SQL-catalog, second is SQL-schema, and the third are stored procedures. You can select one or more stored procedures to add to the catalog.
Select to display the Sort drop-down menu to sort the stored procedures in the ascending or descending order.
Designer controls the default sort order according to the Sort option in the Catalog category of the Options dialog box. When you do not select Sort in the Options dialog box, Designer selects No Sort by default in the drop-down menu, which means the stored procedures are listed in their original order in the database. The change of sort order here is a one-off action, meaning Designer does not save it after you exit the dialog box.
Select to open the search box to search for stored procedures.
To start searching, type the text you want to search for in the search box and Designer lists the stored procedures containing the matched text.
You can make use of the following options in the search box:
- Drop-down icon
Select to list more search options.
- Highlight All
Select to highlight all matched text.
- Match Case
Select to search for text that meets the case of the typed text.
- Match Whole Word
Select to search for text that looks the same as the typed text.
- Highlight All
- Delete icon
Select to close the search box and cancel the search.
Select to add the specified stored procedures to the catalog.
Select to apply all changes and close the dialog box.
Select to view information about the dialog box.