Teradata - 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

Connect CDC supports several data types. 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

NumericLength

Display Length

BIGINT

Integral Numeric

19

20

BYTEINT

Integral Numeric

3

4

CHAR

Character

 

Max length=64K

DATE

Date

 

10

DECIMAL a

Decimal Numeric

 

 

DOUBLE PRECISION b

ApproximateNumeric

 

 

INTEGER

Integral Numeric

10

11

LONG VARCHAR

Character

 

Max Length=64K

SMALLINT

Integral Numeric

 

6

TIME(P) c

Time

 

8

TIMESTAMP(P) d

Date/Interval

 

26

VARCHAR

Character

 

Max Length=64K

aIncludes NUMERIC

bIncludes FLOAT and REAL

cTIME WITH TIME ZONE is not supported

dTIMESTAMP with Time Zone is not supported