This section contains information on changes to this manual in this version. The changes are:
Sybase library name change: Naming conventions for Open Server and SDK libraries have changed, with the addition of syb to Sybase libraries. Names for non-Sybase libraries remain the same.
BCP partitions: You can now copy ASE partitions with added support for BLKLIB and BCP programs.
BCP computed columns: Two new Client-Library options have been added to support BCP computed columns.
CS_OPT_HIDE_VCC instructs the Adaptive Server to hide Virtual Computed Columns (VCC), while CS_OPT_SHOW_FI adds columns for each Functional Index (FI).
Large identifiers: Limits on lengths of identifiers have been reduced. This is now 255 bytes for identifiers.
Unilib® support: Unicode Infrastructure Library (Unilib), an independent library of Unicode-based routines, has been included to facilitate character-set conversion.
ASE default packet size support: You can now configure packet size centrally on the server, with the default set to 8192 bytes.
Clusters support: A cluster of servers can now perform load balancing for all client connections coming into the cluster.
Scrollable cursors: You can now set the position of a cursor anywhere in the cursor result set.
Table 1-1 lists the new datatypes introduced in this version:
Type category |
Open Client and Open Server type constant |
Description |
Corresponding C datatype |
Corresponding server datatype |
|---|---|---|---|---|
XML type |
CS_XML_TYPE |
Variable-length character type |
CS_XML |
xml |
Numeric types |
CS_BIGINT_TYPE |
8-byte integer type |
CS_BIGINT |
bigint |
CS_USMALLINT_TYPE |
2-byte unsigned integer type |
CS_USMALLINT |
usmallint |
|
CS_UINT_TYPE |
4-byte unsigned integer type |
CS_UINT |
uint |
|
CS_UBIGINT_TYPE |
8-byte unsigned integer type |
CS_UBIGINT |
ubigint |
|
Text and image types |
CS_UNITEXT_TYPE |
Variable-length character type |
CS_UNITEXT |
unitext |
