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.
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.