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

100

101

7 Functions — Alphabetical List

7-212

results{1}

ans =

35000

The maximum sales volume in December is 35,000.

Close the database connection conn.

close(conn)

Call a Stored Procedure with Input and Output Arguments

Define a stored procedure named getSuppCount that counts the number of suppliers for

a specified city by executing this code. This procedure has one input argument cityName

and one output argument suppCount. This code assumes you are using a Microsoft SQL

Server database.

CREATE PROCEDURE getSuppCount

(@cityName varchar(20),

@suppCount int OUTPUT)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

SELECT @suppCount = count(supplierNumber)

from suppliers where City = @cityName;

END

Create a Microsoft SQL Server database connection conn using the JDBC driver. For

details, see “Connecting to a Database”. Then, call the stored procedure getSuppCount

using the database connection conn. The input argument inputarg is a cell array

containing the string 'New York'. The output Java data type outputtype is numeric.

inputarg = {'New York'};

outputtype = {java.sql.Types.NUMERIC};

results = runstoredprocedure(conn,'getSuppCount',inputarg,outputtype)

results =

1 2 ... 637 638 639 640 641 642 643 644 645 646 647 ... 683 684

Komentarze do niniejszej Instrukcji

Brak uwag

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

Komentarze do niniejszej Instrukcji

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