CDC Guide for Linux, UNIX, and Windows

10.2
- 10.2.2
- 10.2.1
- 10.0

Back Next

Special Override Statement

Use a special override statement to specify or generate restart tokens for one or more sources.

You can use a special override statement to provide restart tokens for all sources in a CDC session. Also, you can use a special override statement in conjunction with explicit override statements.

When you warm start a CDC session, the special override statement overrides the restart tokens in the state table or state file for all sources except those specified in explicit override statements.

A special override statement is composed of a pair of RESTART1 and RESTART2 statements, as shown in the following syntax:

RESTART1={restart1_token|CURRENT_RESTART}
RESTART2={restart2_token|CURRENT_RESTART}

Specify only one set of these special override statements in the restart token file.

In RESTART1 and RESTART2 statements, use the following parameters to specify either a pair of sequence and restart token values or the current end of the change stream:

restart1_token: The sequence token portion of a restart token pair. This value varies based on data source type.
restart2_token: The restart token portion of a restart token pair. This value varies based on data source type.
CURRENT_RESTART: PowerExchange generates restart tokens for the current end of the change stream. The PWXPC CDC reader opens a separate connection to PowerExchange, requests the generation of current restart tokens, and then provides the token values to all applicable sources.

You can generate current restart tokens in the
Database Row Test
dialog box of the PowerExchange Navigator.

Use CURRENT_RESTART only for CDC sessions that use real-time extraction mode or continuous extraction mode.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Special Override Statement

Special Override Statement