USP_DATAFORMTEMPLATE_VIEW_COMMITMULTIPLEBATCHESPROCESS

The load procedure used by the view dataform template "Commit Multiple Batches Process View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@SELECTIONID	uniqueidentifier	INOUT	SELECTION
@SELECTIONNAME	nvarchar(100)	INOUT	Batches to include
@CREATEOUTPUTSELECTION	bit	INOUT	Create an output selection for each batch committed
@CREATEEXCEPTIONBATCHES	bit	INOUT	Create an exception batch for any exceptions encountered during the commit process
@PURGEBATCHES	bit	INOUT	Delete each batch after the commit process completes
@CREATEBATCHCONTROLREPORTS	bit	INOUT	Create control reports for each batch committed
@PARAMETERSID	uniqueidentifier	INOUT	Parameters id

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_COMMITMULTIPLEBATCHESPROCESS
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@NAME nvarchar(100) = null output,
@DESCRIPTION nvarchar(1000) = null output,
@SELECTIONID uniqueidentifier = null output,
@SELECTIONNAME nvarchar(100) = null output,
@CREATEOUTPUTSELECTION bit = null output,
@CREATEEXCEPTIONBATCHES bit = null output,
@PURGEBATCHES bit = null output,
@CREATEBATCHCONTROLREPORTS bit = null output,
@PARAMETERSID uniqueidentifier = null output
)
as 
begin
    set nocount on;

    set @DATALOADED = 0;    

    select
        @DATALOADED = 1,
        @NAME = BATCHESCOMMITPROCESS.NAME,
        @DESCRIPTION = BATCHESCOMMITPROCESS.DESCRIPTION,
        @SELECTIONID = BATCHESCOMMITPROCESS.SELECTIONID,        
        @CREATEOUTPUTSELECTION = BATCHESCOMMITPROCESS.CREATEOUTPUTSELECTION,
        @CREATEEXCEPTIONBATCHES = BATCHESCOMMITPROCESS.CREATEEXCEPTIONBATCHES,
        @PURGEBATCHES = BATCHESCOMMITPROCESS.PURGEBATCHES,
        @CREATEBATCHCONTROLREPORTS = BATCHESCOMMITPROCESS.CREATEBATCHCONTROLREPORTS,
        @PARAMETERSID = BATCHESCOMMITPROCESS.ID
    from
        dbo.BATCHESCOMMITPROCESS
    where BATCHESCOMMITPROCESS.ID = @ID;

    if @SELECTIONID is not null
        select @SELECTIONNAME=NAME from dbo.IDSETREGISTER where IDSETREGISTER.ID = @SELECTIONID;

    return 0;

end