USP_IMPORTPROCESSBATCH_ADD

Adds an import process/batch link record.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IMPORTFILEHEADERROW	nvarchar(max)	IN
@BATCHCOMMITOPTION	tinyint	IN
@FILENAME	nvarchar(255)	IN
@SUBDIRECTORY	nvarchar(550)	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTPROCESSBATCH_ADD(@ID uniqueidentifier = null output,
    @BUSINESSPROCESSSTATUSID uniqueidentifier, 
    @BATCHID uniqueidentifier, 
    @CHANGEAGENTID uniqueidentifier,
    @IMPORTFILEHEADERROW nvarchar(max) = '',
  @BATCHCOMMITOPTION tinyint = 0,
  @FILENAME nvarchar(255) = '',
  @SUBDIRECTORY nvarchar(550) = '')
as
    set nocount on;

    if @ID is null
        set @ID = newid();

    insert into dbo.IMPORTPROCESSBATCH (ID, 
    BUSINESSPROCESSSTATUSID, 
        BATCHID, 
        IMPORTFILEHEADERROW,
    BATCHCOMMITOPTIONCODE,
    FILENAME,
    SUBDIRECTORY,
        ADDEDBYID, 
        CHANGEDBYID, 
        DATEADDED, 
        DATECHANGED) 
    values (@ID,
    @BUSINESSPROCESSSTATUSID, 
        @BATCHID, 
        @IMPORTFILEHEADERROW,
    @BATCHCOMMITOPTION,
    @FILENAME,
    @SUBDIRECTORY,
        @CHANGEAGENTID, 
        @CHANGEAGENTID, 
        getdate(), 
        getdate());