Oracle - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

As shown below, Connect CDC supports distribution of most Oracle datatypes. In the tables of supported datatypes in the following pages, the Numeric Length column shows the maximum supported number of numeric digits, while Display Length is the maximum number of characters, or the numeric length plus an included sign, if any.

An asterisk (*) means the length is taken from the column definition in the DBMS catalog. For decimal numeric types, the length is the number of positions to the left of the decimal point. For example, a NUMERIC(10,2) column has a length of 8.

Related Topics:

Datatype

Category

Numeric

Length

DisplayLength

BLOB ab

Binary Large Object

 

 

CHAR

Character

 

*

CLOB ab

Character Large Object

 

 

DATE c

Date/Interval

 

26

FLOAT

Unicode

 

 

LONG ab

Long Character

 

 

LONG RAW ab

Long Binary

 

 

NCHAR d

Unicode

 

*

NCLOB

Unicode, Character Large Object e

 

 

NUMBER (38)

Integral Numeric

38

39

NUMBER (no precision or scale) f

FLOAT or INTEGER

 

 

NUMBER (p,s)

Decimal

*

 

NVARCHAR2 d

Unicode

 

*

RAW

Binary

 

 

TIMESTAMP dgh

Date/Interval

 

26

 VARCHAR2,CHARACTER VARYING

Character

 

*

aFor distribution to Oracle and MS SQL Server targets only. See Distributing Large Objects.

bBinary type or long type columns cannot be used in data enhancement, expres­sions or gate conditions.

cSee table for the supported range of dates.

dSupported for Oracle 10g and later.

eAdd the [Director] parameter OracleNCHARSupport=1 to the omnient.ini.

fSee Handling NUMBER (no p,s) as FLOAT or INTEGER  

gSupported for 0 to 6 fractional seconds.

hTIMESTAMP with Time Zone and TIMESTAMP with Local Time Zone datatypes are not supported.