Using Two-Part Names
In a two-part name, you specify the schema and the object name. To map the catalog portion of the name, you must link it to an Extract or Replicat group. Only one catalog can be linked to an Extract or Replicat group. To capture from, or apply to, more than one catalog, you must create an Extract group for each one on the source and a Replicat group for each one on the target. To link a catalog to an Extract group, use the SOURCEDB
parameter. To link a catalog to a Replicat group, use the TARGETDB
parameter. The USERID
portion of SOURCEDB
and TARGETDB
specifies the default schema.
SOURCEDBcatalog
USERIDschema
TARGETDBcatalog
USERIDschema
Note:
The API that is used by Extract does not log in to the database, so an authentication password is not required.
Parent topic: Specifying Object Names in a SQL/MX Configuration