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 DataWindow objects.

Applies to

DIR Sybase DirectConnect
SYC and SYJ Sybase Adaptive Server Enterprise

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 tab in the Database Profile Setup dialog box: