Block (DirectConnect and Adaptive Server Enterprise)

Description

Specifies the internal blocking factor used by the Sybase Client Library (CT-Lib) interface when declaring a cursor. The blocking factor determines the number of rows fetched from the database at one time when CT-Lib makes a physical request for data.

The Block DBParm parameter applies only to declared cursors and not to reports.

Applies to

ASE, SYC, Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect

Syntax

Block=blocking_factor

Parameter	Description
blocking_factor	The number of rows fetched from the database at one time when CT-Lib makes a physical request for data (default=100 rows)

Default

Block=100

Examples

Example 1

To set the blocking factor to 1000 rows, type the following in the Retrieve Blocking Factor box on the Transaction page in the Database Profile Setup dialog box: