Was this helpful?
Registered Tables Report
The Registered Table Report displays the status of all replicated tables. This report is created when you select Tables from the Resolver Reports Menu window.
Following is an example of the Registered Tables Report:
28-Feb-2003                                                           11:35:16
                              Ingres Replicator
                           Registered Tables Report
hq 10

-------------------------------------------------------------------------------
Table                            C S A     Priority Lookup Table
 CDDS                                      CDDS Lookup Table
  Column                         Data type                              D K R
-------------------------------------------------------------------------------
book_list                        C S A
  1 Inventory
  book_no                        integer not null with default          1  K  R
  title                          varchar(40) not null with default            R
  author                         varchar(25) not null with default            R
  price                          money not null with default                  R
  category                       varchar(12) not null with default            R
  stock                          smallint not null with default               R
  dist_no                        smallint not null with default               R

book_orders                      C S A
  0 Default CDDS
  order_no                       integer not null with default          1  K  R
  book_no                        integer not null with default          2  K  R
  sale_price                     money with null                              R
  quantity                       smallint with null                           R
  extension                      money with null                              R

cust_info                        C S A
  0 Default CDDS
  cust_no                        integer not null with default 1 K R
  name                           varchar(25) not null with default            R
  company                        varchar(25) with null                        R
  street                         varchar(20) not null with default            R
  city                           varchar(20) not null with default            R
  state                          char(2) not null with default                R
  zip                            char(10) not null with default               R
  card_no                        varchar(30) not null with default            R
  ep_date                        date not null with default                   R
  ship_to                        char(1) not null with default                R

cust_orders                      C S A
  0 Default CDDS
  order_no                       integer not null with default          1  K  R
  cust_no                        integer not null with default                R
  order_date                     date not null with default                   R
  status                         varchar(15) not null with default            R
  order_total                    money with null                              R

C - Columns Registered           D - Table Key Sequence
S - Support Objects Created      K - Replicated Key Column
A - Change Recording Activated R – Replicated Column
The Registered Tables Report has the following items:
Table
The name of the table.
CDDS
The number and name of the CDDS to which the table belongs.
Column
The name of the column.
C (Columns Registered)
Indicates that the columns are registered.
S (Support Objects Created)
Indicates that support objects are created.
A (Change Recording Activated)
Indicates that change recording has been activated.
Data type
The data type and declared length of the column.
Priority Lookup Table
The name of the priority lookup table assigned to the table, if defined.
CDDS Lookup Table
The name of the horizontal partitioning lookup table assigned to the table, if defined.
D (Table Key Sequence)
A number indicates that the column is a key column in the base table structure and indicates the column’s sequence in the key.
K (Replicated Key Column)
Indicates that the column is a key column for replication.
R (Replicated Column )
Indicates that the column is registered for replication.
Last modified date: 01/30/2023