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, or in the dialog box where a stored procedure list is available, expand the Stored Procedures node in a catalog data source that contains only one JDBC connection and select <Add Stored Procedure...>.
Designer displays these options:
This drop-down list displays all the catalogs in the database. Select the catalog that contains the stored procedures you need.
This box lists the stored procedures in the selected database catalog in a three-level tree. The top level is SQL-catalog, second is SQL-schema, and the third are stored procedures. Select one or more stored procedures to add to the catalog.
Select to display the Sort drop-down menu to specify how to sort the stored procedures.
Select to sort the stored procedures in the ascending order.
Select to sort the stored procedures in the descending order.
- No Sort
Select to keep the original order of the stored procedures as in the database.
Designer determines the default sort order according to the Sort option in the Catalog category of the Options dialog box. If you do not select Sort in the Options dialog box, Designer selects No Sort by default in the drop-down menu. In addition, the change of sort order is a one-off action which Designer does not remember after you exit the dialog box, meaning, each time when you open the dialog box, Designer always applies the default sort order.
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 use the following options in the search box:
- Drop-down icon
Select to list more search options.
- Highlight All
Select to highlight all the matched text.
- Match Case
Select to search for text that meets the case of the text you type.
- Match Whole Word
Select to search for text that looks the same as the text you type.
- 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.