MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 649)

100

101

set

7-219

Property Value Description

set, fetch behaves differently depending

on what type of database you are using.

Drivermanager Objects

The allowable property and value for a drivermanager object appear in the following

table.

Property Value Description

'LoginTimeout' positive integer Sets the logintimeout value

for all loaded database drivers.

For command-line help on set, use the overloaded methods:

help cursor/set

help database/set

help drivermanager/set

Examples

Example 1 — Set RowLimit for Cursor

This example does the following:

• Establishes a JDBC connection to a data source.

• Runs fetch to retrieve data from the table EMP.

• Sets RowLimit to 5.

conn = database('orcl','scott','tiger',...

'oracle.jdbc.driver.OracleDriver',...

'jdbc:oracle:thin:@144.212.123.24:1822:');

curs = exec(conn,'select * from EMP');

set(curs,'RowLimit',5)

curs = fetch(curs)

curs =

Attributes: []

Data: {5x8 cell}

DatabaseObject: [1x1 database]

RowLimit: 5

1 2 ... 644 645 646 647 648 649 650 651 652 653 654 ... 683 684

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 649

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES