Purpose
Connects to a database and enables an XML column so that it can contain the XML Extender UDTs. When enabling a column, the XML Extender completes the following tasks:
Format
enable_column |
---|
>>-dxxadm--enable_column--db_name--tab_name--column_name--DAD_file--> >----+-----------------+---+-------------------+----------------> '--t--tablespace--' '--v--default_view--' >-----+--------------+---+------------+---+---------------+---->< '--r--root_id--' '--l--login--' '--p--password--' |
Parameters
Table 16. enable_column parameters
Parameter | Description |
---|---|
db_name | The name of the database in which the XML data resides. |
tab_name | The name of the table in which the XML column resides. |
column_name | The name of the XML column. |
DAD_file | The name of the DAD file that maps the XML document to the XML column and side tables. |
-t tablespace | The table space, which is optional and contains the side tables associated with the XML column. If not specified, the default table space is used. |
-v default_view | The name of the default view, which is optional, that joins the XML column and side tables. |
-r root_id | The name of the primary key in the XML column table that is to be used as the root_id for side tables. The root_id is optional. |
-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 enables an XML column.
dxxadm enable_column SALES_DB SALES_TAB ORDER -v sales_order_view -r INVOICE_NUMBER