MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 498)

100

101

7 Functions — Alphabetical List

7-68

sqlquery = ['select * from [toy_store].[dbo].[productTable] '...

'order by productNumber'];

dbds = datastore(conn,sqlquery);

Read the first five records.

read(dbds,5)

ans =

productNumber stockNumber supplierNumber unitCost productDescription

_____________ ___________ ______________ ________ __________________

1.00 400345.00 1001.00 14.00 'Building Blocks'

2.00 400314.00 1002.00 9.00 'Painting Set'

3.00 400999.00 1009.00 17.00 'Slinky'

4.00 400339.00 1008.00 21.00 'Space Cruiser'

5.00 400455.00 1005.00 3.00 'Tin Soldier'

Determine if the DatabaseDatastore has additional data.

hasdata(dbds)

ans =

hasdata returns 1. There is more data to read in the cursor object of the

DatabaseDatastore object dbds.

Read the rest of the data in the DatabaseDatastore object dbds five records at a time.

while(hasdata(dbds))

read(dbds,5)

end

ans =

productNumber stockNumber supplierNumber unitCost productDescription

_____________ ___________ ______________ ________ __________________

6.00 400876.00 1004.00 8.00 'Sail Boat'

7.00 389123.00 1007.00 16.00 'Engine Kit'

8.00 212569.00 1001.00 5.00 'Train Set'

9.00 125970.00 1003.00 13.00 'Victorian Doll'

10.00 888652.00 1006.00 24.00 'Teddy Bear'

ans =

productNumber stockNumber supplierNumber unitCost productDescription

_____________ ___________ ______________ ________ __________________

1 2 ... 493 494 495 496 497 498 499 500 501 502 503 ... 683 684

Komentarze do niniejszej Instrukcji

Brak uwag

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

Komentarze do niniejszej Instrukcji

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