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

Import Data Using a Scrollable Cursor with a Relative Position Offset

6-65

Import Data Using a Scrollable Cursor with a Relative Position

Offset

This example shows how to use a scrollable cursor to import data using both absolute and

relative position offsets. This example assumes you are connecting to a MySQL database

that contains a table called productTable. This table contains 15 records, where each

record represents one product. The scrollable cursor functionality behaves differently

depending on your database driver. For details about the scrollable cursor functionality

in your database, consult your database documentation.

Connect to the Database

Connect to the MySQL database using the native ODBC interface. This code assumes

you are connecting to a data source named MySQL with user name username and

password pwd.

conn = database.ODBCConnection('MySQL','username','pwd');

Create a Scrollable Cursor

Select all products from the productTable table and sort them in ascending order

by product number. Create a scrollable cursor using the name-value pair argument

'cursorType'.

curs = exec(conn,'select * from productTable order by productNumber',...

'cursorType','scrollable');

Retrieve Data Using an Absolute Position Offset

Import the data for two products in the middle of the data set. Use the row limit 2 to

import data for two products. Use the absolute position offset 5 to import data starting

from the fifth product in the data set.

curs = fetch(curs,2,'absolutePosition',5);

Display the data for the two products.

curs.Data

ans =

[5] [400455] [1005] [3] 'Tin Soldier'

[6] [400876] [1004] [8] 'Sail Boat'

1 2 ... 402 403 404 405 406 407 408 409 410 411 412 ... 683 684

Sin comentarios

Weitere Produkte und Handbücher für CD Spieler Philips

Modelle	Dokumententyp
DVDQ40/022	Bedienungsanleitung Philips DVDQ40/022 User's Manual, 26 Seiten
AZ382/12	Bedienungsanleitung Philips AZ382/12 User's Manual, 2 Seiten
MZ1000	Bedienungsanleitung Philips MZ1000 User's Manual, 25 Seiten
EXP4318	Bedienungsanleitung Philips EXP4318 User's Manual, 82 Seiten
AZT3201	Bedienungsanleitung Philips AZT3201 User's Manual, 10 Seiten
ACT 7585	Bedienungsanleitung Philips ACT 7585 User's Manual, 65 Seiten
AZ3012/01	Bedienungsanleitung Philips AZ3012/01 User's Manual, 8 Seiten
eXpanium EXP212	Bedienungsanleitung Philips eXpanium EXP212 User's Manual, 2 Seiten
AZ 1565/00	Bedienungsanleitung Philips AZ 1565/00 User's Manual, 63 Seiten
AZT3200	Bedienungsanleitung Philips AZT3202/17 User manual, 14 Seiten
EXP2550/58	Bedienungsanleitung Philips EXP2550/58 User manual, 2 Seiten
EXP3360	Bedienungsanleitung Philips EXP3360 User's Manual, 12 Seiten
AZ7681	Bedienungsanleitung Philips AZ7681 User's Manual, 132 Seiten
EXP220/01	Bedienungsanleitung Philips EXP220/01 User manual, 5 Seiten
PORTABLE SPORT AUDIO PSA[CD	Bedienungsanleitung Philips PORTABLE SPORT AUDIO PSA[CD User's Manual, 14 Seiten
AX5311/17	Bedienungsanleitung Philips AX5311/17 User manual, 13 Seiten
AZ7182	Bedienungsanleitung Philips AZ7182 User's Manual, 2 Seiten
AZ2000/01	Bedienungsanleitung Philips AZ2000/01 User's Manual, 11 Seiten
AX5301/00C	Bedienungsanleitung Philips AX5301/00C User's Manual, 2 Seiten
AZ 1145	Bedienungsanleitung Philips AZ 1145 User's Manual, 53 Seiten