SPACESTONULL | NOSPACESTONULL
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);