MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario Pagina 470

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 684
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 469
7 Functions — Alphabetical List
7-40
ans =
13
5
16
Close the cursor object.
close(curs)
Import Boolean Data
Import data that includes a BOOLEAN field, using the setdbprefs function to specify
cellarray as the format for the retrieved data.
curs = exec(conn,['select InvoiceNumber, '...
'Paid from Invoice']);
setdbprefs('DataReturnFormat','cellarray')
curs = fetch(curs,5);
A = curs.Data
A =
[ 2101] [0]
[ 3546] [1]
[33116] [1]
[34155] [0]
[34267] [1]
View the class of the second column of A.
class(A{1,2})
ans =
logical
Close the cursor object.
close(curs)
Perform Incremental Fetch
Working with the dbtoolboxdemo data source, retrieve data incrementally to
avoid Java heap errors. Use cursor.fetch with the setdbprefs properties for
FetchInBatches and FetchBatchSize to fetch large data sets.
Vista de pagina 469
1 2 ... 465 466 467 468 469 470 471 472 473 474 475 ... 683 684

Comentarios a estos manuales

Sin comentarios