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

ASE, SYC, and SYJ 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:

Database profile Type the following in the Retrieve Blocking Factor box on the Transaction page in the Database Profile Setup dialog box:
```
1000
```

Application Type the following in code:
```
SQLCA.DBParm="Block=1000"
```

Example 2

The following embedded SQL statements show how to set the blocking factor in code and use it to declare a cursor. These statements set the blocking factor to 1000 rows and declare a cursor that uses this internal blocking factor.

SQLCA.DBParm="Block=1000"

DECLARE dept_cursor CURSOR FOR

		SELECT dept_id, dept_name FROM department

		USING SQLCA;

OPEN dept_cursor;