Add column message

An add column message tells the user application that a Q Capture program added a column to an existing publication. This message is sent in response to a user or user application inserting an ADDCOL signal into the IBMQREP_SIGNAL table.

In an add column message, the message element (msg) contains an add column element (addColumn). The add column element contains a column schema (col) element that conveys information about the source table column that was added.

Table 1 describes the addColumn element.

Table 1. Element description for addColumn
Name Properties
addColumn Not empty, complex type, simple content

Structure


<addColumn subName="publication_name" srcOwner="source_owner"
    srcName="source_name">

       column_element

</addColumn>

Details

publication_name
The name of the publication that the column was added to. XML data type: string.
srcOwner
The schema of the source table for the publication. XML data type: string
srcName
The name of the source table. XML data type: string.
column_element
A column schema (col) element that contains details about the column that was added, such as name, data type, data length, and whether the column is a key column.

Example

The following example shows an add column message.

<?xml version="1.0" encoding="UTF-8"?>
<msg xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:noNamespaceSchemaLocation="mqcap.xsd" version="1.0.0"
      dbName="DB1">
    <addColumn subName="S1" srcOwner="USER1" srcName="T1">

       column_element

    </addColumn>
</msg>

Where column_element represents the column element that is explained in Column element (col) in a subscription schema message.