View source for FINDCURSOR()

==Class==
Data Connectivity


==Purpose==
Returns the workarea number corresponding to the specified gateway cursor


==Syntax==
FINDCURSOR(<expC>)


==See Also==
[[CLOSE]], [[CURSORNAME()]], [[DECLARE CURSOR]], [[DROP CURSOR]], [[FETCH]], [[GATEWAY()]], [[OPEN]]


==Description==
The FINDCURSOR() function returns a workarea number corresponding to the open gateway cursor specified by <expC>.  
If the cursor name specified is not open, or no gateway is active, then a value of -1 is returned.


==Example==
<code lang="recital">
select 3
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;

? findcursor(cursorname())
         3
</code>


==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
[[Category:Documentation]]
[[Category:Functions]]
[[Category:SQL]]