Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

DB2 Maestro online Help

Prev Return to chapter overview Next

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.

 



Prev Return to chapter overview Next