Page size

Open Client and Open Server support logical page sizes of 2K, 4K, 8K, and 16K. Open Client and Open Server use the Bulk-Library (blklib) routines to populate these pages.

Table 2-7 lists bulk library constants and their values.

**Table 2-7: Page size 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

Compatibility

Support for wide data and a larger number of columns is automatically enabled if:

The client is set to CS_VERSION_125 or later
It is linked with Open Client Server 12.5 or later, and
The Adaptive Server Enterprise to which it is connected has the capabilities to handle wide tables. To determine the version of Adaptive Server Enterprise:
```
1> select @@version
```
```
2> go
```

If Open Client and Open Server 12.5 or later blklib is linked to a version 12.5 or later bcp application that communicates with a pre-12.5 Adaptive Server Enterprise, the bcp utility assumes that Adaptive Server Enterprise 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.