To specify whether or not a null value is allowed in the replicate table for each text, unitext, image, or rawobject column, specify null or not null after the datatype for the column in the replication definition.
This setting must be consistent with the way the primary and replicate tables are defined. For text, unitext, image, and rawobject columns, the default is not null, meaning that the replicate table does not accept null values.
If you are using multiple replication definitions, the null value setting should be the same for all replication definitions on a primary table.
Do not specify null or not null for columns using datatypes other than text, unitext, image, or rawobject. Columns with null values cannot be searchable.
The following example replication definition for the table au_pix includes a column pic of datatype image, for which null values are allowed in replicate tables. The pic column is included in the replicate_if_changed clause.
create replication definition au_pix with primary at TOKYO_DS.pubs2 (au_id char(11), pic image null) primary key (au_id) replicate_if_changed (pic)
