Sybase datatype support - 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 following tables show the Sybase (as source) datatype support.

Sybase Source Datatype

Supported Targets

BINARY

IBM i

  • BLOB

  • CHAR FOR BIT DATA

  • VARCHAR FOR BIT DATA

UDB

  • CHAR FOR BIT DATA

  • VARCHAR FOR BIT DATA

 

MS SQL Server/SQL Azure

  • BINARY

  • IMAGE

  • VARBINARY

  • VARBINARY(MAX)

 

Oracle

  • BLOB

  • LONG RAW

  • RAW

 

PostgreSQL

  • BYTEA

 

Sybase

  • BINARY

  • IMAGE

  • VARBINARY

Sybase Source Datatype

Supported Targets

BIT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • TIMESTAMP

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • SMALLFLOAT

  • INTEGER

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • SMALLINT

  • TINYINT

 

Oracle

  • NUMBER

  • NUMBER(38)

  • NUMBER (p,s). Connect CDC Director warns.

  • VARCHAR2 (L), where L >= 1

 

PostgreSQL

  • BOOLEAN

  • DECIMAL

  • INTEGER

  • SMALLINT

BIT

Sybase

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Teradata

  • BIGINT

  • BYTEINT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • SMALLINT 

 

All Platforms

  • CHAR (L), where L >= 1.

  • VARCHAR (L), where L >= 1.

Sybase Source Datatype

Supported Targets

CHAR

DB2 (includes IBM i and UDB)

  • CHAR (Unicode)

  • CLOB (IBM i only). The Sybase datatype must be set as Unicode.

  • DBCLOB (Unicode IBM i only).

  • GRAPHIC (Unicode)

  • VARGRAPHIC (Unicode)

Informix

MS SQL Server/SQL Azure
 

Oracle

  • VARCHAR2

 

Sybase

  • TEXT (Copy only)

 

Teradata

  • LONG VARCHAR

 

All Platforms

  • CHAR

  • VARCHAR

 

Sybase Source Datatype

Supported Targets

DATETIME

DB2 (includes IBM i and UDB)

  • TIMESTAMP. Time generated as all zero's.

 

Informix

  • DATETIME—Ideal mapping is to INFORMIX YEAR TO FRACTION(3). For other target columns, data is padded or truncated to fit the target.

 

MS SQL Server/SQL Azure

  • DATE

  • DATETIME—Time generated as all zero's.

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • TIME

  • TIME(P)

  • SMALLDATETIME—Time generated as all zero's.

 

Oracle

  • DATE

  • TIMESTAMP—Time generated as all zero's

  • TIMESTAMP(P)

  • VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

 

PostgreSQL

  • DATE

  • TIME

  • TIMESTAMP

 

Sybase

  • DATE

  • DATETIME—Time generated as all zero's

  • SMALLDATETIME—Time generated as all zeros.

DATETIME

Teradata

  • DATE

  • LONG VARCHAR

  • TIME

  • TIMESTAMP—Time generated as all zero's.

  • TIMESTAMP(P)—Add several timestamps with different precisions

 

All Platforms

  • DATE: Time data is truncated if for DB2; fractions of a second are truncated if for Oracle.

  • CHAR (L)

  • VARCHAR (L)

where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

 

Sybase Source Datatype

Supported Targets

DECIMAL

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY

  • NUMERIC (p,s)

  • SMALLFLOAT

  • SMALLINT. Connect CDC Director warns.

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY (assumed tp = 19, ts = 4)

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

  • SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT. Connect CDC Director warns.

 

Oracle

  • NUMBER (p,s)

  • NUMBER

  • NUMBER(38)

  • VARCHAR2 (L), where L >= p+2.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • INTEGER

  • MONEY

  • REAL

  • SMALLINT

DECIMAL

Sybase

  • BIT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY (assumed tp = 19, ts = 4)

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

  • SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT. Connect CDC Director warns.

 

Teradata

  • BIGINT

  • BYTEINT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • LONG VARCHAR

  • NUMBER

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

 

All Platforms

  • CHAR (L), where L >= p+2.

  • VARCHAR (L)*, where L >= p+2.

    Note: For all the above, if tp < p, or ts < s, Connect CDC Director issues a warning.

Sybase Source Datatype

Supported Targets

DOUBLE PRECISION

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • REAL

 

Informix

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

  • SMALLFLOAT

 

