Back to OIM Explorer

dbo.ATT_TUHardware

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on Hardware. Trigger parent table: Hardware

Source: sandbox-db sys.sql_modules

Source size: 1.020 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: Hardware

Typed Edges

  • trigger on table Hardware Trigger parent table: Hardware
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_Recalc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL53 lines
1CREATE trigger ATT_TUHardware2  ON Hardware FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @Parameter nvarchar(1000)7  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted)16    GOTO start17    RETURN start:18    IF19    UPDATE(UID_PersonOwner)20    BEGIN21      DECLARE @RecalcParameter_01 QBM_YCursorBuffer22      INSERT INTO @RecalcParameter_01(ObjectKey1,23      UID1,24      Ident1)25      SELECT26        dbo.QBM_FCVElementToObjectKey1('Person',27        'UID_Person',28        i.UID_PersonOwner) AS ObjectKey,29        'ATT-DB3656229AB30E439BAB4F6B23873A0E' AS UID_PWODecisionRule,30        'A'31      FROM inserted i32      UNION all33      SELECT34        dbo.QBM_FCVElementToObjectKey1('Person',35        'UID_Person',36        d.UID_PersonOwner) AS ObjectKey,37        'ATT-DB3656229AB30E439BAB4F6B23873A0E' AS UID_PWODecisionRule,38        'A'39      FROM deleted d40      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,41        @GenprocID42    END43  END TRY44  BEGIN CATCH45    EXEC QBM_PSessionErrorAdd DEFAULT46    RAISERROR('',47    18,48    1)49      WITH NOWAIT50  END CATCH51  ende:52  RETURN53END
Open raw exported source
SQL ยท Raw8 lines
1 create   trigger ATT_TUHardware on Hardware  for Update not for Replication as begin  declare @Parameter nvarchar(1000) declare @GenProcID varchar2(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return3 start: if update(UID_PersonOwner) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select4 dbo.QBM_FCVElementToObjectKey1('Person', 'UID_Person', i.UID_PersonOwner) as ObjectKey , 'ATT-DB3656229AB30E439BAB4F6B23873A0E' as UID_PWODecisionRule5, 'A' from inserted i union all select dbo.QBM_FCVElementToObjectKey1('Person', 'UID_Person', d.UID_PersonOwner) as ObjectKey , 'ATT-DB3656229AB30E439BAB4F6B23873A0E'6 as UID_PWODecisionRule, 'A' from deleted d exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd7 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 8