Purpose
Connects to a database and disables the XML-enabled column. When the column is disabled, it can no longer contain XML data types. When an XML-enabled column is disabled, the following actions are performed:
Important: You must disable an XML column before dropping an XML table. If an XML table is dropped but its XML column is not disabled, the XML Extender keeps both the side tables it created and the XML column entry in the XML_USAGE table.
Format
disable_column |
---|
>>-dxxadm--disable_column--db_name--tab_name--column_name-------> >-----+------------+---+---------------+----------------------->< '--l--login--' '--p--password--' |
Parameters
Table 17. disable_column parameters
Parameter | Description |
---|---|
db_name | The name of the database in which the data resides. |
tab_name | The name of the table in which the XML column resides. |
column_name | The name of the XML column. |
-l login | The user ID, which is optional, used to connect to the database, when specified. If not specified, the current user ID is used. |
-p password | The password, which is optional, used to connect to the database, when specified. If not specified, the current password is used. |
Examples
The following example disables an XML-enabled column.
dxxadm disable_column SALES_DB SALES_TAB ORDER