Description
Specifies the internal blocking factor used by the SAP 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 and SYC SAP Adaptive Server Enterprise
DIR SAP 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 value
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;