Tables C-5 to C-7 show data type correspondence (foreign DB: ORACLE).

Table C-5 Data type correspondence (foreign DB: ORACLE) (1/3)

Data type of ORACLE (Foreign DB)			Data type of HiRDB
			SI	INT	DEC(m,n) 1 m 29, 0 n m	SFLT or REAL1	FLT or DP1	CH(n) 1 n 255
NUMBER(p,s) p: Precision s: Scaling	s = 0 or omitted	p = * or omitted9	M2	R3	M6, 7		M	M
	s = 0, omitted, or -28 s -1	1 p - s 4	R4	M4	M6, 7		M	M
		5 p - s 9		R5	M6, 7		M	M
		10 p - s 29			R6, 7		M	M
		30 p - s 38					M	M
	1 s 29	1 p 29			R7, 8		M	M
		p 30					M	M
	s 30 or s - 29					M		M
CHAR(n)	1 n 255						R1, 6
	256 n 2,000
VARCHAR2(n)	1 n 255
	256 n 4,000
NCHAR(n) (2-byte fixed-width national character set)	1 n 127
	128 n 1,000
NCHAR(n) (Variable-width national character set)	1 n 255
	256 n 2,000
NVARCHAR2(n) (2-byte fixed-width national character set)	1 n 127
	128 n 2,000
NVARCHAR2(n) (Variable-width national character set)	1 n 255
	256 n 4,000
LONG(n)	1 n 255
	256 n 32,000
	32,001 n 2,000,000,000
DATE								D4, 6
RAW(n)	1 n 255
	256 n 2,000
RAW(n)	1 n 255
	256 n 2,000
LONG RAW(n)	1 n 255
	256 n 32,000
	32,001 n 2,000,000,000
ROWID
MLSLABEL
CLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
NCLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
BLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000

Legend:

R: Recommended data type

M: Mappable data type

D: This is a mappable data type if Y is specified in the pd_hb_use_describe operand of the foreign server information definition.

Blank: Not mappable data type

SI: SMALLINT

INT: INTEGER

DEC: DECIMAL

SFLT: SMALLFLT

FLT: FLOAT

DP: DOUBLE PRECISION

CH: CHAR

¹ The precision of values that can be represented may be reduced. The scope and precision of values on HiRDB are hardware-dependent.

² The allowable range is limited to between -32,768 and 32,767.

³ The allowable range is limited to between -2,147,483,648 and 2,147,483,647.

⁴ The allowable range is limited to between -9,999 and 9,999.

⁵ The allowable range is limited to between -999,999,999 and 999,999,999.

⁶ If s < 0, let DECIMAL(m,n) be DECIMAL(p - s,0). In this case, the lower (-s) digit is 0. If s = 0 or the operand is omitted, let DECIMAL(m,n) be DECIMAL(p,0).

Example: If NUMBER(4,-3)=nnnn000, it will be DECIMAL(7,0) under HiRDB.

⁷ If the number of digits in the integer part is less than the data type of HiRDB, rows cannot be acquired from the foreign server.

If the number of digits in the fractional part is less than the data type of HiRDB, data is acquired by truncating any excess fractional part to match the number of digits in the fractional part of the data type of HiRDB.

If the number of digits in the integer or fractional part is larger than the data type of HiRDB, the expanded part is zero-filled to match the number of digits in the data type of HiRDB, and data is acquired.

⁸ If p < s, let DECIMAL(m,n) be DECIMAL(s,s). In this case, the lower (s - p) digit will be 0. If p s, let DECIMAL(m,n) be DECIMAL(p,s).

Example: If NUMBER(4,5)=0.01234, it is DECIMAL(5,5) under HiRDB.

⁹ The data type of HiRDB to be mapped should be determined depending on the intended application. When mapping to the DECIMAL type, specify the precision (m) and the scaling (n) for the foreign table definition according to the data precision (p) and the scaling (s) used on the foreign server.

Table C-6 Data type correspondence (foreign DB: ORACLE) (2/3)

Data type of ORACLE (Foreign DB)			Data type of HiRDB
			VCH (n) 1 n 255	MCH (n) 1 n 255	MVC (n) 1 n 255	NCH (n) 1 n 127	NVC (n) 1 n 127	DATE
NUMBER(p,s) p: Precision s: Scaling	s = 0 or omitted	p = * or omitted
	s = 0, omitted, or -28 s -1	1 p - s 4
		5 p - s 9
		10 p - s 29
		30 p - s 38
	1 s 29	1 p 29
		p 30
	s 30 or s -29
CHAR(n)	1 n 255			R2, 5
	256 n 2,000
