Back to OIM Explorer

dbo.CPL_TIComplianceRule

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ComplianceRule. Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 13; Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 13; Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 13; Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 15

Source: sandbox-db sys.sql_modules

Source size: 1.706 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 -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 13
  • Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 13
  • Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 13
  • Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 15
  • Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 15
  • Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 16
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: ComplianceRule

Typed Edges

  • queues DBQueue task CPL_ZSubRuleFillPerson at line 13 Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 13
  • queues DBQueue task CPL_ZComplianceCheckMakeProc at line 13 Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 13
  • queues DBQueue task CPL_ZComplianceCheckForRule at line 13 Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 13
  • queues DBQueue task CPL_ZComplianceCheckMakeProc at line 15 Bulk DBQueue insert -> CPL-K-ComplianceCheckMakeProc / CPL_ZComplianceCheckMakeProc at line 15
  • queues DBQueue task CPL_ZComplianceCheckForRule at line 15 Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 15
  • queues DBQueue task CPL_ZComplianceCheckForRule at line 16 Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 16
  • trigger on table ComplianceRule Trigger parent table: ComplianceRule
  • 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 source dbo.QBM_PSQLCheckExecutable source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL81 lines
1CREATE trigger CPL_TIComplianceRule2  ON ComplianceRule FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    INSERT INTO @SQLToCheck(Parameter1,16    ContentFull)17    SELECT18      c.XObjectKey,19      'select top 1 1 as columnvalue from ' + 'Person' + '20		 where ( 21		 ' + c.WhereClause + '22		 )'23    FROM inserted c24    WHERE25      c.WhereClause > ' ' AND c.IsSimpleMode = 026    INSERT INTO @SQLToCheck(Parameter1,27    ContentFull)28    SELECT29      c.XObjectKey,30      'select top 1 1 as columnvalue from ' + 'Person' + '31		 where (32		 ' + c.WhereClausePerson + '33		 )'34    FROM inserted c35    WHERE36      c.WhereClausePerson > ' '37    EXEC QBM_PSQLCheckExecutable @SQLToCheck,38      @RaiseError = 139    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw40    INSERT INTO @DBQueueElements_01(object,41    subobject,42    genprocid)43    SELECT44      x.uid,45      NULL,46      @GenProcID47    FROM(48    SELECT i.uid_ComplianceRule AS uid49    FROM inserted i50    WHERE51      isnull(IsInactive, 0) = 0) AS x52    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson',53      @DBQueueElements_0154    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw55    INSERT INTO @DBQueueElements_02(object,56    subobject,57    genprocid)58    SELECT59      x.uid,60      NULL,61      @GenProcID62    FROM(63    SELECT i.uid_ComplianceRule AS uid64    FROM inserted i65    WHERE66      isnull(IsInactive, 0) = 0 AND isnull(IsWorkingCopy, 0) = 0) AS x67    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckMakeProc',68      @DBQueueElements_0269    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckForRule',70      @DBQueueElements_0271  END TRY72  BEGIN CATCH73    EXEC QBM_PSessionErrorAdd DEFAULT74    RAISERROR('',75    18,76    1)77      WITH NOWAIT78  END CATCH79  ende:80  RETURN81END
Open raw exported source
SQL ยท Raw18 lines
1    create   trigger CPL_TIComplianceRule on ComplianceRule  for Insert not for Replication as begin  declare @SQLToCheck QBM_YParameterList BEGIN2 TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')3  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + 'Person' + '4		 where ( 5		 ' + c.WhereClause6 + '7		 )' from inserted c  where c.WhereClause > ' ' and c.IsSimpleMode = 0  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from '8 + 'Person' + '9		 where (10		 ' + c.WhereClausePerson + '11		 )' from inserted c  where c.WhereClausePerson > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck12, @RaiseError = 1 declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID13 from ( select i.uid_ComplianceRule as uid from inserted i where  isnull(IsInactive,0) = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson'14, @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID15 from ( select i.uid_ComplianceRule as uid from inserted i where isnull(IsInactive,0) = 0 and isnull(IsWorkingCopy,0) = 0 ) as x exec QBM_PDBQueueInsert_Bulk16 'CPL-K-ComplianceCheckMakeProc', @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckForRule', @DBQueueElements_02    END TRY BEGIN17 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 18