dbo.QBM_PViewBuild
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
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_FGISessionContext source text reference
- references source dbo.QBM_FGISessionErrorRethrow source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
- references source dbo.QBM_PViewBuildP source text reference
- references source dbo.QBM_PViewBuildR source text reference
- references source dbo.QBM_PViewBuildU source text reference
- references source dbo.QBM_PViewBuildV source text reference
References
- dbo.QBM_FGISessionContext
- dbo.QBM_FGISessionErrorRethrow
- dbo.QBM_PSessionErrorAdd
- dbo.QBM_PViewBuildP
- dbo.QBM_PViewBuildR
- dbo.QBM_PViewBuildU
- dbo.QBM_PViewBuildV
Referenced By
- dbo.QBM_PCustomSQLPropagate
- dbo.QBM_PViewBuild_FromAddOn
- dbo.QBM_PViewBuildCheckCCCExtend
- dbo.QBM_PViewBuildP
- dbo.QBM_PViewBuildP_intern
- dbo.QBM_PViewBuildPrepareVPUR
- dbo.QBM_PViewBuildR
- dbo.QBM_PViewBuildR_intern
- dbo.QBM_PViewBuildU
- dbo.QBM_PViewBuildU_intern
- dbo.QBM_PViewBuildV
- dbo.QBM_PViewBuildV_intern
- dbo.QBM_ZViewBuildP
- dbo.QBM_ZViewBuildR
- dbo.QBM_ZViewBuildU
- dbo.QBM_ZViewBuildV
- dbo.QBM_TIQBMViewAddOn
- dbo.QBM_TUQBMViewAddOn
Complete Source
1CREATE PROCEDURE QBM_PViewBuild(2 @UID_TablePattern varchar(38) = '%',3 @dummy1 varchar(38) = '',4 @GenProcID varchar(38) = ''5)6AS7BEGIN8 DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')9 DECLARE @tablepattern_intern varchar(38)10 SET XACT_ABORT OFF11 BEGIN TRY12 IF isnull(@GenProcID,13 '') = ''14 BEGIN15 SELECT @GenProcID = @GenProcID_R16 END17 IF isnull(@UID_TablePattern,18 '') = ''19 BEGIN20 SELECT @tablepattern_intern = '%'21 END22 ELSE23 BEGIN24 SELECT @tablepattern_intern = @UID_TablePattern25 END26 EXEC QBM_PViewBuildV @tablepattern_intern,27 '',28 @GenProcID29 EXEC QBM_PViewBuildP @tablepattern_intern,30 '',31 @GenProcID32 EXEC QBM_PViewBuildU @tablepattern_intern,33 '',34 @GenProcID35 EXEC QBM_PViewBuildR @tablepattern_intern,36 '',37 @GenProcID38 END TRY39 BEGIN CATCH40 EXEC QBM_PSessionErrorAdd DEFAULT41 DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()42 RAISERROR(@Rethrow,43 18,44 1)45 WITH NOWAIT46 END CATCH47 ende:48 RETURN49ENDOpen raw exported source
1 create procedure QBM_PViewBuild ( @UID_TablePattern varchar(38) = '%' , @dummy1 varchar(38) = '' , @GenProcID varchar(38) = '' ) as begin2 declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @tablepattern_intern varchar(38) SET XACT_ABORT OFF BEGIN TRY if isnull(@GenProcID3, '') = '' begin select @GenProcID = @GenProcID_R end if isnull(@UID_TablePattern, '') = '' begin select @tablepattern_intern = '%' end else begin select4 @tablepattern_intern = @UID_TablePattern end exec QBM_PViewBuildV @tablepattern_intern, '', @GenProcID exec QBM_PViewBuildP @tablepattern_intern, '', 5@GenProcID exec QBM_PViewBuildU @tablepattern_intern, '', @GenProcID exec QBM_PViewBuildR @tablepattern_intern, '', @GenProcID END TRY BEGIN CATCH exec6 QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende:7 return end 8