Back to OIM Explorer

dbo.ATT_TIAttestationCase

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on AttestationCase. Bulk DBQueue insert -> ATT-K-AttestationHelper / ATT_ZAttestationHelperFill at line 6; Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 6; References QBM_PDBQueueInsert_Bulk; Trigger parent table: AttestationCase

Source: sandbox-db sys.sql_modules

Source size: 1.120 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> ATT-K-AttestationHelper / ATT_ZAttestationHelperFill at line 6
  • Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 6
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: AttestationCase

Typed Edges

  • queues DBQueue task ATT_ZAttestationHelperFill at line 6 Bulk DBQueue insert -> ATT-K-AttestationHelper / ATT_ZAttestationHelperFill at line 6
  • queues DBQueue task ATT_ZAttestationCheckValid at line 6 Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 6
  • trigger on table AttestationCase Trigger parent table: AttestationCase
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL60 lines
1CREATE trigger ATT_TIAttestationCase2  ON AttestationCase FOR3INSERT NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    IF EXISTS(15      SELECT TOP 1 116      FROM inserted i17      WHERE18        sign(len(isnull(i.UID_QERWorkingMethod, ''))) ^ i.IsClosed = 0)19    BEGIN20      RAISERROR('#LDS#Invalid combination of IsClosed and QERWorkingMethod.|',21      18,22      1)23        WITH nowait24    END25    IF EXISTS(26      SELECT TOP 1 127      FROM inserted i28      WHERE29        i.IsUnderConstruction = 0)30    BEGIN31      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw32      INSERT INTO @DBQueueElements_01(object,33      subobject,34      genprocid)35      SELECT36        x.uid,37        NULL,38        @GenProcID39      FROM(40      SELECT41        DISTINCT uid_AttestationCase AS uid42      FROM inserted43      WHERE44        isclosed = 0 AND IsUnderConstruction = 0) AS x45      EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationHelper',46        @DBQueueElements_0147      EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid',48        @DBQueueElements_0149    END50  END TRY51  BEGIN CATCH52    EXEC QBM_PSessionErrorAdd DEFAULT53    RAISERROR('',54    18,55    1)56      WITH NOWAIT57  END CATCH58  endLabel:59  RETURN60END
Open raw exported source
SQL ยท Raw9 lines
1    create   trigger ATT_TIAttestationCase on AttestationCase  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from2 inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if exists (select top 1 1  from inserted3 i where  sign(len(isnull(i.UID_QERWorkingMethod, ''))) ^ i.IsClosed = 0 ) begin raiserror('#LDS#Invalid combination of IsClosed and QERWorkingMethod.|'4, 18, 1) with nowait end      if exists (select top 1 1 from inserted i where i.IsUnderConstruction = 0  ) begin declare @DBQueueElements_01 QBM_YDBQueueRaw5 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uid_AttestationCase as uid from inserted6 where isclosed = 0 and IsUnderConstruction = 0 ) as x  exec QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationHelper', @DBQueueElements_01  exec QBM_PDBQueueInsert_Bulk7 'ATT-K-AttestationCheckValid', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH8 endLabel: return end 9