Block (DirectConnect and Adaptive Server Enterprise)
database parameter
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
|
1 |
Block=blocking_factor |
|
Parameter |
Description |
|---|---|
|
blocking_factor |
The number of rows fetched from the database at one |
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:11000 -
Application
Type the following in code:
1SQLCA.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.
|
1 2 3 4 5 |
SQLCA.DBParm="Block=1000" DECLARE dept_cursor CURSOR FOR SELECT dept_id, dept_name FROM department USING SQLCA; OPEN dept_cursor; |