Use the SET CAPTURE SCHEMA command to set a
source and target Capture schema for all task commands. The default Capture
schema is ASN. You can use this command to change the default.
This command allows you to omit the Capture schema settings in the
task commands.
Syntax
>>-SET CAPTURE SCHEMA--+-SOURCE-+--+-TO--+-DEFAULT-+-+---------><
'-TARGET-' | '-NULLS---' |
'-capschema-------'
Parameters
- SOURCE
- Specifies the Capture schema at the source. The schema can be any valid DB2® schema
name.
- TARGET
- Specifies the Capture schema at the target (used for autoregistration
of replica or CCD target tables). The schema can be any valid DB2 schema name.
- DEFAULT
- Specify to set the Capture schema to ASN and to reset any previous SET
CAPTURE SCHEMA commands.
- NULLS
- Specify to set the Q Capture schema to NULL.
- capschema
- Specifies the name of a schema that generates the Capture control tables.
Example 1
To set the Capture schema to ASN by default:
SET CAPTURE SCHEMA SOURCE TO DEFAULT
Example 2
To set the Capture schema to ASN1:
SET CAPTURE SCHEMA SOURCE ASN1
SQL Replication