User`s guide

close
7-9
close
Close database connection, DatabaseDatastore, cursor, or resultset object
Syntax
close(object)
Description
close(object) closes the database and driver resource utilizer object to free up
database and driver resources.
Examples
Close the Database Connection Object
Using the native ODBC interface, connect to the database with the ODBC data source
name dbtoolboxdemo with the user name admin and password admin.
conn = database.ODBCConnection('dbtoolboxdemo','admin','admin');
Close the database connection conn.
close(conn)
Close the DatabaseDatastore Object
Using the native ODBC interface, connect to the database with the ODBC data source
name dbtoolboxdemo with the user name admin and password admin.
conn = database.ODBCConnection('dbtoolboxdemo','admin','admin');
Create a DatabaseDatastore object dbds using the database connection conn and
SQL query sqlquery. This SQL query retrieves all products from the product table
productTable ordered by product number.
sqlquery = 'select * from productTable order by productNumber';