USP_IMPORTFIXEDWIDTHFILETEMPLATE_EDIT

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_EDIT
(
    @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 = null
)
with execute as caller
as

    set nocount on;

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

  declare @CURRENTDATE datetime = getdate()

    begin try
        update 
      dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
    set        
            NAME = @NAME,
        BATCHTEMPLATEID = @BATCHTEMPLATEID,        
        FILENAME = @FILENAME,
      SITEID = @SITEID,    
      DETAILCOLUMNMAP = @DETAILCOLUMNMAP,            
        DETAILROWPREFIX = @DETAILROWPREFIX,
      BATCHSUMMARYPREFIX = @BATCHSUMMARYPREFIX,
      FILESUMMARYPREFIX = @FILESUMMARYPREFIX,      
      FIXEDWIDTHDEFINITION = @FIXEDWIDTHDEFINITION, 
      BATCHRECORDCOUNTSTARTPOSITION = @BATCHRECORDCOUNTSTARTPOSITION,
      BATCHRECORDCOUNTENDPOSITION = @BATCHRECORDCOUNTENDPOSITION,
      BATCHREVENUECOUNTSTARTPOSITION = @BATCHREVENUECOUNTSTARTPOSITION,
      BATCHREVENUECOUNTENDPOSITION = @BATCHREVENUECOUNTENDPOSITION,
      FILERECORDCOUNTSTARTPOSITION = @FILERECORDCOUNTSTARTPOSITION,
      FILERECORDCOUNTENDPOSITION = @FILERECORDCOUNTENDPOSITION,
      FILEREVENUECOUNTSTARTPOSITION = @FILEREVENUECOUNTSTARTPOSITION,
      FILEREVENUECOUNTENDPOSITION = @FILEREVENUECOUNTENDPOSITION,
      FIELDIDCOLUMN = @FIELDIDCOLUMN,
      STARTPOSITIONCOLUMN = @STARTPOSITIONCOLUMN,
      ENDPOSITIONCOLUMN = @ENDPOSITIONCOLUMN,
      LAYOUTFILEHASHEADERROW = @LAYOUTFILEHASHEADERROW,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
        where
      ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;