width

(To be removed) Return field size of column in fetched data set

The width function will be removed in a future release. There is no replacement for this functionality. To import data, use the fetch function. For details, see Compatibility Considerations.

Syntax

colsize = width(curs,colnum)


Description

colsize = width(curs,colnum) returns the field size of the specified column number colnum in the fetched data set curs.

Examples

Retrieve the width of the first column of the fetched data set curs.

colsize = width(curs,1)

colsize =

    11

The field size of column one is 11 characters (bytes).

To create fetched data sets using an ODBC connection, you can use the native ODBC interface. For details, see database.

Compatibility Considerations

width function will be removed

Warns starting in R2021a

The width function will be removed in a future release. Use the fetch function to import data. Some differences between the workflows might require updates to your code.

Update Code

Use the fetch function with the connection object to import data from a database in one step.

In prior releases, you wrote multiple lines of code to create the cursor object, import data, and determine the field size of a specified column number. For example:

curs = exec(conn,sqlquery);
curs = fetch(curs);
results = curs.Data;
colsize = width(curs,1);
close(curs)

Now you can import data in one step using the fetch function.

results = fetch(conn,sqlquery);

There is no replacement functionality for the width function.