Datatypes

Description

Open ClientConnect supports a wide range of datatypes. These datatypes are shared with Open Client, Open Server and Open ServerConnect, and correspond directly to Adaptive Server datatypes.

Table 2-7 lists the Client-Library datatypes, together with the corresponding type constants, Adaptive Server datatypes, and Open ServerConnect datatypes.

**Table 2-7: Summary of Open ClientConnect datatypes**
This Client-Library datatype	Whose datatype declaration looks like this	Describes this type of data	Corresponds to this Adaptive server datatype	Corresponds to this Open ServerConnect datatype
CS-BINARY	PIC X(n)	Binary	binary	TDSBINARY
CS-CHAR	PIC X(n)	Character	char	TDSCHAR
CS-DATETIME	01 MY-TIME 49 DATE PIC S9(9) 49 TIME PIC S9(9)	8-byte datetime	datetime	TDSDATETIME
CS-DATETIME4	01 MY-TIME 49 DATE PIC S9(4) 49 TIME PIC S9(4)	4-byte datetime	smalldatetime	TDSDATETIME4
CS-FLOAT	USAGE COMP-2	8-byte float	float	TDSFLT8
CS-INT	PIC S9(5-9)	4-byte integer	int	TDSINT4
CS-LONGBINARY	PIC X(n)	Long variable binary	--	TDSLONGVARBIN
CS-LONGCHAR	PIC X(n)	Long variable character	--	TDSLONGVARCHAR
CS-MONEY	01 MY-MONEY 49 HIGH PIC S9(9) 49 LOW PIC S9(9)	8-byte money	money	TDSMONEY
CS-MONEY4	PIC S9(9) COMP	4-byte money	smallmoney	TDSMONEY4
CS-PACKED370	PIC S9(n) V9(m) USAGE COMP-3	IBM S/370 packed decimal	decimal	TDS-PACKED-DECIMAL
CS-REAL	USAGE COMP-1	4-byte float	real	TDSFLT4
CS-SMALLINT	PIC S9(3-4)	2-byte integer	smallint	TDSINT2
CS-VARBINARY	01 MY-VARBINARY 49 LEN PIC S9(4) 49 ARR PIC X(n)	Variable-length binary	--	TDSVARYBIN
CS-VARCHAR	01 MY-VARCHAR 49 LEN PIC S9(4) 49 ARR PIC X(n)	Variable-length character	--	TDSVARYCHAR
CS-NUMERIC	PIC X(35)	--	numeric	TDSNUMERIC
CS-DECIMAL	PIC X(35)	--	Sybase decimal	TDS-SYBASE-DECIMAL