The following table lists the data types supported by Datareplicator.

Table 1-6 Data types supported by Datareplicator

Classification	Data type of column subject to data linkage
Numeric type	INTEGER, SMALLINT, DECIMAL, LARGEDECIMAL, FLOAT, SMALLFLT
Character type	CHAR#3, VARCHAR#3, NCHAR, NVARCHAR, MCHAR, MVARCHAR
Date type	DATE, TIME, TIMESTAMP, INTERVAL YEAR TO DAY, INTERVAL HOUR TO SECOND
Abstract data type#1	SGMLTEXT, FREEWORD, XML
Special type#2	BLOB, BINARY

Note 1:

Datareplicator performs data linkage even on columns that have not been updated as if those columns have been updated with the same values. However, data linkage is not performed on columns of the following data types if they have not been updated:

• VARCHAR type (256 bytes or greater)
• NVARCHAR type (128 characters or greater)
• MVARCHAR type (256 bytes or greater)
• BLOB type
• BINARY type (256 bytes or greater)
• Abstract data type (SGMLTEXT, FREEWORD, XML)

Note 2:

• Datareplicator can extract data, even when a repetition column is created for a data type. For details about data linkage for a table containing repetition columns, see 1.4.3 Data linkage for a table containing repetition columns.
• LONG VARCHAR, LONG NVARCHAR, and LONG MVARCHAR are recognized as VARCHAR, NVARCHAR, and MVARCHAR, respectively.

Note 3:

To perform data linkage on the characters of JIS standard levels 3 and 4, some conditions must be satisfied. For details, see 2.10.3 Support of JIS standard level 3 and level 4 character sets.

#1

Some rules apply to data linkage on abstract data types. For details, see 1.4.2 Data linkage for a table using an abstract data type.

#2

Some rules apply to data linkage on BLOB and BINARY types. For details, see 1.4.4 Data linkage for tables using BLOB and BINARY type columns.

#3

Data linkage can be performed even when a character set is specified, provided that the same character set is specified for the source and the target columns. For details about character sets, see the description of EBCDIK in 4.3.5 Designing for character code sets.

When the target system is a HiRDB, the data type of a column extracted by Datareplicator is imported as the same data type. For details about the data types when data is imported into XDM/RD, see the VOS3 XDM/DS manual and the applicable database manual. For details about the data type relationships between the source/target systems and Datareplicator, see 4.3.4 Designing for the supported data types.