IBM Books

XML Extender Administration and Programming

Disabling XML columns

Disable a column if you need to update a DAD file for the XML column, or if you want to delete the XML column or the table that contains the column. After the column is disabled, you can re-enable the column with the updated DAD file, delete the column, or other tasks. You can disable a column by using the XML Extender administration wizard or using the DB2 command shell.

When the XML Extender enables an XML column, it:

Important: If you drop a table with an XML column, without first disabling the column, XML Extender cannot drop any side the tables associated with the XML column, which might cause unexpected results.

Before you begin

Ensure that the XML column to be disabled exists in the current DB2 database.

Using the administration wizard

Use the following steps to disable XML columns:

  1. Set up and start the administration wizard. See Starting the administration wizard for details.
  2. Click Working with XML Columns from the LaunchPad window to view the XML Extender column related tasks. The Select a Task window opens.
  3. Click Disable a Column and then Next to disable an existing table column in the database.
  4. Select the table that contains the XML column from the Table name field.
  5. Select the column being disabled from the Column name field.
  6. Click Finish.

From the DB2 command shell

To disable an XML column, enter the following command:

Syntax:
dxxadm disable_column
>>-dxxadm---disable_column---dbName---tbName---colName---------><
 

Parameters:

dbName
The name of the database.

tbName
The name of the table that contains the column that is to be disabled.

colName
The name of the XML column that is being disabled.

Example: The following example disables a column using the DB2 command shell. The DAD file and XML document can be found in Appendix B, Samples.

dxxadm disable_column SALES_DB sales_tab order
 

In this example, the column ORDER is disabled in the table SALES_DB.SALES_TAB.

When the column is disabled, the side tables are dropped.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]