Back to OIM Explorer

dbo.QBM_TIAssembly_DialogColumn

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogColumn. Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3; Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3; Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 3; Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3

Source: sandbox-db sys.sql_modules

Source size: 1.972 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

  • Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 3
  • Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 4
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 4
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 4
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 4
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 7
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 7
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 7
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 11
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 11
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 12
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogColumn

Typed Edges

  • queues DBQueue task QBM_ZScriptAssemblyReset at line 3 Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • queues DBQueue task QBM_ZViewBuildAll at line 3 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 3
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3
  • queues DBQueue task QBM_ZRITriggerCreate at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 3
  • queues DBQueue task QBM_ZScriptAssemblyReset at line 4 Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 4
  • queues DBQueue task QBM_ZViewBuildAll at line 4 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 4
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 4 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 4
  • queues DBQueue task QBM_ZRITriggerCreate at line 4 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 4
  • queues DBQueue task QBM_ZViewBuildAll at line 7 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 7
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 7 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 7
  • queues DBQueue task QBM_ZRITriggerCreate at line 7 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 7
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 11 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 11
  • queues DBQueue task QBM_ZRITriggerCreate at line 11 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 11
  • queues DBQueue task QBM_ZRITriggerCreate at line 12 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 12
  • trigger on table DialogColumn Trigger parent table: DialogColumn
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGITableName source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL92 lines
1CREATE trigger QBM_TIAssembly_DialogColumn2  ON DialogColumn FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    IF EXISTS(14      SELECT TOP 1 115      FROM inserted i16      JOIN dialogtable t17        ON i.UID_DialogTable = t.UID_DialogTable18      WHERE19        t.TableType IN('T', 'V') AND i.Template > ' ')20    BEGIN21      EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',22      'Tmpl',23      '#',24        @genProcID25    END26    EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',27    'TypedWrappers',28    '#',29      @GenProcID30    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw31    INSERT INTO @DBQueueElements_01(object,32    subobject,33    genprocid)34    SELECT35      x.uid,36      NULL,37      @GenProcID38    FROM(39    SELECT i.UID_DialogTable AS UID40    FROM inserted i41    UNION42    SELECT t.UID_DialogTableBase43    FROM inserted i44    JOIN dialogtable t45      ON i.UID_DialogTable = t.UID_DialogTable46    WHERE47      t.UID_DialogTableBase > ' '48    UNION49    SELECT t.UID_DialogTableUnion50    FROM inserted i51    JOIN dialogtable t52      ON i.UID_DialogTable = t.UID_DialogTable53    WHERE54      t.UID_DialogTableUnion > ' ') AS x55    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView',56      @DBQueueElements_0157    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw58    INSERT INTO @DBQueueElements_02(object,59    subobject,60    genprocid)61    SELECT62      x.uid,63      NULL,64      @GenProcID65    FROM(66    SELECT dbo.QBM_FGITableName(i.UID_DialogTable) AS UID67    FROM inserted i68    UNION69    SELECT dbo.QBM_FGITableName(t.UID_DialogTableBase)70    FROM dialogtable t71    JOIN inserted c72      ON c.UID_DialogTable = t.UID_DialogTable73    WHERE74      t.UID_DialogTableBase > ' '75    UNION76    SELECT dbo.QBM_FGITableName(t.UID_DialogTable)77    FROM dialogtable t78    JOIN inserted c79      ON c.UID_DialogTable = t.UID_DialogTableUnion) AS x80    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',81      @DBQueueElements_0282    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger',83      @DBQueueElements_0284  END TRY85  BEGIN CATCH86    EXEC QBM_PSessionErrorAdd DEFAULT87    RAISERROR('',88    18,89    1)90      WITH NOWAIT91  END CATCH92END
Open raw exported source
SQL ยท Raw14 lines
1   create   trigger QBM_TIAssembly_DialogColumn on DialogColumn  for Insert not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: if exists (select top 1 1 from inserted i join dialogtable t on i.UID_DialogTable3 = t.UID_DialogTable where t.TableType in ('T', 'V') and i.Template > ' ' ) begin  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Tmpl', 4'#', @genProcID  end  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'TypedWrappers', '#', @GenProcID  declare @DBQueueElements_01 QBM_YDBQueueRaw5 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_DialogTable as UID from inserted i union6 select t.UID_DialogTableBase from inserted i join dialogtable t on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select7 t.UID_DialogTableUnion from inserted i join dialogtable t on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk8 'QBM-K-CommonRebuildView', @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid9) select x.uid, null, @GenProcID from (select dbo.QBM_FGITableName(i.UID_DialogTable) as UID from inserted i union select dbo.QBM_FGITableName(t.UID_DialogTableBase10) from dialogtable t join inserted c on c.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union  select dbo.QBM_FGITableName(t.UID_DialogTable11) from dialogtable t join inserted c on c.UID_DialogTable = t.UID_DialogTableUnion  ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',12 @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger', @DBQueueElements_02  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default13 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 14