(Not recommended) Close cursor
Connect to a Microsoft® SQL Server® database and verify the database connection. Then, import data from the database into MATLAB®. Determine the highest unit cost among the retrieved products in the table. Close the database cursor and database connection.
Create an ODBC database connection to a Microsoft
SQL Server database with Windows®authentication. Specify a blank user name and password. The database
contains the table
datasource = 'MS SQL Server Auth'; conn = database(datasource,'','');
Check the database connection. If the
Message property is empty,
the connection is successful.
ans = 
Select all data from the table
productTable by using the
connection object, and sort the data by product number. Assign the
SELECT statement to the variable
cursor object contains the executed SQL query.
sqlquery = 'SELECT * FROM productTable ORDER BY productNumber'; curs = exec(conn,sqlquery);
Import the data from the executed SQL query and display the first three rows.
curs = fetch(curs); curs.Data(1:3,:)
ans = 3×5 table productNumber stockNumber supplierNumber unitCost productDescription _____________ ___________ ______________ ________ __________________ 1 4.0035e+05 1001 14 'Building Blocks' 2 4.0031e+05 1002 9 'Painting Set' 3 4.01e+05 1009 17 'Slinky'
Determine the highest unit cost in the table.
data = curs.Data; max(data.unitCost)
ans = 24
After you finish working with the
cursor object, close it.
After you close the
cursor object, MATLAB deletes the object. Use the
clear function to remove
curs variable from the MATLAB workspace.
curs clear curs
curs = handle to deleted cursor
Close the database connection.
closefunction is not recommended
Not recommended starting in R2018b
close function is not recommended. Use the
fetch function to import data. Some differences between the workflows might
require updates to your code.
There are no plans to remove the
close function at this
fetch function with the
object to import data from a database in one step.
In prior releases, you wrote multiple lines of code to create the
cursor object and import data. For example:
curs = exec(conn,sqlquery); curs = fetch(curs); results = curs.Data; close(curs)
Now you can import data in one step using the
results = fetch(conn,sqlquery);
There is no replacement functionality for the