User Guide

10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

UST Data Types

The following tables show the data types supported for the various database types, and what they are converted to for storage in the IDT.

The first column shows the native data types that can be read from User Source Tables.

The second column shows the equivalent DCE data type. Data read from USTs are converted to a common data type to enable combining source data from multiple different database management systems.

Oracle

UST Data Type	DCE Data Type
	F
CHAR VARCHAR2 NUMBER (scale > 0) DATE ⁶	C
	V
	B
	I
	G
NUMBER (scale=0) INT SMALLINT	N
	R
	X
	Z

⁶ DATEs are converted to C(64) fields by default. The length may be overridden. The default installation date mask determines the date’s format. This is specified either explicitly with the initialization parameter

NLS_DATE_FORMAT

or implicitly with the initialization parameter

NLS_TERRITORY

. It can also be set for a session with the

ALTER SESSION

command.

UDB

UST Data Type	DCE Data Type
	F
CHAR VARCHAR DATE⁷ TIMESTAMP NUMBER (scale > 0)	C
	V
	B
	I
	G
NUMBER (scale=0) DECIMAL INTEGER SMALLINT BIGINT	N
	R
	X
	Z

⁷DATEs are converted to C(64) fields by default. The length may be overridden.

ODBC / Microsoft SQL Server

UST Data Type	DCE Data Type
SQL_CHAR	F
SQL_VARCHAR SQL_DATE⁸ SQL_TIME SQL_TIMESTAMP SQL_TYPE_DATE SQL_TYPE_TIME SQL_TYPE_TIMESTAMP SQL_NUMERIC⁹ SQL_DECIMAL⁹ SQL_FLOAT SQL_REAL SQL_DOUBLE SQL_GUID	C
SQL_BINARY SQL_VARBINARY	B
SQL_NUMERIC¹⁰ SQL_DECIMAL¹⁰ SQL_INTEGER SQL_SMALLINT SQL_TINYINT SQL_BIGINT	N