Difference between revisions of "FINDCURSOR()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 17: | Line 17: | ||
==Description== | ==Description== | ||
The FINDCURSOR() function returns a workarea number corresponding to the open gateway cursor specified by <expC>. | 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. | If the cursor name specified is not open, or no gateway is active, then a value of -1 is returned. | ||
| Line 25: | Line 26: | ||
set gateway to "ora@sales:scott/tiger" | set gateway to "ora@sales:scott/tiger" | ||
exec sql | exec sql | ||
| − | declare employees cursor for | + | declare employees cursor for |
| − | select empno, ename, job | + | select empno, ename, job |
| − | from emp | + | from emp |
| − | order by deptno; | + | order by deptno; |
exec sql | exec sql | ||
| − | open employees; | + | open employees; |
? findcursor(cursorname()) | ? findcursor(cursorname()) | ||
| Line 42: | Line 43: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| + | [[Category:Data Connectivity]] | ||
| + | [[Category:Data Connectivity Functions]] | ||
Revision as of 11:11, 3 June 2009
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
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
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
