1. Java Developer's Guide
  2. JMS/XLA Reference
  3. DDL Event Data Formats
  4. CREATE_INDEX

CREATE_INDEX

Messages with __TYPE=3 (XlaConstants.CREATE_INDEX) indicate that an index has been created.

Table 6-5 shows the name/value pairs that are in a MapMessage instance generated for a CREATE_INDEX operation.

Table 6-5 CREATE_INDEX Data Provided in Update Messages

Name Value

TBLOWNER

String value of the owner of the table on which the index was created

TBLNAME

String value of the name of the table on which the index was created

IXNAME

String value of the name of the created index

INDEX_TYPE

String value representing the index type: "P" (primary key), "F" (foreign key), or "R" (regular)

INDEX_METHOD

String value representing the index method: "H" (hash), "T" (range), or "B" (bit map)

UNIQUE

Boolean value indicating whether the index is unique

HASH_PAGES

Integer value representing the number of pages in a hash index (not specified for range indexes)

COLUMNS

String value describing the columns in the index

Format:

<col1name>[;<col2name> [;<col3name>[;...]]]