MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 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

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 651

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES