Back to OIM Explorer

dbo.QER_ZRiskIndexMakeProc

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.376 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QER_FGIRiskIndexProcname source text reference
  • references source dbo.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PProcedureDrop source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PQERRiskIndexMakeProc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL66 lines
1CREATE PROCEDURE QER_ZRiskIndexMakeProc(2  @SlotNumber int,3  @UID_DialogColumn varchar(38),4  @Dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @Aktiv nvarchar(256)10  DECLARE @ProcName nvarchar(128)11  DECLARE @ResetMessage nvarchar(4000)12  SET XACT_ABORT OFF13  BEGIN TRY14    SELECT @Aktiv = dbo.QBM_FGIConfigparmValue('QER\CalculateRiskIndex')15    SELECT @ProcName = dbo.QER_FGIRiskIndexProcname(@uid_dialogcolumn)16    IF @Aktiv = '1' AND EXISTS(17      SELECT TOP 1 118      FROM DialogColumn19      WITH(readpast)20    WHERE21      UID_DialogColumn = @uid_DialogColumn AND IsDeactivatedByPreProcessor = 0)22    BEGIN23      IF EXISTS(24        SELECT TOP 1 125        FROM DialogColumn c26        WITH(readpast)27      JOIN dialogtable t28        WITH(readpast)29        ON c.UID_DialogTable = t.UID_DialogTable30      WHERE31        c.uid_DialogColumn = @uid_DialogColumn AND t.tabletype IN('T', 'B') AND c.ColumnName IN('RiskIndexCalculated',32      'RiskIndexReduced'))33      BEGIN34        BEGIN TRY35          EXEC QER_PQERRiskIndexMakeProc @uid_DialogColumn36        END TRY37        BEGIN CATCH38          EXEC QBM_PSessionErrorAdd DEFAULT39          SELECT @ResetMessage = ERROR_MESSAGE()40          IF @@TRANCOUNT > 041          BEGIN42            ROLLBACK43          END44          EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,45            @ResetMessage,46            @@PROCID47        END CATCH48      END49    END50    ELSE51    BEGIN52      GOTO dropOnly53    END54  END TRY55  BEGIN CATCH56    EXEC QBM_PSessionErrorAdd DEFAULT57    RAISERROR('',58    18,59    1)60      WITH NOWAIT61  END CATCH62  ende:63  RETURN dropOnly:64  EXEC QBM_PProcedureDrop @ProcName65  RETURN66END
Open raw exported source
SQL ยท Raw10 lines
1  create   procedure QER_ZRiskIndexMakeProc (@SlotNumber int , @UID_DialogColumn varchar(38) , @Dummy varchar(38) , @GenProcID varchar(38) ) as 2begin    declare @Aktiv nvarchar(256) declare @ProcName nvarchar(128) declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF BEGIN TRY select @Aktiv =3 dbo.QBM_FGIConfigparmValue('QER\CalculateRiskIndex')  select @ProcName = dbo.QER_FGIRiskIndexProcname( @uid_dialogcolumn ) if @Aktiv = '1'  and exists4 (select top 1 1 from DialogColumn with (readpast) where UID_DialogColumn = @uid_DialogColumn and IsDeactivatedByPreProcessor = 0 ) begin  if exists (select5 top 1 1 from DialogColumn c with (readpast) join dialogtable t with (readpast) on c.UID_DialogTable = t.UID_DialogTable where c.uid_DialogColumn = @uid_DialogColumn6  and t.tabletype in ('T', 'B')  and c.ColumnName in( 'RiskIndexCalculated', 'RiskIndexReduced') )      begin BEGIN TRY exec QER_PQERRiskIndexMakeProc 7@uid_DialogColumn END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec8 QBM_PDBQueueCurrentResetNGen @SlotNumber , @ResetMessage , @@PROCID END CATCH end     end else begin goto dropOnly end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd9 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return dropOnly: exec QBM_PProcedureDrop @ProcName return end 10