Datatype conversion matrix - 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

The table below displays each Connect CDC datatype category and the categories to which it can be converted. The pages that follow contain sections for each category showing specific details by datatype and DBMS. These sections include exceptions to the general rules displayed in the table below.

Use the following key to interpret the information in the table below. “Display length” and “numeric length” are as defined for the tables on page 121 through page 318.

Abbreviation...

Equals...

rl

display length, receiving column

sl

display length, sending column

rnl

numeric length, receiving column

snl

numeric length, sending column

rp

precision, receiving column

sp

precision, sending column

rs

scale, receiving column

ss

scale, sending column

Converting from/to

Character or Long Character (rl)

Date/Interval

ApproximateNumeric

IntegralNumeric

DecimalNumeric

Binary or Long Binary

Unicode or Long Unicode

Character or Long Character (sl)

Yes(if sl > rl andchar -> char, warning on char, error on long char)

No

No

No

No

No

Some a

Date/Interval

Yes(if rl >= sl)

Yes b

No

No

No

No

No

Approximate Numeric

Yes(if rl >= 22)

No

Yes

Yes c 

Yes

No

No

Integral Numeric

Yes(if rl >= snl)

No

Yes

Yes

Yes(warn ifrp-rs < snl)

No

No

Decimal Numeric (sp, ss)

Yes

No

Yes

Yes(warn and truncate if sp-ss > rnl)

Yes(warn ifsp > rp or if ss > rs)

No

No

Binary orLong Binary

No

No

No

No

No

Some d

No

Unicode or Long Unicode

No

No

No

No

No

No

Some a

aSee Unicode Category .

bSee Date/Interval Category .

cOnly to INTEGER or NUMBER(38) datatypes.

dSee Binary Categories.