USP_IMPORTFIXEDWIDTHFILETEMPLATE_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@NAME	nvarchar(250)	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@FILENAME	nvarchar(255)	IN
@SITEID	uniqueidentifier	IN
@DETAILCOLUMNMAP	xml	IN
@DETAILROWPREFIX	nvarchar(50)	IN
@BATCHSUMMARYPREFIX	nvarchar(50)	IN
@FILESUMMARYPREFIX	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@FIXEDWIDTHDEFINITION	nvarchar(max)	IN
@BATCHRECORDCOUNTSTARTPOSITION	bigint	IN
@BATCHRECORDCOUNTENDPOSITION	bigint	IN
@BATCHREVENUECOUNTSTARTPOSITION	bigint	IN
@BATCHREVENUECOUNTENDPOSITION	bigint	IN
@FILERECORDCOUNTSTARTPOSITION	bigint	IN
@FILERECORDCOUNTENDPOSITION	bigint	IN
@FILEREVENUECOUNTSTARTPOSITION	bigint	IN
@FILEREVENUECOUNTENDPOSITION	bigint	IN
@FIELDIDCOLUMN	nvarchar(250)	IN
@STARTPOSITIONCOLUMN	nvarchar(250)	IN
@ENDPOSITIONCOLUMN	nvarchar(250)	IN
@LAYOUTFILEHASHEADERROW	bit	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTFIXEDWIDTHFILETEMPLATE_ADD
(
    @ID uniqueidentifier = null output,
  @NAME nvarchar(250) = '',
    @BATCHTEMPLATEID uniqueidentifier = null,        
    @FILENAME nvarchar(255) = '',
  @SITEID uniqueidentifier = null,    
  @DETAILCOLUMNMAP xml = null,            
    @DETAILROWPREFIX nvarchar(50) = '',
  @BATCHSUMMARYPREFIX nvarchar(50) = '',
  @FILESUMMARYPREFIX nvarchar(50) = '',
  @CHANGEAGENTID uniqueidentifier = null,
  @FIXEDWIDTHDEFINITION nvarchar(max) = '', 
  @BATCHRECORDCOUNTSTARTPOSITION bigint = null,
  @BATCHRECORDCOUNTENDPOSITION bigint = null,
  @BATCHREVENUECOUNTSTARTPOSITION bigint = null,
  @BATCHREVENUECOUNTENDPOSITION bigint = null,
  @FILERECORDCOUNTSTARTPOSITION bigint = null,
  @FILERECORDCOUNTENDPOSITION bigint = null,
  @FILEREVENUECOUNTSTARTPOSITION bigint = null,
  @FILEREVENUECOUNTENDPOSITION bigint = null,
  @FIELDIDCOLUMN nvarchar(250) = null,
  @STARTPOSITIONCOLUMN nvarchar(250) = null,
  @ENDPOSITIONCOLUMN nvarchar(250) = null,
  @LAYOUTFILEHASHEADERROW bit = 1
)
with execute as caller
as

    set nocount on;

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

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

  declare @CURRENTDATE datetime = getdate()

    begin try
        insert into dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
        (
            ID,
      NAME,
        BATCHTEMPLATEID,        
        FILENAME,
      SITEID,    
      DETAILCOLUMNMAP,            
        DETAILROWPREFIX,
      BATCHSUMMARYPREFIX,
      FILESUMMARYPREFIX,      
      FIXEDWIDTHDEFINITION, 
      BATCHRECORDCOUNTSTARTPOSITION,
      BATCHRECORDCOUNTENDPOSITION,
      BATCHREVENUECOUNTSTARTPOSITION,
      BATCHREVENUECOUNTENDPOSITION,
      FILERECORDCOUNTSTARTPOSITION,
      FILERECORDCOUNTENDPOSITION,
      FILEREVENUECOUNTSTARTPOSITION,
      FILEREVENUECOUNTENDPOSITION,
      FIELDIDCOLUMN,
      STARTPOSITIONCOLUMN,
      ENDPOSITIONCOLUMN,
      LAYOUTFILEHASHEADERROW,
      ADDEDBYID,
      CHANGEDBYID,
      DATEADDED,
      DATECHANGED
        ) 
        values 
        (
            @ID,
      @NAME,
        @BATCHTEMPLATEID,        
        @FILENAME,
      @SITEID,    
      @DETAILCOLUMNMAP,            
        @DETAILROWPREFIX,
      @BATCHSUMMARYPREFIX,
      @FILESUMMARYPREFIX,      
      @FIXEDWIDTHDEFINITION, 
      @BATCHRECORDCOUNTSTARTPOSITION,
      @BATCHRECORDCOUNTENDPOSITION,
      @BATCHREVENUECOUNTSTARTPOSITION,
      @BATCHREVENUECOUNTENDPOSITION,
      @FILERECORDCOUNTSTARTPOSITION,
      @FILERECORDCOUNTENDPOSITION,
      @FILEREVENUECOUNTSTARTPOSITION,
      @FILEREVENUECOUNTENDPOSITION,
      @FIELDIDCOLUMN,
      @STARTPOSITIONCOLUMN,
      @ENDPOSITIONCOLUMN,
      @LAYOUTFILEHASHEADERROW,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
        )
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;