Online Documentation for SQL Manager for DB2

Wrappers


In a federated database system, a Wrapper is the mechanism by which the federated server invokes routines to communicate with, and retrieve data from a data source. The routines are contained in a library called a wrapper module.

 

 

Creating Wrappers

 

To create a new wrapper:

Hint: To create a new wrapper, you can also right-click the Wrappers node of the DB Explorer tree and select the New Wrapper... context menu item.

 

To create a new wrapper with the same properties as one of existing wrappers has:

Alternatively, you can right-click a wrapper in the DB Explorer tree and select the Duplicate Wrapper <wrapper_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new wrapper in, and to edit the result SQL statement for creating the wrapper.

 

 

Editing Wrappers

 

To edit an existing wrapper:

  • select the wrapper for editing in the DB Explorer tree (type the first letters of the wrapper name for quick search);
  • right-click the object and select the Edit Wrapper <wrapper_name>... context menu item, or simply double-click the wrapper;
  • edit wrapper definition using the appropriate tabs of Wrapper Editor.

 

Dropping Wrappers

 

To drop a wrapper:

  • select the wrapper to drop in the DB Explorer tree;
  • right-click the object and select the Drop Wrapper <wrapper_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new wrapper;

Ctrl+O to edit the selected wrapper;

Shift+Del to drop the object from the database.