MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 388)

100

101

6 Using Database Toolbox Functions

6-46

Run a Custom Database Function

This example shows how to run a custom database function on Microsoft SQL Server.

Consider a database function get_prodCount that retrieves row counts in the table

productTable. The table productTable contains 30 rows where each row represents a

product. This code defines this database function and assumes a schema name dbo.

CREATE FUNCTION dbo.get_prodCount()

RETURNS int

BEGIN

DECLARE @PROD_COUNT int

SELECT @PROD_COUNT = count(*) from productTable

RETURN(@PROD_COUNT)

END

Create the Database Connection

Connect to Microsoft SQL Server. For example, this code assumes you are connecting to a

data source named MS SQL Server with user name username and password pwd.

conn = database.ODBCConnection('MS SQL Server','username','pwd');

Execute the Custom Function

Construct an SQL query string sqlquery that executes the custom function code.

Execute the custom function by running exec.

sqlquery = 'SELECT dbo.get_prodCount() as num_products';

curs = exec(conn,sqlquery);

curs = fetch(curs);

Display the result.

curs = fetch(curs);

curs.Data

ans =

[30.00]

The custom function get_prodCount returns the product count 30.

1 2 ... 383 384 385 386 387 388 389 390 391 392 393 ... 683 684

Commenti su questo manuale

Nessun commento

MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Pagina 388

Commenti su questo manuale

Prodotti e manuali riguardandi Software MATLAB DATABASE TOOLBOX RELEASE NOTES