matlab to SQL, AutoCommit

The database toolbox says, when connected, AutoCommit must be 'off', so to save data from Matlab to SQL database. I have the connection, but AutoCommit='on'. What should I do?

Thanks.

Answer 1

[Piyush Kumar]

@Hugh,

The status of AutoCommit database flag determines whether or not the insert action can be undone.

If the AutoCommit flag is set to on, the database commits the exported data automatically to the database, and this action cannot be undone.

Check the "Insert Total Sales for One Month into Database" section of this link.

Also, to run commit function, the AutoCommit flag for connection variable must be off.

Please go through this link for more details -

https://www.mathworks.com/matlabcentral/answers/12835-what-happens-exactly-when-autocommit-is-off