CLOSE
Cursor
SQL statement
Description
Closes the SQL cursor CursorName; ends processing of
CursorName.
Syntax
|
1 |
CLOSE CursorName ; |
|
Parameter |
Description |
|---|---|
|
CursorName |
The cursor you want to close |
Usage
This statement must be preceded by an OPEN statement for the same
cursor. The USING TransactionObject clause is not allowed with CLOSE;
the transaction object was specified in the statement that declared the
cursor.
CLOSE often appears in the script that is executed when the
SQL code after a fetch equals 100 (not found).
Error handling
It is good practice to test the success/failure code after
executing a CLOSE cursor statement.
Examples
This statement closes the Emp_cursor cursor:
|
1 |
CLOSE Emp_cursor ; |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest