Description
Specifies whether you want to use a scroll cursor when connecting to an Informix database in PowerBuilder. When you fetch rows in an Informix table, using a scroll cursor enables you to fetch the next row, previous row, first row, or last row.
By default, PowerBuilder does not use scroll cursors in an Informix database connection.
Applies to
INF Informix
IN9 Informix
Syntax
Scroll=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want to use a scroll cursor when connecting to an Informix database in PowerBuilder. Values are:
|
Default value
Scroll=0
Examples
To specify that you want to use a scroll cursor when connecting to an Informix database in PowerBuilder:
-
Database profile
Select the Use A Scroll Cursor check box on the Transaction page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="Scroll=1"
