The MYSQL CAPI_CONNECTION statement in the DBMOVER configuration file can now include the following parameters in support of the new DDL-updated catalog of MySQL source table definitions:
CATSERVER=
server_name
Optional. The name of the server that contains the DDL-updated catalog tables that store source table definitions.
Default is the MySQL source server name. You can use the default if you created the catalog tables and installed the MySQL ODBC drivers on the source server.
CATSCHEMA=
schema_name
Required. The name of the schema for the DDL catalog tables.
CATUSERNAME=
user_name
Optional. A user name that is used to connect to the catalog server.
Default is the MySQL source user name if the catalog tables exist on the source server.
CATEPASSWORD=
encrypted_password
Optional. The encrypted password of the specified catalog user. Specify either CATEPASSWORD or CATPASSWORD but do not specify both parameters.
Default is the password of the MySQL source user if the catalog tables exist on the source server.
CATPASSWORD=
password
Optional. The clear-text password of the specified catalog user. Specify either CATPASSWORD or CATEPASSWORD but do not specify both parameters.
Default is the password of the MySQL source user if the catalog tables exist on the source server.
ONTABLEDDL={WARN|
WARN-UNTIL-EOL
|FAIL}
Optional. Indicates whether PowerExchange issues a warning message and continues processing or ends abnormally when it encounters a DDL record for a source that is not consistent with the source registration. Options are:
WARN. Issue a warning message and continue capture processing.
WARN-UNTIL-EOL. Issue a warning message and continue capture processing until the end-of-log (EOL). Then issue an error message and terminate capture processing.
FAIL. Issue an error message and terminate capture processing.
Default is WARN-UNTIL-EOL.
For more information, see the "DBMOVER Configuration File" chapter of the