Skip to main content

Add Stored Procedures Dialog Box

  • Updated

BackPrevious Topic  Next TopicNext

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.

Add Stored Procedures dialog box

You see the following options in the dialog box:

Database Catalog

The drop-down list displays all the catalogs in the database. Select the catalog that contains the required stored procedures.

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.

Sort iconSort icon

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.

Search iconSearch icon

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:

  • More Search Option buttonDrop-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.
  • Close buttonDelete icon
    Select to close the search box and cancel the search.

Add

Select to add the specified stored procedures to the catalog.

Done

Select to apply all changes and close the dialog box.

Help

Select to view information about the dialog box.

BackPrevious Topic  Next TopicNext