Back to OIM Explorer

dbo.QBM_TIQBMServerHasDeployTarget

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on QBMServerHasDeployTarget. HOFireEvent -> QBMServer.DeployTargetChanged at line 5; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*; Trigger parent table: QBMServerHasDeployTarget

Source: sandbox-db sys.sql_modules

Source size: 1.047 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOFireEvent -> QBMServer.DeployTargetChanged at line 5
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • Trigger parent table: QBMServerHasDeployTarget

Typed Edges

  • fires event QBMServer.DeployTargetChanged HOFireEvent -> QBMServer.DeployTargetChanged at line 5
  • trigger on table QBMServerHasDeployTarget Trigger parent table: QBMServerHasDeployTarget
  • references source dbo.QBM_FCVStringToInt source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_TIQBMServer source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL46 lines
1CREATE trigger QBM_TIQBMServerHasDeployTarget2  ON QBMServerHasDeployTarget FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  DECLARE @XUser nvarchar(64)8  DECLARE @EntriesToFire QBM_YParameterList9  DECLARE @ConfigparmAutoupdate int10  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM inserted)14    GOTO start15    RETURN start:16    SELECT @GenProcID = dbo.QBM_FGISessionContext('')17    SELECT @XUser = dbo.QBM_FGISessionContext('XUser')18    SELECT19      @ConfigparmAutoupdate = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\Autoupdate'),20      0)21    IF dbo.QBM_FGISessionContext('Fullsync') = ''22    BEGIN23      INSERT INTO @EntriesToFire(Parameter1)24      SELECT25        DISTINCT q.XObjectKey26      FROM inserted x27      JOIN QBMServer q28        ON x.UID_QBMServer = q.UID_QBMServer29      WHERE30        @ConfigparmAutoupdate = 131      EXEC QBM_PJobCreate_HOFireEvent_L 'QBMServer',32        @EntriesToFire,33      'DeployTargetChanged',34        @GenProcID,35        @CheckForExisting = 1,36        @AdditionalObjectKeysAffected = DEFAULT37    END38  END TRY39  BEGIN CATCH40    EXEC QBM_PSessionErrorAdd DEFAULT41    RAISERROR('',42    18,43    1)44      WITH NOWAIT45  END CATCH46END
Open raw exported source
SQL ยท Raw8 lines
1   create   trigger QBM_TIQBMServerHasDeployTarget on QBMServerHasDeployTarget  for Insert not for Replication as begin  declare @GenProcID varchar2(38) declare @XUser nvarchar(64) declare @EntriesToFire QBM_YParameterList declare @ConfigparmAutoupdate int BEGIN TRY if exists (select top 1 1 from inserted3) goto start return start: select @GenProcID = dbo.QBM_FGISessionContext('') select @XUser = dbo.QBM_FGISessionContext('XUser') select @ConfigparmAutoupdate4 = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\Autoupdate'), 0)  if dbo.QBM_FGISessionContext ('Fullsync') = '' begin insert into @EntriesToFire5 (Parameter1) select distinct q.XObjectKey from inserted x join QBMServer q on x.UID_QBMServer = q.UID_QBMServer where @ConfigparmAutoupdate = 1 exec QBM_PJobCreate_HOFireEvent_L6 'QBMServer', @EntriesToFire ,'DeployTargetChanged', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT end END TRY BEGIN CATCH7 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 8