MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 577)

fetch

7-147

close(curs)

Import Data with Different Formats Using the Cursor Object

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

After finishing with the cursor object, close it.

close(curs)

Import Data Using the Database Connection Object

fetch imports data from the specified SQL statement when you pass a database object,

conn, as the first argument. Use this example when using a JDBC/ODBC bridge or a

JDBC interface. For the native ODBC interface, use curs as the input argument.

Using the dbtoolboxdemo data source that you access using the database connection

object, conn, import the productDescription column from productTable. Set the

data return format to 'cellarray' using setdbprefs.

setdbprefs('DataReturnFormat','cellarray')

1 2 ... 572 573 574 575 576 577 578 579 580 581 582 ... 683 684

Commenti su questo manuale

Nessun commento

Kitchenaid KUIS15NRHT5 Uživatelský manuál (8 strany)

Značka: Kitchenaid | Kategorie: Freezers | Velikost: 0.43 MB |

Angličtina

Tabulka s obsahem

CABINET LINER AND DOOR PARTS

1

Illus. Part

4

No. No. DESCRIPTION

4

PUMP PARTS

5

CONTROL PANEL PARTS

6

UNIT PARTS

7

Další produkty a příručky pro Mrazničky KitchenAid

Modely	Typ Dokumentu
KUIS15NRHW8	Uživatelský manuál KITCHENAID KUIS15NRHW8 User Manual, 9 stránky
KUIS15PRHB5	Uživatelský manuál KITCHENAID KUIS15PRHB5 User Manual, 8 stránky
KUIC15PRTS1	Uživatelský manuál KITCHENAID KUIC15PRTS1 User Manual, 9 stránky
KUIS185FWH1	Uživatelský manuál KITCHENAID KUIS185FWH1 User Manual, 8 stránky