DatabaseProcApplicationCreatedLinks
sybsystemprocssp_spaceusage_showhelp_all  31 Aug 14Defects Dependencies

1     
2     /*
3     **	SP_SPACEUSAGE_SHOWHELP_ALL
4     **
5     **	The sub-procedure to print help/usage information for all actions and
6     **	entitites supported by the sp_spaceusage procedure. Called by 
7     **	sp_spaceusage_showhelp.
8     **
9     **	Parameters
10    **		@verbose	- Information mode is verbose or terse.
11    **
12    **	Returns 
13    **		0 - always. Prints the usage information or error messge for
14    **		    invalid action/entity.
15    {
16    */
17    create procedure sp_spaceusage_showhelp_all
18    (
19        @verbose bit
20    )
21    as
22        begin -- {
23    
24            if @verbose = 1
25            begin
26                exec sp_spaceusage_showhelp_display "table", 1
27                exec sp_spaceusage_showhelp_display "index", 0
28                exec sp_spaceusage_showhelp_display "tranlog", 0
29                exec sp_spaceusage_showhelp_archive "table", 1
30                exec sp_spaceusage_showhelp_archive "index", 0
31                exec sp_spaceusage_showhelp_archive "tranlog", 0
32                exec sp_spaceusage_showhelp_report "table", 1
33                exec sp_spaceusage_showhelp_report "index", 0
34                exec sp_spaceusage_showhelp_report "tranlog", 0
35            end
36            else
37            begin
38                exec sp_spaceusage_showhelp_display NULL, 0
39                exec sp_spaceusage_showhelp_archive NULL, 0
40                exec sp_spaceusage_showhelp_report NULL, 0
41            end
42    
43            return (0)
44    
45        end -- }	-- }
46    


exec sp_procxmode 'sp_spaceusage_showhelp_all', 'AnyMode'
go

Grant Execute on sp_spaceusage_showhelp_all to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_spaceusage_showhelp_all  
 MNER 3 No Error Check should check return value of exec 26
 MNER 3 No Error Check should check return value of exec 27
 MNER 3 No Error Check should check return value of exec 28
 MNER 3 No Error Check should check return value of exec 29
 MNER 3 No Error Check should check return value of exec 30
 MNER 3 No Error Check should check return value of exec 31
 MNER 3 No Error Check should check return value of exec 32
 MNER 3 No Error Check should check return value of exec 33
 MNER 3 No Error Check should check return value of exec 34
 MNER 3 No Error Check should check return value of exec 38
 MNER 3 No Error Check should check return value of exec 39
 MNER 3 No Error Check should check return value of exec 40
 MUCO 3 Useless Code Useless Brackets in create proc 18
 MUCO 3 Useless Code Useless Begin-End Pair 22
 MUCO 3 Useless Code Useless Brackets 43
 MTR1 2 Metrics: Comments Ratio Comments: 31% 17
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 17
 MTR3 2 Metrics: Query Complexity Complexity: 16 17

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_spaceusage_showhelp_archive  
   calls proc sybsystemprocs..sp_getmessage  
      reads table sybsystemprocs..sysusermessages  
      reads table master..sysmessages (1)  
      reads table master..syslanguages (1)  
      calls proc sybsystemprocs..sp_validlang  
         reads table master..syslanguages (1)  
calls proc sybsystemprocs..sp_spaceusage_showhelp_display  
   calls proc sybsystemprocs..sp_getmessage  
calls proc sybsystemprocs..sp_spaceusage_showhelp_report  
   calls proc sybsystemprocs..sp_getmessage  

CALLERS
called by proc sybsystemprocs..sp_spaceusage_showhelp  
   called by proc sybsystemprocs..sp_spaceusage