MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador descarregar pdf (Página 651)

100

101

set

7-221

Example 2 — Set the AutoCommit Flag to On

This example shows what happens when you run a database update function on a

database whose AutoCommit flag is set to on.

Determine the status of the AutoCommit flag for the database connection conn.

get(conn, 'AutoCommit')

ans =

off

The flag is off.

Set the flag status to on and verify its value.

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

get(conn, 'AutoCommit')

ans =

Insert a cell array exdata into column names colnames in the table Growth.

fastinsert(conn, 'Growth', colnames, exdata)

The data is inserted and committed to the database.

Example 3 — Set the AutoCommit Flag to Off and Commit Data

This example shows the results of running fastinsert and commit to insert and

commit data into a database whose AutoCommit flag is off.

First set the AutoCommit flag to off for database connection conn.

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

Insert a cell array exdata into the column names colnames in the table

Avg_Freight_Cost.

fastinsert(conn, 'Avg_Freight_Cost', colnames, exdata)

Commit the data to the database.

commit(conn)

1 2 ... 646 647 648 649 650 651 652 653 654 655 656 ... 683 684

Comentários a estes Manuais

Sem comentários

MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador Página 651

Comentários a estes Manuais

Manuais e produtos relacionados com Software MATLAB DATABASE TOOLBOX RELEASE NOTES