MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger pdf (Page 544)

100

101

7 Functions — Alphabetical List

7-114

Data: 0

RowLimit: 0

SQLQuery: 'select * from productTable'

Message: []

Type: 'ODBCCursor Object'

Statement: [1x1 database.internal.ODBCStatementHandle]

With the native ODBC interface, exec returns curs a database.ODBCCursor object

instead of a Database Cursor Object.

After finishing with the cursor object, close it.

close(curs)

Select Data from a Database Table

Using the dbtoolboxdemo data source, select data from the suppliers table that you

access using the database connection, conn. Assign the SQL statement to the variable

sqlquery. Assign the returned cursor object to the variable curs.

sqlquery = 'select City from suppliers';

curs = exec(conn,sqlquery)

curs =

Attributes: []

Data: 0

DatabaseObject: [1x1 database]

RowLimit: 0

SQLQuery: 'select City from suppliers'

Message: []

Type: 'Database Cursor Object'

ResultSet: [1x1 sun.jdbc.odbc.JdbcOdbcResultSet]

Cursor: [1x1 com.mathworks.toolbox.database.sqlExec]

Statement: [1x1 sun.jdbc.odbc.JdbcOdbcStatement]

Fetch: 0

After finishing with the cursor object, close it.

close(curs)

Select Data from a Database Table Using a Scrollable Cursor

Using a MySQL database, select data from a table that you access using the native

ODBC database connection conn and create a scrollable cursor.

1 2 ... 539 540 541 542 543 544 545 546 547 548 549 ... 683 684

Commentaires sur ces manuels

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 544

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES