Adaptive Server Enterprise 12.5 and later supports logical page sizes of 2K, 4K, 8K, and 16K. Open Client and Open Server uses the Bulk-Library (blklib) routines to populate these pages. Until the release of 12.5, blklib only supported the Adaptive Server page size of 2K.
Table 2-7 lists bulk library constants and their values.
blk_pagesize |
blk_maxdatarow |
blk_maxcolsize |
blk_maxcolno |
blk_boundary |
|---|---|---|---|---|
2K |
1962 |
1960 |
1962 |
1960 |
4K |
4010 |
4008 |
4010 |
4008 |
8K |
8106 |
8104 |
8106 |
8104 |
16K |
16298 |
16296 |
16298 |
16298 |
Increased page size limits allow for increased number of columns, depending upon the type of table. The limits are:
1024 for fixed-length columns in both all-pages locking (APL) and data-only locking (DOL) tables
254 for variable-length columns in an APL table
1024 for variable-length columns in an DOL table
No changes have been made to the existing blklib APIs, nor have any new APIs been added to accommodate the larger page size support in Adaptive Server.
Support for wide data and a larger number of columns is automatically enabled if:
The client is set to CS_VERSION_150,
It is linked with Open Client Server 15.0 library, and
The Adaptive Server to which it is connected has the capabilities to handle wide tables. To determine the version of Adaptive Server:
1> select @@version
2> go
If Open Client and Open Server 15.0 blklib is linked to a version 15.0 bcp application that communicates with a pre-12.5 Adaptive Server, the bcp utility assumes that Adaptive Server has the 2K page size.
If the blklib is linked to a bcp application that was built with a version of the utility earlier than 12.5, it cannot support the copy of large pages.
