MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador descarregar pdf (Página 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

Comentários a estes Manuais

Sem comentários

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

Comentários a estes Manuais

Manuais e produtos relacionados com Software MATLAB DATABASE TOOLBOX RELEASE NOTES