Database Toolbox

Using Retrieved Data in MATLAB

When you execute a query, MATLAB retrieves the data and stores it in the variable name you provided. Using preferences, you specify the data return format as cellarray, structure, or numeric. Cell arrays and structures support mixed data types, but require more memory and are processed more slowly than numeric matrices. Use the numeric format if the data you are retrieving consists only of numeric data or if the nonnumeric data is not relevant. With the numeric format, any strings are converted to the representation specified in the NullNumberRead preference, for example, NaN.

For more information, see Working with Cell Arrays in MATLAB.

Specifying Preferences for NULLS, Data Format, and Error Handling

Clearing Variables from the Data Area