CAPI_SRC_DFLT=(
source_type
              ,
capi_connection_name)

source_type

Required. The CDC source type. The following table identifies the valid source-type options:

Option	Source Type
ADA	Adabas sources
AS4	Db2 for i (i5/OS) sources
CAPX	Sources for which you are extracting data in continuous extraction mode and using the PowerExchange Logger for Linux, UNIX, or Windows or PowerExchange Condense
DB2	Db2 for z/OS sources
DCM	CA Datacom sources
HAN	SAP HANA CDC sources
IDL	CA IDMS/DB log-based CDC sources
IML	IMS log-based CDC sources
IMS	IMS synchronous CDC sources
MSS	Microsoft SQL Server sources
MYS	MySQL sources
ORA	Oracle sources
PGS	PostgreSQL sources
UDB	Db2 sources on Linux, UNIX, or Windows
VSAM or VSM	VSAM sources

capi_connection_name

Required. Unique name of the CAPI_CONNECTION statement to use as the default for the specified source type. This name must match the NAME value in a CAPI_CONNECTION statement that has a TYPE value that is compatible with the CAPI_SRC_DFLT

source_type

.

The following table shows, for each CAPI_SRC_DFLT option, the compatible CAPI_CONNECTION type:

CAPI_SRC_DFLT Option	CAPI_CONNECTION Statement Type
AS4	UOWC
CAPX	CAPX
ADA, DB2, DCM, IDL, IDM, IML, IMS, VSAM, or VSM	UOWC
HAN	HANA
ORA	ORAD for PowerExchange Express CDC for Oracle
MSS	MSQL
MYS	MYSQL
PGS	PG
UDB	UDB

If you define multiple CAPI_CONNECTION statements for a source type, you can define a CAPI_SRC_DFLT statement to identify the default CAPI_CONNECTION for that source type. The CAPI_SRC_DFLT statement must point to a CAPI_CONNECTION statement of a compatible type.
You can optionally define a CAPI_CONN_NAME statement that specifies an overall default statement, out of all of the CAPI_CONNECTION statements in the DBMOVER file.
Instead of or in addition to specifying defaults, you can use the following CAPI connection name overrides to point to a specific CAPI_CONNECTION statement for CDC sessions or database row tests:
For CDC sessions, use the
CAPI Connection Name Override
attribute on the PWX CDC application connection.
For PowerExchange Condense, use the CONN_OVR parameter in CAPTPARM configuration file.
For the PowerExchange Logger for Linux, UNIX, and Windows, use the CONN_OVR parameter in pwxccl.cfg configuration file.
For DTLUAPPL utility operations that generate restart tokens, use the CONN_OVR parameter in the DTLUAPPL control statement.
For CAPXRT database row tests in the PowerExchange Navigator, use the
CAPI Connection Name
value in the
CAPXRT Advanced Parameters
dialog box. If you add an SQL statement for generating restart tokens, you can include the CONNAME parameter to point to the override CAPI_CONNECTION.
For PowerExchange ODBC connections, use the DTLCONN_OVR parameter in the odbc.ini file or the SQL escape sequence override DTLCONNOVR.