MS SQL Server/SQL Azure

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

DOUBLE PRECISION

Oracle

  • DOUBLE PRECISION

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

  • VARCHAR2 (L), where L >= 22.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • INTEGER

  • REAL

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Teradata

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • REAL

 

All Platforms

  • CHAR (L), where L >= 22.

  • VARCHAR (L), where L >= 22.

Sybase Source Datatype

Supported Targets

FLOAT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • REAL

 

Informix

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • INTEGER

  • FLOAT

  • REAL

  • SMALLFLOAT

 

MS SQL Server/SQL Azure

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

  • VARCHAR2 (L), where L >= 22.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • INTEGER

  • REAL

  • SMALLINT

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

FLOAT

Teradata

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • REAL

 

All platforms

CHAR/VARCHAR/VARCHAR2/LONG

VARCHAR (L), where L >= 22.

Sybase Source Datatype

Supported Targets

IMAGE

IBM i

  • BLOB

 

MS SQL Server/SQL Azure

  • IMAGE

  • VARBINARY(MAX)

 

Oracle

  • BLOB

 

PostgreSQL

  • BYTEA

 

Sybase

  • IMAGE

Sybase Source Datatype

Supported Targets

INTEGER

DB2 (includes IBM i and UDB)

  • BIGINT

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

 

Informix

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • NUMBER

  • NUMBER (p,s). Connect CDC Director warns.

  • NUMBER(38)

  • VARCHAR2 (L), where L>= 11.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • INTEGER

  • REAL

  • SMALLINT

 

Sybase

  • DATETIME. Time generated as all zero's.

  • INTEGER

  • SMALLINT

  • TINYINT

INTEGER

Teradata

  • BIGINT

  • BYTEINT

  • DECIMAL

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • SMALLINT

 

All Platforms

  • CHAR (L), where L>= 11.

  • VARCHAR (L), where L>= 11.

Sybase Source Datatype

Supported Targets

MONEY

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • NUMERIC

  • SMALLINT. Connect CDC Director warns.

 

Informix

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY

  • NUMERIC

  • SMALLFLOAT

  • SMALLINT. Connect CDC Director warns.

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY (assumed tp = 19, ts = 4)

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

  • SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT. Connect CDC Director warns.

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

  • VARCHAR2 (L), where L >= p+2.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • MONEY

 

MONEY

Sybase

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • MONEY (assumed tp = 19, ts = 4)

  • NUMERIC

  • SMALLINT. SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT

 

Teradata

  • BIGINT

  • BYTEINT. Connect CDC Director warns.

  • DECIMAL

  • INTEGER.

  • LONG VARCHAR

  • NUMBER

  • NUMERIC

  • SMALLINT. Connect CDC Director warns.

 

All platforms

  • CHAR

  • VARCHAR

 

Notes:

For all the above:

  • Source precision and scale are fixed at 19 and 4.

  • Range of values for all datatypes:

Minimum values:

-922, 337, 203,685, 477.5808

Maximum values:

+922, 337, 203,685, 477.5807

Sybase Source Datatype

Supported Targets

NUMERIC

  • Functionally equivalent to DECIMAL. See DECIMAL .

Sybase Source Datatype

Supported Targets

REAL

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • REAL

 

Informix

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

  • SMALLFLOAT

 

MS SQL Server/SQL Azure

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

  • VARCHAR2 (L), where L >= 22.

 

PostgreSQL

  • BIGINT

  • DOUBLE PRECISION

  • REAL

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

REAL

Teradata

  • BIGINT

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • REAL

 

All Platforms

  • CHAR (L), where L >= 22.

  • VARCHAR (L), where L >= 22.

Sybase Source Datatype

Supported Targets

SMALLDATETIME

DB2 (includes IBM i and UDB)

  • TIMESTAMP.

 

Informix

  • DATETIME. Ideal mapping is to DATETIME (YEAR TO MINUTE).

 

MS SQL Server/SQL Azure

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

 

Oracle

  • TIMESTAMP

  • TIMESTAMP(P)

  • VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

 

PostgreSQL

  • DATE

  • TIME

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME

 

Teradata

  • LONG VARCHAR

  • TIMESTAMP

  • TIMESTAMP(P)

 

All Platforms

  • CHAR (L)

  • VARCHAR (L)

where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

 

For all datatypes:

Missing seconds and fractions of seconds are generated as zeros.

