Supported DDL Operations for DB2 for Linux, UNIX, and Windows Sources
Supported DDL Operations for DB2 for Linux, UNIX, and Windows Sources
The Extractor for DB2 for Linux, UNIX, and Windows sources can process the following DDL operations:
ALTER TABLE
table_name
ADD
column_name
datatype
[NULL|NOT NULL]
ALTER TABLE
table_name
ADD CONSTRAINT
constraint_name
{PRIMARY KEY|UNIQUE} (
column_name
)
ALTER TABLE
table_name
ALTER COLUMN
column_name
SET DATA TYPE
datatype
ALTER TABLE
table_name
ALTER COLUMN
column_name
SET NOT NULL
ALTER TABLE
table_name
ALTER
column_name
DROP NOT NULL
ALTER TABLE
table_name
DROP
column_name
ALTER TABLE
table_name
DROP CONSTRAINT
constraint_name
CREATE [UNIQUE] INDEX
index_name
ON
table_name
CREATE TABLE
table_name
(
column_name
datatype
[NULL|NOT NULL] [PRIMARY KEY] [UNIQUE])
CREATE TABLE
table_name
AS (
SELECT statement
)
CREATE TABLE
table_name
LIKE
table_name
DROP INDEX
index_name
DROP TABLE
table_name
TRUNCATE TABLE
table_name
The Applier processes the CREATE INDEX statement only if this statement creates an index in the same schema as the parent table.
When a CREATE TABLE AS (SELECT...) operation occurs on the source, Data Replication creates a target table using the appropriate CREATE TABLE statement. After you execute REFRESH statements for the source table, Data Replication begins applying DML operations to the target table.