Back to OIM Explorer

dbo.QER_TUPWODecisionRuleRulerDete

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on PWODecisionRuleRulerDetect. bulk DBQueue insert -> QER-K-PWODecisionRuleMakeProc / QER_ZPWODecisionRuleMakeProc at line 10; bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 10; bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 12; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.988 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 -> QER-K-PWODecisionRuleMakeProc / QER_ZPWODecisionRuleMakeProc at line 10
  • bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 10
  • bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 12
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: PWODecisionRuleRulerDetect

Typed Edges

  • queues DBQueue task QER_ZPWODecisionRuleMakeProc at line 10 bulk DBQueue insert -> QER-K-PWODecisionRuleMakeProc / QER_ZPWODecisionRuleMakeProc at line 10
  • queues DBQueue task QER_ZPWOHelperFillMakeProc at line 10 bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 10
  • queues DBQueue task QER_ZPWOHelperFillMakeProc at line 12 bulk DBQueue insert -> QER-K-PWOHelperFillMakeProc / QER_ZPWOHelperFillMakeProc at line 12
  • trigger on table PWODecisionRuleRulerDetect Trigger parent table: PWODecisionRuleRulerDetect
  • 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 source dbo.QER_TUPWODecisionRule source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL84 lines
1CREATE trigger QER_TUPWODecisionRuleRulerDete2  ON PWODecisionRuleRulerDetect FOR3UPDATE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    IF EXISTS(12      SELECT TOP 1 113      FROM deleted)14    GOTO start15    RETURN start:16    DECLARE @GenProcID varchar(38)17    SELECT @GenProcID = dbo.QBM_FGISessionContext('')18    DECLARE @SQLToCheck_01 QBM_YParameterList19    INSERT INTO @SQLToCheck_01(Parameter1,20    ContentFull)21    SELECT22      c.XObjectKey,23      replace(replace(replace(c.SQLQuery, '@UID_AttestationCase', '''123'''), '@UID_PersonWantsorg', '''123'''),24      '@UID_QERWorkingStep',25      '''123''')26    FROM deleted d27    JOIN PWODecisionRuleRulerDetect c28      ON d.UID_PWODecisionRuleRulerDetect = c.UID_PWODecisionRuleRulerDetect29    WHERE30      isnull(d.SQLQuery,31    '') <> isnull(c.SQLQuery,32    '') AND c.SQLQuery > ' ' AND33    LEFT(ltrim(c.SQLQuery),34    4) <> 'exec'35    EXEC QBM_PSQLCheckExecutable @SQLToCheck_01,36      @RaiseError = 137    DECLARE @SQLToCheck_02 QBM_YParameterList38    INSERT INTO @SQLToCheck_02(Parameter1,39    ContentFull)40    SELECT41      c.XObjectKey,42      c.SQLQueryObjectsToRecalc43    FROM deleted d44    JOIN PWODecisionRuleRulerDetect c45      ON d.UID_PWODecisionRuleRulerDetect = c.UID_PWODecisionRuleRulerDetect46    WHERE47      isnull(d.SQLQueryObjectsToRecalc,48    '') <> isnull(c.SQLQueryObjectsToRecalc,49    '') AND c.SQLQueryObjectsToRecalc > ' '50    EXEC QBM_PSQLCheckExecutable @SQLToCheck_02,51      @RaiseError = 152    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw53    INSERT INTO @DBQueueElements_01(Object,54    SubObject,55    GenProcID)56    SELECT57      DISTINCT i.UID_PWODecisionRule,58      NULL,59      @GenProcID60    FROM inserted i61    EXEC QBM_PDBQueueInsert_bulk 'QER-K-PWODecisionRuleMakeProc',62      @DBQueueElements_0163    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw64    INSERT INTO @DBQueueElements_02(Object,65    SubObject,66    GenProcID)67    SELECT68      DISTINCT i.UID_PWODecisionRule,69      NULL,70      @GenProcID71    FROM inserted i72    EXEC QBM_PDBQueueInsert_bulk 'QER-K-PWOHelperFillMakeProc',73      @DBQueueElements_0274  END TRY75  BEGIN CATCH76    EXEC QBM_PSessionErrorAdd DEFAULT77    RAISERROR('',78    18,79    1)80      WITH NOWAIT81  END CATCH82  ende:83  RETURN84END
Open raw exported source
SQL ยท Raw14 lines
1create   trigger QER_TUPWODecisionRuleRulerDete  on PWODecisionRuleRulerDetect for Update not for Replication as begin  BEGIN TRY if exists (select2 top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = 3dbo.QBM_FGISessionContext('') declare @SQLToCheck_01 QBM_YParameterList insert into @SQLToCheck_01(Parameter1, ContentFull) select c.XObjectKey, replace4(replace(replace(c.SQLQuery , '@UID_AttestationCase', '''123''') , '@UID_PersonWantsorg', '''123''')  , '@UID_QERWorkingStep', '''123''') from deleted 5d join PWODecisionRuleRulerDetect c on d.UID_PWODecisionRuleRulerDetect = c.UID_PWODecisionRuleRulerDetect where isnull(d.SQLQuery, '') <> isnull(c.SQLQuery6, '') and c.SQLQuery > ' ' and left(ltrim(c.SQLQuery), 4) <> 'exec' exec QBM_PSQLCheckExecutable @SQLToCheck_01, @RaiseError = 1 declare @SQLToCheck_027 QBM_YParameterList insert into @SQLToCheck_02(Parameter1, ContentFull) select c.XObjectKey, c.SQLQueryObjectsToRecalc from deleted d join PWODecisionRuleRulerDetect8 c on d.UID_PWODecisionRuleRulerDetect = c.UID_PWODecisionRuleRulerDetect where isnull(d.SQLQueryObjectsToRecalc, '') <> isnull(c.SQLQueryObjectsToRecalc9, '') and c.SQLQueryObjectsToRecalc > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck_02, @RaiseError = 1 declare @DBQueueElements_01 QBM_YDBQueueRaw insert10 into @DBQueueElements_01(Object, SubObject, GenProcID) select distinct i.UID_PWODecisionRule, null, @GenProcID from inserted i exec QBM_PDBQueueInsert_bulk11 'QER-K-PWODecisionRuleMakeProc', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject, GenProcID12) select distinct i.UID_PWODecisionRule, null, @GenProcID from inserted i exec QBM_PDBQueueInsert_bulk 'QER-K-PWOHelperFillMakeProc', @DBQueueElements_0213 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 14