11.8. Multi-Source Models: Stored Procedures

A physical stored procedure requires the addition of a string in parameter matching the multi-source column name to specify which source the procedure is executed on. If the parameter is not present and defaults to a null value, then the procedure will be executed on each source. It is not possible to execute procedures that are required to return IN/OUT, OUT, or RETURN parameters values on more than 1 source.

Example 11.1. Example DDL

CREATE FOREIGN PROCEDURE PROC (arg1 IN STRING NOT NULL, arg2 IN STRING, SOURCE_NAME IN STRING)

CREATE FOREIGN PROCEDURE PROC (arg1 IN STRING NOT NULL, arg2 IN STRING, SOURCE_NAME IN STRING)

Copy to Clipboard

Toggle word wrap

Example 11.2. Example Calls Against A Single Source

CALL PROC(arg1=>'x', SOURCE_NAME=>'sourceA')
EXEC PROC('x', 'y', 'sourceB')

CALL PROC(arg1=>'x', SOURCE_NAME=>'sourceA')
EXEC PROC('x', 'y', 'sourceB')

Copy to Clipboard

Toggle word wrap

Example 11.3. Example Calls Against All Sources

CALL PROC(arg1=>'x')
EXEC PROC('x', 'y')

CALL PROC(arg1=>'x')
EXEC PROC('x', 'y')

Copy to Clipboard

Toggle word wrap

返回顶部

此内容没有您所选择的语言版本。

11.8. Multi-Source Models: Stored Procedures

学习

尝试、购买和销售

社区

关于红帽文档

让开源更具包容性

關於紅帽

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links