CURSORNAME()

From Recital Documentation Wiki
Revision as of 16:54, 23 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Class

Data Connectivity


Purpose

Function to return the name of the cursor open in a workarea with an active gateway


Syntax

CURSORNAME([<workarea | alias>])


See Also

CLOSE, DECLARE CURSOR, DROP CURSOR, FETCH, FINDCURSOR(), GATEWAY(), OPEN


Description

The CURSORNAME() function returns the cursor name corresponding to the workarea specified by <workarea | alias>. If there is no cursor open, or no gateway active in the specified workarea then an empty string is returned. If no <workarea | alias> is specified then the CURSORNAME() function defaults to the current workarea.


Example

set gateway to "ora@sales:scott/tiger"
exec sql
declare employees cursor for
select empno, ename, job
from emp
order by deptno;
 
exec sql
open employees;
 
? cursorname()
EMPLOYEES


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer