DatabaseProcApplicationCreatedLinks
sybsystemprocssp_helpconfig_estimate  14 déc. 14Defects Propagation Dependencies

1     create or replace procedure sp_helpconfig_estimate(
2         @configname varchar(80)
3         , @confignum int
4         , @estimate_clause varchar(256)
5     ) as
6         begin
7             declare @retval int
8                 , @sprocname varchar(255)
9     
10            set @retval = 1
11            set @sprocname = case @configname
12                    when "compression info pool size"
13                    then "sp_helpconfig_est_compinfo_poolsize"
14                end
15    
16            if (@sprocname IS NULL)
17            begin
18                raiserror 18283, @configname
19                return @retval
20            end
21    
22            exec @retval = @sprocname @configname, @estimate_clause
23            return @retval
24        end
25    


exec sp_procxmode 'sp_helpconfig_estimate', 'AnyMode'
go

Grant Execute on sp_helpconfig_estimate to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_helpconfig_estimate  
 MUCO 3 Useless Code Useless Brackets in create proc 1
 MUCO 3 Useless Code Useless Begin-End Pair 6
 MUCO 3 Useless Code Useless Brackets 16
 MDYE 2 Dynamic Exec Marker exec @retval 22
 MTR1 2 Metrics: Comments Ratio Comments: 0% 1
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 2dec - 2exi + 2 1
 MTR3 2 Metrics: Query Complexity Complexity: 10 1

DEPENDENCIES
CALLERS
called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_helpconfig_gen_estimates_cpi  
      called by proc sybsystemprocs..sp_helpconfig_est_compinfo_poolsize