Back to OIM Explorer

dbo.QBM_FCVElementToObjectKey1

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 544 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_FCV0C695385CB1124DCEA40A_ source text reference
  • references source dbo.QBM_FCVStringToXMLMasked source text reference

References

Referenced By

Complete Source

SQL18 lines
1CREATE FUNCTION dbo.QBM_FCVElementToObjectKey1(2  @TableName varchar(32),3  @ColumnName1Dummy varchar(32),4  @Value1 varchar(256)5) RETURNS varchar(1386)7AS8BEGIN9  RETURN(CASE10  WHEN len(@Value1) = 36 THEN11  CONCAT('<Key><T>', dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName), '</T><P>', @value1, '</P></Key>')12  ELSE CONCAT('<Key><T>', dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName), '</T>', '<P>', CASE13  WHEN @value1 LIKE '%<%' THEN14  rtrim(dbo.QBM_FCVStringToXMLMasked(@value1))15  ELSE rtrim(@value1)16  END, '</P>', '</Key>')17  END)18END
Open raw exported source
SQL ยท Raw5 lines
1 create   function dbo.QBM_FCVElementToObjectKey1 (@TableName varchar(32), @ColumnName1Dummy varchar(32),  @Value1 varchar(256) ) returns varchar2(138) as begin return(  case when len(@Value1) = 36 then concat('<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName) , '</T><P>' , @value1 , '</P></Key>'3 ) else  concat( '<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName) , '</T>' , '<P>' ,case when @value1 like '%<%' then rtrim(dbo.QBM_FCVStringToXMLMasked4(@value1)) else rtrim(@value1) end , '</P>' , '</Key>' )   end  ) end 5