DataSync settings are accessed from the Gear menu
Convert
LOBs to VARCHAR or VARBINARY
This setting tells DataSync to change LOBs to either VARCHAR or VARBINARY
depending on the data. Enter the target column size (default is 1024).
This is the default setting. When set, Preserve LOBs will not be set.
Preserve
LOBs
This setting tells DataSync to send LOBs to the target without converting
them to VARCHAR or VARBINARY. When set, incremental updates will not
be allowed and only full loads will be supported. When set, Convert
LOBs to VARCHAR or VARBINARY will not be set.
Treat
CHAR as CLOB on Target Table
If your target data base does not support very large character fields,select
Treat CHAR as CLOB on Target Table and enter the field size. The default
value is 1024 but there is no minimum or maximum value.
Treat
CHAR as VARCHAR on Target Table
If character fields are long and not fully populated, select Treat
CHAR as VARCHAR on Target Table and enter the field size.
Note: The field should contain
at least 5 characters as there is minimal space savings for short
CHAR fields.
Example: If the source table
has a CHAR(100) field that averages 10 characters in length, it will
be transformed into a VARCHAR(100) field on the target table after
the synchronization. This could save an average of 90 characters per
row.
Maximum
Number/Decimal Precision
Enter the maximum numeric or decimal precision value in Maximum Numeric/Decimal
Precision.