Back to OIM Explorer

dbo.QER_ZITShopProductNodeCheck

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 4; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 797 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 4
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QER_ZITShopProductNodeCheck at line 4 Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 4
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopProductNodeCheck source text reference
  • queues DBQueue task QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild', @UID_OrgBO, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end

References

Referenced By

Complete Source

SQL40 lines
1CREATE PROCEDURE QER_ZITShopProductNodeCheck(2  @SlotNumber int,3  @UID_OrgBO varchar(38),4  @dummy1 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @WirMachenDasNochEinmal BIT = 010  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM QBMDBQueueCurrent cu14      WITH(nolock)15    WHERE16      cu.SlotNumber <> @SlotNumber AND cu.SlotNumber > 0 AND cu.UID_Parameter = @UID_OrgBO AND cu.UID_Task = 'QER-K-OrgAutoChild')17    BEGIN18      SELECT @WirMachenDasNochEinmal = 119      GOTO NochMalEntscheidung20    END21    EXEC QER_PITShopProductNodeCheck @UID_OrgBO,22      @GenProcID NochMalEntscheidung:23    IF @WirMachenDasNochEinmal = 124    BEGIN25      EXEC QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild',26        @UID_OrgBO,27      '',28        @GenProcID29    END30  END TRY31  BEGIN CATCH32    EXEC QBM_PSessionErrorAdd DEFAULT33    RAISERROR('',34    18,35    1)36      WITH NOWAIT37  END CATCH38  endLabel:39  RETURN40END
Open raw exported source
SQL ยท Raw7 lines
1create   procedure QER_ZITShopProductNodeCheck( @SlotNumber int , @UID_OrgBO varchar(38) , @dummy1 varchar(38) , @GenProcID varchar(38) )  AS begin2 declare @WirMachenDasNochEinmal bit = 0 BEGIN TRY  if exists (select top 1 1 from QBMDBQueueCurrent cu with(nolock) where cu.SlotNumber <> @SlotNumber3 and cu.SlotNumber > 0  and cu.UID_Parameter = @UID_OrgBO and cu.UID_Task = 'QER-K-OrgAutoChild' ) begin select @WirMachenDasNochEinmal = 1 goto NochMalEntscheidung4 end  exec QER_PITShopProductNodeCheck @UID_OrgBO, @GenProcID NochMalEntscheidung: if @WirMachenDasNochEinmal = 1 begin exec QBM_PDBQueueInsert_Single 5'QER-K-OrgAutoChild', @UID_OrgBO, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH 6endLabel: return end 7