USP_BATCH_SETCOMMITPARAMETERS

Sets the commit parameters for a given batch.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTIDSETNAME	nvarchar(100)	IN
@OVERWRITEOUTPUTIDSET	bit	IN
@CREATEEXCEPTIONBATCH	bit	IN
@EXCEPTIONBATCHNAME	nvarchar(60)	IN
@PURGEBATCH	bit	IN
@CREATECONTROLREPORT	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@VALIDATEBATCH	bit	IN

Definition

Copy



CREATE procedure [dbo].[USP_BATCH_SETCOMMITPARAMETERS](
    @ID uniqueidentifier,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @CREATEEXCEPTIONBATCH bit,
    @EXCEPTIONBATCHNAME nvarchar(60),
    @PURGEBATCH bit,
    @CREATECONTROLREPORT bit,
    @CHANGEAGENTID uniqueidentifier,
  @VALIDATEBATCH bit = null
) as 
    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    update dbo.BATCH set 
        CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
        OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
        OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
        CREATEEXCEPTIONBATCH = @CREATEEXCEPTIONBATCH,
        EXCEPTIONBATCHNAME = @EXCEPTIONBATCHNAME,
        PURGEBATCH = @PURGEBATCH,
        CREATECONTROLREPORT = @CREATECONTROLREPORT,
    VALIDATEBATCH = coalesce(@VALIDATEBATCH, (select VALIDATEBATCH from dbo.BATCH where ID = @ID)),
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where
        ID=@ID;

    return 0;