User`s guide
fetch
7-149
fetch returns all the data by importing it in batches of five rows at a time.
Close the database connection.
close(conn)
• “Fetch Data Incrementally Using the Cursor Object”
• “Display Information About Imported Data”
• “Import Data Using a Scrollable Cursor with a Relative Position Offset”
• “ Retrieve Image Data Types”
Input Arguments
curs — Database cursor
database cursor object
Database cursor, specified as an open SQL database cursor object created using exec.
conn — Database connection
connection object
Database connection, specified as a database connection object created using database.
sqlquery — SQL statement
SQL string
SQL statement, specified as an SQL string to execute.
Data Types: char
rowlimit — Row limit
scalar
Row limit, specified as a scalar denoting the number of rows of data to import from the
open SQL cursor object, curs.
Data Types: double
fetchbatchsize — Fetch batch size
scalar