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 3-7 lists the Client-Library datatypes, together with the corresponding type constants, Adaptive Server datatypes, and Open ServerConnect 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 |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
