DECLARE Cursor SQL statement
Description
Declares a cursor for the specified transaction object.
Syntax
|
1 |
DECLARE <span>CursorName</span> CURSOR FOR <span>SelectStatement</span> <br> {USING <span>TransactionObject</span>}; |
|
Parameter |
Description |
|---|---|
|
CursorName |
Any valid PowerBuilder name. |
|
SelectStatement |
Any valid SELECT statement. |
|
TransactionObject |
The name of the transaction object for |
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 |
DECLARE Emp_cur CURSOR FOR |
|
1 |
SELECT employee.emp_number, employee.emp_name |
|
1 |
FROM employee |
|
1 |
WHERE employee.emp_salary > :Sal_var ; |