MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 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

Komentáře k této Příručce

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 649

Komentáře k této Příručce

Související produkty a manuály pro Software MATLAB DATABASE TOOLBOX RELEASE NOTES