close - Close database connection, cursor, or resultset object

Syntax

Description

close(object) closes object, which frees up resources.

Allowable objects for close are listed in the following table.

Object	Description	Action Performed by close(object)
conn	Database connection object	Closes conn
curs	Cursor object	Closes curs
rset	Resultset object	Closes rset

Database connections, cursors, and resultsets remain open until you close them using the close function. Always close a cursor, connection, or resultset when you finish using it. Close a cursor before closing the connection used for that cursor.

Note   The MATLAB session closes open cursors and connections when exiting, but the database might not free up the cursors and connections.

Tip   For command-line help on close, use the overloaded methods: help database/close help cursor/close help resultset/close

Examples

Close the cursor curs and the connection conn.

close(curs)
close(conn)

See Also

cursor.fetch | database | exec | resultset

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS