MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario descargar pdf (Pagina 652)

100

101

7 Functions — Alphabetical List

7-222

Example 4 — Set the AutoCommit Flag to Off and Roll Back Data

This example runs update to insert data into a database whose AutoCommit flag is off.

It then uses rollback to roll back the data.

Set the AutoCommit flag to off for database connection conn.

set(conn, 'AutoCommit', 'off');

Update the data in colnames in the Avg_Freight_Weight table, for the record

selected by whereclause, with data from the cell array exdata.

update(conn, 'Avg_Freight_Weight', colnames, exdata,

whereclause)

Roll back the data.

rollback(conn)

The data in the table is now as it was before you ran update.

Example 5 — Set the LoginTimeout for a Drivermanager Object

Create a drivermanager object dm using drivermanager. Set the LoginTimeout

value to 3 seconds.

dm = drivermanager;

set(dm,'LoginTimeout',3);

Verify this result.

logintimeout

ans =

Comentarios a estos manuales

Sin comentarios

MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario Pagina 652

Comentarios a estos manuales

Relacionado con productos y manuales para Software MATLAB DATABASE TOOLBOX RELEASE NOTES