Sybase data type support

When a job runs, the stage maps InfoSphere® DataStage® data types to Sybase data types.

Table 1. Mapping of InfoSphere DataStage data types to Sybase data types
SQL type	Length	Scale	Extended	Sybase Column Definition
BigInt	n/a	n/a	any	BIGINT
Binary	n	n/a	n/a	Not supported
Bit	n/a	n/a	n/a	Not supported
Char	n	n/a	blank	CHAR(n)
Char	n	n/a	Unicode	CHAR(n)
Date	n/a	n/a	n/a	DATETIME¹
Decimal	p	s	n/a	DECIMAL(p,s)
Double	p	n/a	n/a	FLOAT(p)
Float	p	n/a	n/a	FLOAT(p)²
Integer	n/a	n/a	any	INTEGER
LongNVarChar	n	n/a	n/a	TEXT
LongVarBinary	n	n/a	n/a	IMAGE
LongVarChar	n	n/a	blank	TEXT
LongVarChar	n	n/a	Unicode	TEXT
NChar	n	n/a	n/a	UNICHAR(n)
NVarChar	n	n/a	n/a	UNIVARCHAR(n)
Numeric	p	s	n/a	DECIMAL(p,s)
Real	n/a	n/a	n/a	REAL
SmallInt	n/a	n/a	any	SMALLINT
Time	n/a	any	any	DATETIME³
Timestamp	n/a	any	any	DATETIME
TinyInt	n/a	n/a	any	SMALLINT
VarBinary	n	n/a	n/a	Not supported
VarChar	n	n/a	blank	VARCHAR(n)
VarChar	n	n/a	Unicode	VARCHAR(n)
Table notes: The time component of the Sybase DATETIME or SMALLDATETIME values is lost when converted to the InfoSphere DataStage Date data type. When writing InfoSphere DataStage Date values to a Sybase DATETIME or SMALLDATETIME column, the time component is set to midnight. The InfoSphere DataStage Float data type has a maximum precision of 15 digits. Some loss of precision occurs when reading data from Sybase FLOAT( `p`) columns where `p` is greater than 15. The date component of the Sybase DATETIME or SMALLDATETIME values is lost when converted to the InfoSphere DataStage Time data type. When writing InfoSphere DataStage Time values to a Sybase DATETIME or SMALLDATETIME column, the date component is set to the current date on the InfoSphere DataStage Server machine.