Block (DirectConnect and Adaptive Server Enterprise) – PB Docs 126

Block (DirectConnect and Adaptive Server Enterprise) database parameter

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.

Controls

  • ASE, SYC, and SYJ SAP
    Adaptive Server Enterprise

  • DIR Sybase DirectConnect

Syntax

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:

  • Application

    Type the following in code:

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.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x