When you migrate an existing HiRDB system to another HiRDB system, you must also migrate data from the existing system to the other system. If the source and target systems use different endians, pdload can convert the endian for input data files and then load the data into the target system. In such a case, you must use pdrorg to specify as the input data file a file unloaded in binary format (pdrorg-output binary file). The figure below provides an overview of data migration between platforms that use different endians.
Figure 5-6 Overview of data migration between the platforms that use different endians
For details about a pdrorg-output binary file, see 5.5.6 pdrorg-output binary files.
Endian conversion is performed on numeric data and numeric type data contained in the control information in the input data. Table 5-3 Whether endian conversion is performed (FIX table) and Table 5-4 Whether endian conversion is performed (non-FIX table) show when endian conversion is performed on input data for a FIX table and for a non-FIX table.
Table 5-3 Whether endian conversion is performed (FIX table)
Data type | Whether endian conversion is performed |
---|---|
INTEGER | Y |
SMALLINT | Y |
DECIMAL | N |
FLOAT#1 | Y |
SMALLFLT#1 | Y |
CHAR | N#2 |
NCHAR | N#2 |
MCHAR | N#2 |
DATE | N |
TIME | N |
TIMESTAMP | N |
INTERVAL YEAR TO DAY | N |
INTERVAL HOUR TO SECOND | N |
Table 5-4 Whether endian conversion is performed (non-FIX table)
Location | Data type | Whether endian conversion is performed |
---|---|---|
Length and offset of basic row data | -- | Y |
Column data value of predefined data type | INTEGER | Y |
SMALLINT | Y | |
DECIMAL | N | |
FLOAT#1 | Y | |
SMALLFLT#1 | Y | |
CHAR | N#2 | |
VARCHAR | R#2 | |
NCHAR | N#2 | |
NVARCHAR | R#2 | |
MCHAR | N#2 | |
MVARCHAR | R#2 | |
DATE | N | |
TIME | N | |
TIMESTAMP | N | |
INTERVAL YEAR TO DAY | N | |
INTERVAL HOUR TO SECOND | N | |
BINARY | R#2 | |
BLOB | R#2 | |
Data value of argument of constructor function | INTEGER | Y |
SMALLINT | Y | |
FLOAT#1 | Y | |
SMALLFLT#1 | Y | |
CHAR | N#2 | |
VARCHAR | R#2 | |
NCHAR | N#2 | |
NVARCHAR | R#2 | |
MCHAR | N#2 | |
MVARCHAR | R#2 | |
BINARY | R#2 | |
BLOB | R#2 | |
Number of elements in repetition column | -- | Y |
Null value flag in repetition column | -- | N |
Repetition element value | -- | #3 |
Data value of BINARY argument | -- | N |
Data value of BINARY column | -- | N |
Data value of BLOB argument | -- | N#2 |
Data value of BLOB column | -- | N#2 |