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 parameter applies only to declared cursors and not to DataWindow objects.
DIR Sybase DirectConnect
SYC Sybase Adaptive Server Enterprise
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) |
Block = 100
To set the blocking factor to 1000 rows:
Database profile Type the following in the Retrieve Blocking Factor box on the Transaction tab in the Database Profile Setup dialog box:
1000
Application Type the following in code:
SQLCA.DbParameter = "Block=1000"