Store schema

A store schema is the table where the JDBCStore service keeps the records describing the transactions that could not be executed online.

The structure of the STORE table is defined at table creation time, and is provided as an argument to the table generator method. Two noteworthy columns in the STORE table are: DSERECID, which holds the record identification, and DSERECMK, which holds the record mark defining the record status. The DSERECID column is the primary key for accessing the STORE table. DSERECMK can have the values added, updated, and retrievedForForwarding (referenced by name within the code, but converted to an integer value using the StoreConstants class), while concrete implementations can define more values. The other columns are specified at creation time by passing the column definition, using the same format required by the standard SQL CREATE TABLE statement. The column types allowed are the ones allowed by DB2® when using the JDBC drivers to access the database (see Database services for more information).