Altering a wrapper

After you configure a wrapper, you can modify the configuration based on your system requirements.

Before you begin

Ensure that the authorization ID has SYSADM or DBADM authority.

The following restrictions apply:

You cannot drop the DB2_FENCED wrapper option.
The federated server cannot process an ALTER WRAPPER statement within a particular unit of work if the unit of work includes one of the following statements:
- A SELECT statement that references a nickname for a table or view at the data source that the wrapper includes.
- An open cursor on a nickname for a table or view at the data source that the wrapper includes.
- An INSERT, DELETE, or UPDATE statement that is issued against a nickname for a table or view at the data source that the wrapper includes.

Use one of the following methods:

Command line:
Issue the ALTER WRAPPER statement.

Examples:
To change the DB2_FENCED option to 'Y' for the drda wrapper, issue the following statement:
```
ALTER WRAPPER drda OPTIONS (SET DB2_FENCED 'Y');
```
To change the value of the MODULE option to '/opt/odbc/lib/libodbc.a(odbc.so)' for the odbc wrapper , issue the following statement:
```
ALTER WRAPPER odbc OPTIONS (SET MODULE '/opt/odbc/lib/libodbc.a(odbc.so)');
```
Web console:
1. Click Administer > Remote Tables.
2. Click Manage Servers.
3. Click a wrapper name.
4. Click Alter.