MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung PDF herunterladen (Seite 385)

100

101

Call a Stored Procedure That Returns Data

6-43

Driver: []

URL: []

Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]

Message: []

Handle: [1x1 com.microsoft.sqlserver.jdbc.SQLServerConnection]

TimeOut: 0

AutoCommit: 'on'

Type: 'Database Object'

database returns conn, a connection Database Object for the 'test_db' database.

Alternatively, you can use the native ODBC interface for an ODBC connection. For

details, see database.

Call the Stored Procedure

To return the result set in table format, use setdbprefs to set 'DataReturnFormat'

to 'table'.

setdbprefs('DataReturnFormat','table')

Call the stored procedure, getSupplierInfo, to return supplier information for the city

of New York using exec with conn.

sqlquery = '{call getSupplierInfo(''New York'')}';

curs = exec(conn,sqlquery)

curs =

Attributes: []

Data: 0

DatabaseObject: [1x1 database]

RowLimit: 0

SQLQuery: '{call getSupplierInfo('New York')}'

Message: []

Type: 'Database Cursor Object'

ResultSet: [1x1 com.microsoft.sqlserver.jdbc.SQLServerResultSet]

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

Statement: [1x1 com.microsoft.sqlserver.jdbc.SQLServerStatement]

Fetch: 0

exec returns a Database Cursor Object, curs, containing the supplier information.

Retrieve Output Data from the Stored Procedure

Retrieve supplier data from curs using fetch.

1 2 ... 380 381 382 383 384 385 386 387 388 389 390 ... 683 684

Kommentare zu diesen Handbüchern

Keine Kommentare

MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung Seite 385

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software MATLAB DATABASE TOOLBOX RELEASE NOTES