User`s guide

6 Using Database Toolbox Functions
6-56
1
Retrieve the Column Name in the Imported Data
Retrieve the column name colname using curs.
colname = columnnames(curs)
colname =
'productDescription'
Retrieve the Column Width in the Imported Data
Retrieve the column width colsize, or size of the field, for the first column using curs.
colsize = width(curs,1)
colsize =
50
Display Attributes in the Imported Data
Display the attributes for the product description column using curs.
attributes = attr(curs)
attributes =
fieldName: 'productDescription'
typeName: 'VARCHAR'
typeValue: 12
columnWidth: 50
precision: []
scale: []
currency: 'false'
readOnly: 'false'
nullable: 'true'
Message: []
Close the Cursor Object
After finishing with the cursor object, close it.