DECLARE
Cursor
SQL statement
Description
Declares a cursor for the specified transaction object.
Syntax
|
1 2 |
DECLARE CursorName CURSOR FOR SelectStatement {USING TransactionObject}; |
|
Parameter |
Description |
|---|---|
|
CursorName |
Any valid PowerBuilder name. |
|
SelectStatement |
Any valid SELECT statement. |
|
TransactionObject |
The name of the transaction object for which you |
Usage
DECLARE Cursor is a nonexecutable command and is analogous to
declaring a variable.
To declare a local cursor, open the script in the Script view and
select Paste SQL from the PainterBar or the Edit>Paste Special menu.
To declare a global, instance, or shared cursor, select Declare from the
first drop-down list in the Script view and Global Variables, Instance
Variables, or Shared Variables from the second drop-down list, then
select Paste SQL.
For information about global, instance, shared, and local scope,
see Where to declare
variables.
Examples
This statement declares the cursor called Emp_cur for the database
specified in the default transaction object. It also references the
Sal_var variable, which must be set to an appropriate value before you
execute the OPEN Emp_cur command:
|
1 2 3 4 |
DECLARE Emp_cur CURSOR FOR SELECT employee.emp_number, employee.emp_name FROM employee WHERE employee.emp_salary > :Sal_var ; |