WebSphere Commerce database table: STAGLOG

Reference > Database > WebSphere Commerce database tables > S

WebSphere Commerce database table: STAGLOG

This table holds a log of changes made on the staging server so that the changes can be propagated to the production server using the stagepropagate command.

Column Name Column Type Description
STGRFNBR BIGINT NOT NULL The reference number for the staging row.
STGSTMP TIMESTAMP NOT NULL The time stamp.
STGTABLE CHAR(18) NOT NULL The name of the table with staged changes.
STGOP CHAR(1) NOT NULL The change operator:

I

insert

U

update

D

delete

STGMENBRNAME CHAR(32) Reserved for IBM internal use.
STGMENBR INTEGER Indicates whether the table is a:
0 = site table or 1 = merchant table.
STGPKEYNAME CHAR(32) The name of the primary key.
STGPKEY BIGINT The value of the primary key.
STGKEY1NAME CHAR(32) First column name for the unique index of the table defined in STGTABLE. For example, if STGTABLE is 'catentry', then STGKEY1NAME is 'partnumber'
STGKEY2NAME CHAR(32) Second column name for the unique index of the table defined in STGTABLE. For example, if STGTABLE is 'catentry', then STGKEY1NAME is 'member_id'.
STGKEY3NAME CHAR(32) Third column name for the unique index of the table defined in STGTABLE.
STGKEY4NAME CHAR(32) Fourth column name for the unique index of the table defined in STGTABLE.
STGKEY5NAME CHAR(32) Fifth column name for the unique index of the table defined in STGTABLE.
STGOKEY1 BIGINT Old value for first column of the unique index.
STGOKEY2 BIGINT Old value for second column of the unique index.
STGOKEY3 VARCHAR(254) Old value for third column of the unique index.
STGOKEY4 BIGINT Old value for fourth column of the unique index.
STGOKEY5 VARCHAR(254) Old value for fifth column of the unique index.
STGNKEY1 BIGINT New value for first column of the unique index.
STGNKEY2 BIGINT New value for second column of the unique index.
STGNKEY3 VARCHAR(254) New value for third column of the unique index.
STGNKEY4 BIGINT New value for fourth column of the unique index.
STGNKEY5 VARCHAR(254) New value for fifth column of the unique index.
STGPROCESSED INTEGER DEFAULT 0 Indicate if the corresponding record has been processed by StagingProp. 0 = not processed, 1 = processed.
STGRESERVED1 INTEGER DEFAULT 0 Reserved for IBM internal use.
STGLDPTH VARCHAR(254) Reserved for IBM internal use.
STGLDCOLS VARCHAR(4000) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
STGFILTER INTEGER This column is used for Staging by filter value. When a filter value is specified in StagingProp parameters, all the corresponding STAGLOG records with this STGFILTER value matching the filter value will be processed.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030430030 STGRFNBR Primary Key

Related reference

Stage server data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
STGRFNBR	BIGINT NOT NULL	The reference number for the staging row.
STGSTMP	TIMESTAMP NOT NULL	The time stamp.
STGTABLE	CHAR(18) NOT NULL	The name of the table with staged changes.
STGOP	CHAR(1) NOT NULL	The change operator: I insert U update D delete
STGMENBRNAME	CHAR(32)	Reserved for IBM internal use.
STGMENBR	INTEGER	Indicates whether the table is a: 0 = site table or 1 = merchant table.
STGPKEYNAME	CHAR(32)	The name of the primary key.
STGPKEY	BIGINT	The value of the primary key.
STGKEY1NAME	CHAR(32)	First column name for the unique index of the table defined in STGTABLE. For example, if STGTABLE is 'catentry', then STGKEY1NAME is 'partnumber'
STGKEY2NAME	CHAR(32)	Second column name for the unique index of the table defined in STGTABLE. For example, if STGTABLE is 'catentry', then STGKEY1NAME is 'member_id'.
STGKEY3NAME	CHAR(32)	Third column name for the unique index of the table defined in STGTABLE.
STGKEY4NAME	CHAR(32)	Fourth column name for the unique index of the table defined in STGTABLE.
STGKEY5NAME	CHAR(32)	Fifth column name for the unique index of the table defined in STGTABLE.
STGOKEY1	BIGINT	Old value for first column of the unique index.
STGOKEY2	BIGINT	Old value for second column of the unique index.
STGOKEY3	VARCHAR(254)	Old value for third column of the unique index.
STGOKEY4	BIGINT	Old value for fourth column of the unique index.
STGOKEY5	VARCHAR(254)	Old value for fifth column of the unique index.
STGNKEY1	BIGINT	New value for first column of the unique index.
STGNKEY2	BIGINT	New value for second column of the unique index.
STGNKEY3	VARCHAR(254)	New value for third column of the unique index.
STGNKEY4	BIGINT	New value for fourth column of the unique index.
STGNKEY5	VARCHAR(254)	New value for fifth column of the unique index.
STGPROCESSED	INTEGER DEFAULT 0	Indicate if the corresponding record has been processed by StagingProp. 0 = not processed, 1 = processed.
STGRESERVED1	INTEGER DEFAULT 0	Reserved for IBM internal use.
STGLDPTH	VARCHAR(254)	Reserved for IBM internal use.
STGLDCOLS	VARCHAR(4000)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
STGFILTER	INTEGER	This column is used for Staging by filter value. When a filter value is specified in StagingProp parameters, all the corresponding STAGLOG records with this STGFILTER value matching the filter value will be processed.