Approximate numeric category - 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

Numerical precision with floating point numbers is dependent upon what the hardware can support. The greater the number of significant digits, the more likely you are to have problems maintaining accuracy.

When distributing data to a server of a different DBMS, the level of accuracy at the target may be different. Testing numbers that have large significance requirements is strongly recommended before you begin using them in a commercial environment.

The supported Approximate Numeric datatype mappings are shown in the table below.

DBMSs are abbreviated in the table as follows:

DBMS

Abbreviation

DB2/400 and UDB

DB2

Informix

INF

MS SQL Server

MSS

Oracle

ORA

PostgreSQL

PG

SQL Azure

AZ

Sybase

SYB

Teradata

TD