Back to OIM Explorer

dbo.DPR_TUDialogColumn

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogColumn. HOFireEvent -> DialogDatabase.UpdateSystemSyncs at line 6; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*; Trigger parent table: DialogColumn

Source: sandbox-db sys.sql_modules

Source size: 1.181 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 -> DialogDatabase.UpdateSystemSyncs at line 6
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • Trigger parent table: DialogColumn

Typed Edges

  • fires event DialogDatabase.UpdateSystemSyncs HOFireEvent -> DialogDatabase.UpdateSystemSyncs at line 6
  • trigger on table DialogColumn Trigger parent table: DialogColumn
  • 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_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL64 lines
1CREATE trigger DPR_TUDialogColumn2  ON DialogColumn FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @Starten datetime = dateadd(ss,7  100,8  getutcdate())9  DECLARE @UID_Job varchar(38) = NULL10  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')11  BEGIN TRY12    IF EXISTS(13      SELECT TOP 1 114      FROM inserted)15    GOTO start16    IF EXISTS(17      SELECT TOP 1 118      FROM deleted)19    GOTO start20    RETURN start:21    IF22    UPDATE(SystemSyncDirection)23    BEGIN24      IF EXISTS(25        SELECT TOP 1 126        FROM DialogColumn c27        JOIN deleted d28          ON c.uid_DialogColumn = d.uid_dialogcolumn29        WHERE30          c.SystemSyncDirection <> d.SystemSyncDirection)31      BEGIN32        SELECT TOP 1 @UID_Job = q.UID_Job33        FROM JobQueue q34        WHERE35          q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase' AND q.Ready2EXE = N 'TRUE'36        IF @UID_Job > ' '37        BEGIN38          UPDATE JobQueue39          SET StartAt = @Starten40          WHERE41            UID_Job = @UID_Job42        END43        ELSE44        BEGIN45          EXEC QBM_PJobCreate_HOFireEvent 'DialogDatabase',46          'IsMainDatabase = 1',47          'UpdateSystemSyncs',48            @GenProcID,49            @ObjectKeysAffected = DEFAULT,50            @Startat = @Starten51        END52      END53    END54  END TRY55  BEGIN CATCH56    EXEC QBM_PSessionErrorAdd DEFAULT57    RAISERROR('',58    18,59    1)60      WITH NOWAIT61  END CATCH62  ende:63  RETURN64END
Open raw exported source
SQL ยท Raw9 lines
1  create   trigger DPR_TUDialogColumn on DialogColumn  for Update not for Replication as begin declare @Starten datetime = dateadd(ss, 100, getutcdate2()) declare @UID_Job varchar(38) = null declare @GenProcID varchar(38)= dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted3) goto start if exists (select top 1 1 from deleted) goto start return start: if update(SystemSyncDirection) begin if exists (select top 1 1 from DialogColumn4 c join deleted d on c.uid_DialogColumn = d.uid_dialogcolumn where c.SystemSyncDirection <> d.SystemSyncDirection ) begin select top 1 @UID_Job = q.UID_Job5 from JobQueue q where q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase' and q.Ready2EXE = N'TRUE'6  if @UID_Job > ' '  begin  update JobQueue set StartAt = @Starten where UID_Job = @UID_Job end else begin   exec QBM_PJobCreate_HOFireEvent 'DialogDatabase'7, 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd8 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 9