Block (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
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; |