Valid For
Replicat on Oracle Database only
Description
Use the SPACESTONULL and NOSPACESTONULL parameters to control whether or not a source column that contains only spaces is converted to NULL in the target column. SPACESTONULL converts spaces to NULL if the target column accepts NULL values. NOSPACESTONULL converts spaces to a single space character in the target column.
This parameter is applicable to the follow two scenarios:
a source column that contains only spaces
a source column is empty, such as empty CHAR/VARCHAR column data from DB2
Oracle does not distinguish empty and NULL column though other databases do so you should consult your database documentation to determine how these types of columns.
The parameters are table specific. One parameter applies to all subsequent MAP statements, until the other parameter is encountered.
Because you can selectively enable or disable these parameters between MAP statements, you can enable or disable them for different threads of a coordinated Replicat. Specify the SPACESTONULL threads in one set of MAP statements, and specify the NOSPACESTONULL threads in a different set of MAP statements.
Default
NOSPACESTONULL
Syntax
SPACESTONULL | NOSPACESTONULL
Example
This example shows how you can apply SPACESTONULL and NOSPACESTONULL selectively to different MAP statements, each of which represents a different thread of a coordinated Replicat.
SPACESTONULL MAP sales.cust, TARGET sales.cust, THREAD (1); MAP sales.ord, TARGET sales.ord, THREAD (2); NOSPACESTONULL MAP sales.loc, TARGET sales.loc, THREAD (3);