Difference between revisions of "FINDCURSOR()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 21: | Line 21: | ||
select 3 | select 3 | ||
set gateway to "ora@sales:scott/tiger" | set gateway to "ora@sales:scott/tiger" | ||
| − | + | declare employees; | |
| − | + | cursor for; | |
| − | select empno, ename, job | + | select empno, ename, job; |
| − | from emp | + | from emp; |
| − | order by deptno | + | order by deptno |
| − | + | open employees | |
| − | + | ||
? findcursor(cursorname()) | ? findcursor(cursorname()) | ||
| Line 39: | Line 38: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | [[Category:Data Connectivity]] | + | [[Category:Remote Data Connectivity]] |
| − | [[Category:Data Connectivity Functions]] | + | [[Category:Remote Data Connectivity Functions]] |
Latest revision as of 11:50, 22 June 2010
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
select 3 set gateway to "ora@sales:scott/tiger" declare employees; cursor for; select empno, ename, job; from emp; order by deptno open employees ? findcursor(cursorname()) 3
Products
Recital Server, Recital
