MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 360)

100

101

6 Using Database Toolbox Functions

6-18

Exporting Data to New Record in Database

This example does the following:

Retrieves sales data from a salesVolume table.

Calculates the sum of sales for 1 month.

Stores this data in a cell array.

Exports this data to a yearlySales table.

You learn to use the following Database Toolbox functions:

• get

• fastinsert

• setdbprefs

For details about these functions, see matlab\toolbox\database\dbdemos

\dbinsertdemo.m.

Connect to the data source, dbtoolboxdemo, if needed:

conn = database('dbtoolboxdemo', '', '');

Alternatively, you can use the native ODBC interface for an ODBC connection. For

details, see database.

Use setdbprefs to set the format for retrieved data to numeric:

setdbprefs('DataReturnFormat','numeric')

Import ten rows of data the March column of data from the salesVolume table.

curs = exec(conn, 'select March from salesVolume');

curs = fetch(curs);

Assign the data to the MATLAB workspace variable AA:

AA = curs.Data

AA =

981

1414

890

1800

2600

1 2 ... 355 356 357 358 359 360 361 362 363 364 365 ... 683 684

Komentáře k této Příručce

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 360

Komentáře k této Příručce

Související produkty a manuály pro Software MATLAB DATABASE TOOLBOX RELEASE NOTES