VARCHAR2(n)	1 n 255		R1, 5		R2, 5
	256 n 4,000
NCHAR(n) (2-byte fixed-width national character set)	1 n 127					R5
	128 n 1,000
NCHAR(n) (Variable-width national character set)	1 n 255					R3, 5
	256 n 2,000
NVARCHAR2(n) (2-byte fixed-width national character set)	1 n 127							R5
	128 n 2,000
NVARCHAR2(n) (Variable-width national character set)	1 n 255							R5
	256 n 4,000
LONG(n)	1 n 255				R1, 4, 5			R2, 4, 5
	256 n 32,000
	32,001 n 2,000,000,000
DATE								R1
RAW(n)	1 n 255
	256 n 2,000
LONG RAW(n)	1 n 255
	256 n 32,000
	32,001 n 2,000,000,000
ROWID
MLSLABEL
CLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
NCLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
BLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000

Legend:

R: Recommended data type

Blank: Non-mappable data type

VCH: VARCHAR

MCH: MCHAR

MVC: MVARCHAR

NCH: NCHAR

NVC: NVARCHAR

Note

If a character type of 255 bytes is defined for columns with 256 bytes or greater on the foreign server, only up to 255 bytes of data can be acquired.

¹ Data not containing double-byte characters is treated as the recommended data type.

² Data containing double-byte characters is treated as the recommended data type.

³ The definition data length of columns in the foreign table should be n 2.

⁴ Specifying an applicable column in any of the following locations may result in an error on the foreign DB:

• GROUP BY clause
• ORDER BY clause
• DISTINCT operator
• Functions
• Expressions
• Conditions

⁵ If there is no specification, make the definition length of the data type of the foreign server equal to that of HiRDB.

If the definition length (length = n bytes, n 255) of the data type of HiRDB is less than the actual length of the data type of the foreign server, only the first n bytes are acquired.

If the definition length of the data type of HiRDB is greater, the data is inserted left-justified and any excess length is blank-filled (double-byte spaces for national character strings, single-byte spaces for character strings or mixed character strings), provided that HiRDB is of a fixed-length data type.

If HiRDB is of a variable-length data type, the data is acquired "as is."

Table C-7 Data type correspondence (foreign DB: ORACLE) (3/3)

Data type of ORACLE (Foreign DB)			Data type of HiRDB
			TIME	TSTAMP(p) p = 0, 2, 4, or 6	INTERVAL YEAR TO DAY	INTERVAL HOUR TO SECOND	BIN (n) 1 n 255
NUMBER(p,s) p: Precision s: Scaling	s = 0 or omitted	p = * or omitted
	s = 0, omitted, or -28 s -1	1 p - s 4
		5 p - s 9
		10 p - s 29
		30 p - s 38
	1 s 29	1 p 29
		p 30
	s 30 or s -29
CHAR(n)	1 n 255
	256 n 2,000
VARCHAR2(n)	1 n 255
	256 n 4,000
NCHAR(n) (2-byte fixed-width national character set)	1 n 127
	128 n 1,000
NCHAR(n) (Variable-width national character set)	1 n 255
	256 n 2,000
NVARCHAR2(n) (2-byte fixed-width national character set)	1 n 127
	128 n 2,000
NVARCHAR2(n) (Variable-width national character set)	1 n 255
	256 n 4,000
LONG(n)	1 n 255
	256 n 32,000
	32,001 n 2,000,000,000
DATE				R2
RAW(n)	1 n 255
	256 n 2,000
LONG RAW(n)	1 n 255						R3, 4
	256 n 32,000
	32,001 n 2,000,000,000
ROWID
MLSLABEL
CLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
NCLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000
BLOB(n)	1 n 1,999,999,999
	2,000,000,000 n 4,000,000,000

Legend:

R: Recommended data type

Blank: Not mappable data type

TSTAMP: TIMESTAMP

BIN: BINARY

¹ Hour, minute, and second are truncated.

² When mapping to the TIMESTAMP type, either specify 0 in the precision p or omit this operand.

³ When mapping to the BINARY type, specify a value greater than or equal to the actual length (in bytes) of the longest data element that is stored in ORACLE.

⁴ If there is no specification, make the definition length of the data type of the foreign server equal to that of HiRDB.

If the definition length (length = n bytes, n 255) of the data type of HiRDB is less than the actual length of the data type of the foreign server, only the first n bytes are acquired.

If the definition length of the data type of HiRDB is greater, the data is inserted left-justified and any excess length is blank-filled (double-byte spaces for national character strings, single-byte spaces for character strings or mixed character strings), provided that HiRDB is of a fixed-length data type.

If HiRDB is of a variable-length data type, the data is acquired "as is."