Sybase datatype support - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type: Software
Portfolio: Integrate
Product family: Connect
Product: Connect > Connect CDC (MIMIX Share)
Version: Latest
Language: English
Product name: Connect CDC
Title: Connect CDC System Reference Guide
Copyright: 2024
First publish date: 2003
ft:lastEdition: 2024-08-20
ft:lastPublication: 2024-08-20T21:40:14.000381

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