When you create a primary article for a stored procedure, ASE Replicator creates
a shadow table with the columns described in Table A-19.
Table A-19: Shadow table for procedure
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
|
p1
|
Specified in primary object
|
Column for a published field in the primary
object
|
...
pn
|
...
|
...
Additional column for each published field in the primary
object
|
The shadow table column for each published field has the datatype
of the published procedure parameter, and each row contains the
data from that parameter for the procedure invocation identified
by that row.
The replicate article for a procedure may subscribe
to none of the published fields in the primary article, so the shadow
table for such a replicate article may contain no columns for published
fields.
