HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
1.4.3 Data linkage for a table containing repetition columns
Datareplicator allows you to link data in HiRDB repetition columns. A repetition column is a column that contains multiple elements per cell. With HiRDB, you can store a table column consisting of multiple elements per cell as a repetition column and access it by means of SQL statements, in the same manner as with conventional database tables.
![[Figure]](FIGURE/RZ01S133.GIF)
Note that Datareplicator can link data in units of a repetition column's cells, but not in units of its elements.
- Organization of this subsection
- (1) Correspondence of data types between source and target systems
(1) Correspondence of data types between source and target systems
To link data in a repetition column, the source and target systems must satisfy the following conditions:
- The repetition column must be defined at the source and target.
- The definitions of the repetition column (type name, number of attributes, attribute data type, number of element data items, and sequence of element data items) must be identical at the source and target.
Even when all these conditions are not satisfied, data linkage might be possible if an import information editing UOC routine is used, because it can edit the data.
- Note:
- Datareplicator does not check that these conditions are satisfied. The target HiRDB's data compatibility checking can determine whether valid data has been imported. If data import into the target HiRDB results in an error, Datareplicator outputs an error message and terminates import processing. The error handling procedure is the same as when compatibility checking on existing data types results in an error.
All rights reserved. Copyright (C) 2007, 2013, Hitachi, Ltd.