DB2 Maestro online Help
External Procedures and Functions
An external procedure/function is a user-defined function which is determined to the database with a reference to an object code library, and a function within that library that will be executed when the function is invoked. External functions cannot be column functions.
New External Procedures are created within Create External Procedure Wizard. In order to run the wizard you should either
| • | select the Object | Create Database Object... main menu item; |
| • | select the External Procedure icon in the Create Database Object dialog |
or
| • | select the External Procedures list or any object from that list in the explorer tree; |
| • | select the Create New External Procedure... item from the popup menu |
or
| • | open the database in Database Editor and the External Procedures tab there; |
| • | press the Insert key or select the Create New External Procedure... item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
To create a new External Procedure with the same properties as one of the existing External Procedure has:
| • | select the Object | Duplicate Database Object... main menu item; |
| • | follow the instructions of Duplicate Object Wizard. |
|
External Procedures can be edited within External Procedure Editor. In order to run the editor you should either
| • | select the External Procedure for editing in the explorer tree (type the first letters of the External Procedure name for quick search); |
| • | select the Edit External Procedure ... item from the popup menu |
or
| • | open the database in Database Editor and the External Procedures tab there; |
| • | select the External Procedure to edit; |
| • | press the Enter key or select the Edit External Procedure item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
You can change the name of the External Procedure using the Rename External Procedure dialog. To open the dialog you should either
| • | select the External Procedure to rename in the explorer tree; |
| • | select the Rename External Procedure item from the popup menu |
or
| • | open the database in Database Editor and the External Procedures tab there; |
| • | select the External Procedure to rename; |
| • | select the Rename External Procedure item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
|
To drop a External Procedure:
| • | select the External Procedure to drop in the explorer tree; |
| • | select the Drop External Procedure item from the popup menu |
or
| • | open the database in Database Editor and the External Procedures tab there; |
| • | select the External Procedure to drop; |
| • | press the Delete key or select the Drop External Procedure item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) |
and confirm dropping in the dialog window.
|
Partners
Download
Buy
