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 find the number of rows in the imported data. For example:

curs = exec(conn,sqlquery);
curs = fetch(curs);
results = curs.Data;
numrows = rows(curs);
close(curs)

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

results = fetch(conn,sqlquery);
sz = size(results);

If you return imported data as a table, access details about the variables in the table by using functions such as summary or size. Or, view the dimensions of the returned data in the Workspace browser.

There is no replacement functionality for the rows function.