When you create a primary article for a table with no large-object columns, ASE Replicator creates a shadow table with the columns described in Table A-17.
Column name |
Datatype |
Description |
|---|---|---|
conn_id |
numeric(18,0) |
ID of the primary connection |
txid_page |
int |
Identifies the transaction ID page in the transaction log table |
txid_row |
smallint |
Identifies the transaction ID row in the transaction log table |
log_ts_high |
smallint |
Log timestamp high value in the transaction log table |
log_ts_low |
int |
Log timestamp low value in the transaction log table |
opid_page |
int |
Identifies the operation ID page in the transaction log table |
opid_row |
smallint |
Identifies the operation ID row in the transaction log table |
op_code |
tinyint |
Identifies type of operation |
op_xstat |
int |
Identifies operation as either update or delete |
image_type_ |
char(1) |
Identifies operation type or procedure execution |
col1 |
Specified in primary object |
Column for a published field in the primary object |
... coln |
... |
... Additional column for each published field in the primary object |
The shadow table column for each published field has the datatype of the published field, and each row contains the data from that primary column for the transaction operation identified by that row.
