MATLAB: Unable to use sqlwrite in MATLAB 2017

mysql sql

I am working on a project in which I have to write the MATLAB data to database. I tried to use sqlwrite but error occurred. Statement of error was "Undefined function or variable 'sqlwrite'". Is sqlwrite not available in MATLAB 2017? If so then please suggest me the alternative of sqlwrite.

Best Answer

The sqlwrite function was introduced in release R2018a of Database Toolbox. According to those Release Notes, "The sqlwrite function replaces the datainsert, fastinsert, and insert functions, which insert data into a database."

Related Solutions

MATLAB: Stored procedures not working after upgrading to a recent release of MATLAB

Before R2017a, the "database" function used the JDBC/ODBC bridge by default. From R2017a and onward, the "database" function uses native ODBC.

By upgrading releases, it is likely that the JDBC/ODBC driver was incorrectly integrated into MATLAB. The recommended solution is to use a JDBC or ODBC driver rather than a JDBC/ODBC driver to connect to the database.

MATLAB: Do I get the ??? Undefined function or variable ‘getTheMetaData’. error message with the Database Toolbox

This error message indicates that you are trying to connect to a database in read-only mode. The MATLAB Visual Query Builder does not support read-only connections. You initially will be able to connect to the database with a read-only username and password; but subsequent operations will generate errors.

To make a read-only connection, use the command line functionality of the Database Toolbox. e.g.

% Make connection to a database called SampleDB with username
% scott and password tiger
conn=database('SampleDB','scott','tiger');
% Execute a valid SQL statement against the database connection, conn
% and opens a cursor
curs = exec( conn, 'select freight from orders' );
% Import data from the open SQL cursor curs.
curs = fetch(curs);

For more information on using the Database Toolbox functions, please refer to Chapter 3 of the Database Toolbox User's Guide.

Best Answer

Related Solutions

MATLAB: Stored procedures not working after upgrading to a recent release of MATLAB

MATLAB: Do I get the ??? Undefined function or variable ‘getTheMetaData’. error message with the Database Toolbox

Related Question