CODEWITHSUNDEEP
xmldb2db2-luw
malmo
malmo

Reputation: 524

Equivalence of DB2_GENERATED_DOCID_FOR_XML in db2luw

In DB2, A table with an XML column has a DocID column, used to link from the base table to the XML table. A DocID index is used for getting to base table rows from XML indexes.And it has the following syntax: 

CREATE INDEX index_name ON table_name
  (DB2_GENERATED_DOCID_FOR_XML ASC
  );

Is there an equivalent index for db2luw ?

Upvotes: 0

Views: 149

Answers (1)

data_henrik
data_henrik

Reputation: 17118

DB2 LUW has a similar index, the XML Region Index. It is a system index that is automatically generated when the first XML column is added to a table. You can find some information in the docs about the XML path index and XML regions index.

Also take a look at SYSCAT.INDEXES and the INDEXTYPE column.

Upvotes: 1

Related Questions