Back to OIM Explorer

dbo.QBM_FCVJobParamDeflate

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.328 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVIntToString source text reference
  • references source dbo.QBM_FCVListToJobParameter source text reference
  • references source dbo.QBM_FCVStringToInt source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FCVJobParameterToList source text reference

References

Referenced By

Complete Source

SQL58 lines
1CREATE FUNCTION dbo.QBM_FCVJobParamDeflate(2  @ComponentClass nvarchar(256),3  @TaskName nvarchar(256),4  @ParamIn nvarchar(max)5) RETURNS nvarchar(max6)7AS8BEGIN9  DECLARE @Work QBM_YParameterList10  DECLARE @MaxLen int11  DECLARE @Aenderungen int = 012  DECLARE @ParamErg nvarchar(max)13  DECLARE @UpdateComponent nvarchar(128) = 'VI.JobService.JobComponents.AutoUpdateComponent'14  SELECT15    @MaxLen = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\ProcessState\JobHistory\TrimLongParameters'),16    2000)17  IF len(@paramin) > @MaxLen18  BEGIN19    INSERT INTO @Work(Parameter1,20    ContentFull,21    Parameter2,22    Parameter3)23    SELECT24      x.ParameterName,25      x.ParameterValue,26      x.isHidden,27      x.isCrypted28    FROM dbo.QBM_FCVJobParameterToList(@paramin) x29    UPDATE @Work30    SET ContentFull = 'Content removed'31    FROM @Work w32    WHERE33      (w.Parameter1 = 'AssemblyData' AND @ComponentClass = @UpdateComponent)34    SELECT @Aenderungen = @@ROWCOUNT35    UPDATE @Work36    SET ContentFull = CONCAT('Content trimmed (',37    dbo.QBM_FCVIntToString(@MaxLen),38    ') chars: ',39    LEFT(w.ContentFull, @MaxLen))40    FROM @Work w41    WHERE42      DATALENGTH(w.ContentFull) > @MaxLen * 243    SELECT @Aenderungen += @@ROWCOUNT44  END45  IF @Aenderungen > 046  BEGIN47    SELECT48      @ParamErg = dbo.QBM_FCVListToJobParameter(@componentclass,49      @TaskName,50      @work)51  END52  ELSE53  BEGIN54    SELECT @ParamErg = @ParamIn55  END56  ende:57  RETURN(@ParamErg)58END
Open raw exported source
SQL ยท Raw10 lines
1    create   function dbo.QBM_FCVJobParamDeflate ( @ComponentClass nvarchar(256) , @TaskName nvarchar(256) , @ParamIn nvarchar(max) ) returns nvarchar2(max) as begin declare @Work QBM_YParameterList declare @MaxLen int declare @Aenderungen int = 0 declare @ParamErg nvarchar(max) declare @UpdateComponent3 nvarchar(128) = 'VI.JobService.JobComponents.AutoUpdateComponent' select @MaxLen = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\ProcessState\JobHistory\TrimLongParameters'4), 2000) if len(@paramin) > @MaxLen begin insert into @Work(Parameter1, ContentFull, Parameter2, Parameter3) select x.ParameterName, x.ParameterValue, 5x.isHidden, x.isCrypted from dbo.QBM_FCVJobParameterToList (@paramin) x update @Work set ContentFull = 'Content removed' from @Work w where ( w.Parameter16 = 'AssemblyData' and @ComponentClass = @UpdateComponent ) select @Aenderungen = @@ROWCOUNT update @Work set ContentFull = concat('Content trimmed (' ,7 dbo.QBM_FCVIntToString(@MaxLen) , ') chars: ' , left(w.ContentFull, @MaxLen) ) from @Work w where DATALENGTH(w.ContentFull) > @MaxLen * 2 select @Aenderungen8 += @@ROWCOUNT end  if @Aenderungen > 0 begin  select @ParamErg = dbo.QBM_FCVListToJobParameter(@componentclass, @TaskName, @work) end else begin  select9 @ParamErg = @ParamIn end ende: return (@ParamErg) end 10