User`s guide

7 Functions — Alphabetical List
7-4
inventoryTable with these columns: productNumber, Quantity, Price, and
inventoryDate.
conn = database(dbname,username,pwd);
Fetch all the data from the table inventoryTable into a fetched data set curs.
curs = exec(conn,'select * from inventoryTable');
curs = fetch(curs);
Retrieve attribute information for the third column in the table inventoryTable in the
fetched data curs.
attributes = attr(curs,3)
attributes =
fieldName: 'PRICE'
typeName: 'NUMBER'
typeValue: 2.00
columnWidth: 39.00
precision: 126.00
scale: -127.00
currency: 'true'
readOnly: 'false'
nullable: 'true'
Message: []
attributes contains a structure with the attribute data for the third column PRICE in
the table inventoryTable.
Close the cursor and connection.
close(curs)
close(conn)
Input Arguments
curs — Database cursor
database cursor object
Database cursor, specified as an open SQL database cursor object created using exec.