UFN_BUSINESSPROCESS_GETALLOWOUTPUTTABLEREMOVAL
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSCATALOGID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_BUSINESSPROCESS_GETALLOWOUTPUTTABLEREMOVAL]
(
@BUSINESSPROCESSCATALOGID uniqueidentifier
)
returns bit
as begin
declare @ALLOWED bit;
select @ALLOWED =
case when isnull([BUSINESSPROCESSCATALOG].[BUSINESSPROCESSSPECXML].value('declare namespace ns="bb_appfx_businessprocess";/ns:BusinessProcessSpec[1]/@GeneratesOutput', 'bit'), 0) = 1
and isnull([BUSINESSPROCESSCATALOG].[BUSINESSPROCESSSPECXML].value('declare namespace ns="bb_appfx_businessprocess";/ns:BusinessProcessSpec[1]/@AllowOutputTableRemoval', 'bit'), 0) = 1
then 1 else 0 end
from dbo.[BUSINESSPROCESSCATALOG]
where [ID] = @BUSINESSPROCESSCATALOGID;
return @ALLOWED;
end