This section discusses the data types that can be converted during the import operation.
Tables 3-10 and 3-11 list the data types that HiRDB Dataextractor can convert. When it imports data, HiRDB Dataextractor compares a column to be extracted with the column to be imported and executes data type conversion if they constitute any of the combinations listed in Tables 3-10 and 3-11. When it selects a row to be extracted, HiRDB Dataextractor compares the specified data if the conditions in the table expression specification file match the appropriate combination of data types listed in Tables 3-10 and 3-11.
Table 3-10 Data types that HiRDB Dataextractor can convert (1/2)
| Data type on source system (ORACLE's interval data type) |
Data type on target system (HiRDB) |
Numeric data8
INT, SMALLINT, DECIMAL, FLOAT,
SMALLFLT |
Character string data, Mixed character string data5,7
CHAR, VARCHAR, MCHAR, MVARCHAR |
National character data6,7
NCHAR, NVARCHAR |
Date data
DATE |
Time data
TIME |
| NUMBER |
Y |
Y |
-- |
-- |
-- |
CHAR
VARCHAR2 |
Y1 |
Y |
Y |
-- |
-- |
NCHAR
NVARCHAR2 |
-- |
Y |
Y |
-- |
-- |
| DATE4 |
-- |
Y |
-- |
Y2 |
Y3 |
| LONG |
-- |
-- |
-- |
-- |
-- |
| LONG RAW |
-- |
-- |
-- |
-- |
-- |
| RAW |
-- |
-- |
-- |
-- |
-- |
BLOB
CLOB
NCLOB
BFILE |
-- |
-- |
-- |
-- |
-- |
Table 3-11 Data types that HiRDB Dataextractor can convert (2/2)
| Data type on source system (ORACLE's interval data type) |
Data type on target system (HiRDB) |
Date interval data
YEAR |
Time interval data
HOUR |
Time stamp data
TIMESTAMP |
Large object data9
BLOB, BINARY |
Abstract data type
SGMLTEXT |
| NUMBER |
-- |
-- |
-- |
-- |
-- |
CHAR
VARCHAR2 |
-- |
-- |
-- |
-- |
-- |
NCHAR
NVARCHAR2 |
-- |
-- |
-- |
-- |
-- |
| DATE4 |
Y2 |
Y3 |
Y10 |
-- |
-- |
| LONG |
-- |
-- |
-- |
Y |
-- |
| LONG RAW |
-- |
-- |
-- |
Y |
-- |
| RAW |
-- |
-- |
-- |
Y |
-- |
BLOB
CLOB
NCLOB
BFILE |
-- |
-- |
-- |
Y |
-- |
Y: Can be converted.
--: Cannot be converted.
- 1 To convert data with the character attribute to numeric data, the data must consist of single-byte numeric characters.
- 2 HiRDB Dataextractor only retrieves date information. If date information represents a B.C. year, HiRDB Dataextractor assumes an error and cancels processing.
- 3 HiRDB Dataextractor only retrieves time information.
- 4 To convert a single column with the DATE attribute to two columns, such as date data and time data, you must extract the column with the DATE attribute twice.
- 5 You should note the following when you execute with this combination:
- If the data on the source system is shorter than the data on the target system, HiRDB Dataextractor sets one-byte space characters.
- HiRDB Dataextractor stores the data from the source system into the target system as is.
- 6 You should note the following when you execute with this combination:
- The data length on the source system must be equal to or less than 2 times the number of characters on the target system.
- If the data on the source system is shorter than the data on the target system, HiRDB Dataextractor sets two-byte space characters.
- If the data on the source system consists of an odd number of bytes, HiRDB Dataextractor adds a one-byte space character to it so as to make the length to an even number of bytes.
- 7 Data truncation occurs in the following cases:
- If a nonzero value is specified in the XTERRLEVEL environment variable, processing depends on the specified value:
- Character string, mixed character string, or national character string data:
Data length on the source system > data length on the target system
- 8 Data truncation occurs in the following cases:
- Decimal data:
Length of integer part on the source system > length of the integer part on the target system
- 9 Data conversion is not supported if the data on the source system is longer than the data on the target system. However, if the XTLOBBUFSIZE environment variable is specified, HiRDB Dataextractor processes the data according to the specification of the XTERRLEVEL environment variable.
- 10 An error results if the date information is in the BC range. If decimal places for the seconds are defined at the target (other than TIMESTAMP(0)), the data is padded with trailing 0x00.
All rights reserved. Copyright (C) 2007, Hitachi, Ltd.
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)