The staging server uses this table to track changes in the staging database.
Column Name | Column Type | Column Description |
---|---|---|
STGKEY1NAME | CHARACTER (32) NULL |
Column name for the unique index. |
STGKEY2NAME | CHARACTER (32) NULL |
Column name for the unique index. |
STGKEY3NAME | CHARACTER (32) NULL |
Column name for the unique index. |
STGKEY4NAME | CHARACTER (32) NULL |
Column name for the unique index. |
STGKEY5NAME | CHARACTER (32) NULL |
Column name for the unique index. |
STGLDCOLS | VARCHAR (4000) NULL |
Reserved for IBM internal use. |
STGLDPTH | VARCHAR (254) NULL |
Reserved for IBM internal use. |
STGMENBR | INTEGER NULL |
Indicates whether the table is a: 0 = site table or 1 = merchant table. |
STGMENBRNAME | CHARACTER (32) NULL |
Reserved for IBM internal use. |
STGNKEY1 | BIGINT NULL |
New column value for the unique index. |
STGNKEY2 | BIGINT NULL |
New column value for the unique index. |
STGNKEY3 | VARCHAR (254) NULL |
New column value for the unique index. |
STGNKEY4 | BIGINT NULL |
New column value for the unique index. |
STGNKEY5 | VARCHAR (254) NULL |
New column value for the unique index. |
STGOKEY1 | BIGINT NULL |
Old column value for the unique index. |
STGOKEY2 | BIGINT NULL |
Old column value for the unique index. |
STGOKEY3 | VARCHAR (254) NULL |
Old column value for the unique index. |
STGOKEY4 | BIGINT NULL |
Old column value for the unique index. |
STGOKEY5 | VARCHAR (254) NULL |
Old column value for the unique index. |
STGOP | CHARACTER (1) NOT NULL |
The change operator: I = insert, U = update, D = delete. |
STGPKEY | BIGINT NULL |
The value of the primary key. |
STGPKEYNAME | CHARACTER (32) NULL |
The name of the primary key. |
STGPROCESSED | INTEGER NULL, DEFAULT 0 |
0 = not processed, 1 = processed. |
STGRESERVED1 | INTEGER NULL, DEFAULT 0 |
Reserved for IBM internal use. |
STGRFNBR | BIGINT NOT NULL |
The reference number for the staging row. |
STGSTMP | TIMESTAMP NOT NULL |
The time stamp. |
STGTABLE | CHARACTER (10) NOT NULL |
The name of the table with staged changes. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035107590 | STGRFNBR | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|