IBM Books

XML Extender Administration and Programming

enable_column

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


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