Sybase Source Datatype

Supported Targets

SMALLINT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

 

Informix

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • NUMBER

  • NUMBER(38)

  • NUMBER (p,s). Connect CDC Director warns

  • VARCHAR2 (L), where L>= 6.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • INTEGER

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

SMALLINT

Teradata

  • BIGINT

  • BIT

  • BYTEINT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • SMALLINT

 

All Platforms

  • CHAR (L), where L>= 6.

  • VARCHAR (L), where L>= 6.

 

Sybase Source Datatype

Supported Targets

SMALLMONEY

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • NUMERIC

  • SMALLINT. Connect CDC Director warns.

 

Informix

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY

  • NUMERIC

  • SMALLFLOAT

  • SMALLINT. Connect CDC Director warns.

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT. Connect CDC Director warns.

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY (assumed tp = 19, ts = 4).

  • NUMERIC

  • SMALLINT. Connect CDC Director warns.

  • SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT. Connect CDC Director warns

SMALLMONEY

Oracle

  • NUMBER

  • NUMBER

  • NUMBER(38)

  • VARCHAR2 (L), where L >= p+2.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • DOUBLE PRECISION

  • MONEY

 

Sybase

  • BIT. Connect CDC Director warns.

  • DECIMAL

  • FLOAT

  • INTEGER. Connect CDC Director warns.

  • MONEY (assumed tp = 19, ts = 4)

  • NUMERIC

  • SMALLINT. Connect CDC Director warns.

  • SMALLMONEY. Assumed tp = 10, ts = 4).

  • TINYINT. Connect CDC Director warns.

 

Teradata

  • BIGINT

  • BYTEINT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • INTEGER. Connect CDC Director warns.

  • LONG VARCHAR

  • NUMBER

  • NUMERIC (p,s)

  • SMALLINT. Connect CDC Director warns.

 

All Platforms

  • CHAR (L), where L >= p+2.

  • VARCHAR (L), where L >= p+2.

 

Notes:

  • Source precision and scale are fixed at 19 and 4.

  • Range of values for all datatypes:

Minimum values:

-214, 748.3648

Maximum values:

+214, 748.3647

 

 

Sybase Source Datatype

Supported Targets

TEXT

PostgreSQL

  • TEXT

 

Sybase

  • CHAR a

  • TEXT a

  • VARCHAR a

aCopy only

Sybase Source Datatype

Supported Targets

TINYINT

DB2 (includes IBM i and UDB)

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server/SQL Azure

  • BIGINT

  • BIT. Connect CDC Director warns.

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • NUMBER

  • NUMBER(38)

  • NUMBER. Connect CDC Director warns

  • VARCHAR2 (L), where L>= 3.

 

PostgreSQL

  • BIGINT

  • DECIMAL

  • INTEGER

  • SMALLINT

 

Sybase

  • BIT. Connect CDC Director warns

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

TINYINT

Teradata

  • BIGINT

  • BYTEINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • LONG VARCHAR

  • NUMBER

  • SMALLINT

 

All Platforms

  • CHAR (L), where L>= 3.

  • VARCHAR (L), where L>= 3.

Sybase Source Datatype

Supported Targets

VARBINARY

IBM i

  • BLOB

  • CHAR FOR BIT DATA

  • VARCHAR FOR BIT DATA

UDB

  • CHAR FOR BIT DATA

  • VARCHAR FOR BIT DATA

 

MS SQL Server/SQL Azure

  • BINARY

  • IMAGE

  • VARBINARY

  • VARBINARY(MAX)

 

Oracle

  • BLOB

  • LONG RAW

  • RAW

 

PostgreSQL

  • BYTEA

 

Sybase

  • BINARY

  • IMAGE

  • VARBINARY

 

Sybase Source Datatype

Supported Targets

VARCHAR

DB2 (includes IBM i and UDB)

  • CLOB (IBM i only). The Sybase datatype must be set as Unicode.

  • DBCLOB (IBM i only). The Sybase datatype must be set as Unicode.

  • CHAR (Unicode)

  • GRAPHIC (Unicode)

  • VARGRAPHIC (Unicode)

Informix

MS SQL Server/SQL Azure
 

Oracle

  • VARCHAR2

 

Sybase

  • TEXT

 

Teradata

  • LONG VARCHAR

 

All platforms

  • CHAR

  • VARCHAR