base.SqlHandle.close
Closes the SQL handle (cursor).
Syntax
close()
Usage
Call the close()
method when you are done with the SQL handle.
The statement can be re-opened after it has been closed.
Note: An SqlHandle object is automatically closed when the object is destroyed.
As with standard Genero SQL instructions, SQL errors can be trapped
with WHENEVER ERROR
or TRY / CATCH
blocks and by
testing SQLCA.SQLCODE.
Example
DEFINE sh base.SqlHandle
...
CALL sh.close()
For a complete example, see Example 2: SqlHandle with result set SQL.