User`s guide

fetch
7-139
fetch
Import data into MATLAB workspace from cursor object or from execution of SQL
statement
Syntax
curs = fetch(curs)
curs = fetch(curs,rowlimit)
curs = fetch(curs,Name,Value)
curs = fetch(curs,rowlimit,Name,Value)
results = fetch(conn,sqlquery)
results = fetch(conn,sqlquery,fetchbatchsize)
Description
curs = fetch(curs) imports all rows of data into the cursor object curs from the
open SQL cursor object curs.
curs = fetch(curs,rowlimit) imports rows of data up to the maximum number of
rows rowlimit.
curs = fetch(curs,Name,Value) imports rows of data using a scrollable cursor.
curs = fetch(curs,rowlimit,Name,Value) imports rows of data up to the
maximum number of rows rowlimit using a scrollable cursor.
results = fetch(conn,sqlquery) executes the SQL statement sqlquery, imports all
rows of data in batches for the open database connection conn, and returns the resulting
data results.
results = fetch(conn,sqlquery,fetchbatchsize) imports all rows of data in
batches of a specified number of rows fetchbatchsize at a time.