Hard close one or more open cursors
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
USupported on UNIX
|
VSupported on OpenVMS
|
value = %SSC_CLOSE(dbchannel, dbcursor[, ...])
Return value
value
This function returns SSQL_NORMAL (success). (i)
Arguments
dbchannel
An internal database channel previously initialized using %SSC_INIT and connected by %SSC_CONNECT. (n)
dbcursor
One or more logical cursor numbers within the range from 1 through the maximum number specified by maxcur during %SSC_INIT. (n)
Discussion
%SSC_CLOSE hard closes one or more logical cursors opened with %SSC_OPEN. A hard close closes the cursor on the target database. (For information on soft closes, see Using cursors with SQL Connection and %SSC_SCLOSE.)
The cursor(s) specified with dbcursor must have been opened by %SSC_OPEN. Once you close a logical cursor, that cursor is no longer valid. (Note that if dbcursor is not an open cursor, you will get a return value of SSQL_NORMAL, not SSQL_FAILURE.)
The dbcursor argument is cleared to 0 when a cursor is hard closed.
|
A commit or rollback transaction may or may not close open cursors automatically. You should always explicitly close cursors before a commit or rollback. A table can be dropped (that is, deleted or removed) only if all cursors are hard closed. |
If you use ^VARARGARRAY, note that dbcursor is the last declared argument for this routine.
Examples
For an example that uses %SSC_CLOSE, see %SSC_COMMIT.
