DatabaseProcApplicationCreatedLinks
sybsystemprocssp_help_metrics  31 Aug 14Defects Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     
4     /*
5     ** Messages for "sp_help_metrics"
6     **
7     ** 19347, "Usage: sp_metrics [ 'command', [ '@arg1', [ '@arg2' ] ] ]"
8     ** 19348, "help - get help on a command"
9     ** 19349, "flush - flush all metrics from memory to system tables"
10    ** 19350, "drop - drop a metric ID or a group of metrics"
11    ** 19351, "backup - move the metrics in the default group to a backup group"       
12    ** 19418, "filter - delete metrics records based on filtering condition"
13    ** 19459, "show - display the number of records in each metrics group"
14    ** 19352, "Usage: sp_metrics 'help' [, 'command' ]"
15    ** 19353, "Usage: sp_metrics 'flush'"
16    ** 19354, "Usage: sp_metrics 'drop', '@gid'  [, '@id' ]"
17    ** 19355, "Usage: sp_metrics 'backup', '@gid'"
18    ** 19419, "Usage: sp_metrics 'filter', '@gid' [, '@predicate' ]"
19    ** 19460, "Usage: sp_metrics 'show'"
20    ** 19356, "'%1!' is an unsupported command. Check command and retry sp_metrics"
21    */
22    
23    /*
24    ** sp_help_metrics displays usage information for qpmetrics
25    ** related stored procedures
26    */
27    create procedure sp_help_metrics
28        @cmdtype varchar(30) = NULL
29    as
30        declare @msg varchar(250)
31    
32        if (@cmdtype is NULL)
33        begin
34            exec sp_getmessage 19347, @msg output print @msg
35            print " "
36            print "Command list:"
37    
38            exec sp_getmessage 19348, @msg output print @msg
39            exec sp_getmessage 19349, @msg output print @msg
40            exec sp_getmessage 19350, @msg output print @msg
41            exec sp_getmessage 19351, @msg output print @msg
42            exec sp_getmessage 19418, @msg output print @msg
43            exec sp_getmessage 19459, @msg output print @msg
44            print " "
45    
46            return 0
47        end
48    
49        if (@cmdtype = 'help')
50        begin
51            exec sp_getmessage 19352, @msg output print @msg
52            return 0
53        end
54    
55        if (@cmdtype = 'flush')
56        begin
57            exec sp_getmessage 19353, @msg output print @msg
58            return 0
59        end
60    
61        if (@cmdtype = 'drop')
62        begin
63            exec sp_getmessage 19354, @msg output print @msg
64            return 0
65        end
66    
67        if (@cmdtype = 'backup')
68        begin
69            exec sp_getmessage 19355, @msg output print @msg
70            return 0
71        end
72    
73        if (@cmdtype = 'filter')
74        begin
75            exec sp_getmessage 19419, @msg output print @msg
76            return 0
77        end
78    
79        if (@cmdtype = 'show')
80        begin
81            exec sp_getmessage 19460, @msg output print @msg
82            return 0
83        end
84    
85        raiserror 19356, @cmdtype
86    
87        return 1
88    


exec sp_procxmode 'sp_help_metrics', 'AnyMode'
go

Grant Execute on sp_help_metrics to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_help_metrics  
 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
 MNER 3 No Error Check should check return value of exec 41
 MNER 3 No Error Check should check return value of exec 42
 MNER 3 No Error Check should check return value of exec 43
 MNER 3 No Error Check should check return value of exec 51
 MNER 3 No Error Check should check return value of exec 57
 MNER 3 No Error Check should check return value of exec 63
 MNER 3 No Error Check should check return value of exec 69
 MNER 3 No Error Check should check return value of exec 75
 MNER 3 No Error Check should check return value of exec 81
 MUCO 3 Useless Code Useless Brackets 32
 MUCO 3 Useless Code Useless Brackets 49
 MUCO 3 Useless Code Useless Brackets 55
 MUCO 3 Useless Code Useless Brackets 61
 MUCO 3 Useless Code Useless Brackets 67
 MUCO 3 Useless Code Useless Brackets 73
 MUCO 3 Useless Code Useless Brackets 79
 MTR1 2 Metrics: Comments Ratio Comments: 44% 27
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 7dec - 8exi + 2 27
 MTR3 2 Metrics: Query Complexity Complexity: 54 27

DEPENDENCIES
PROCS AND TABLES USED
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)  

CALLERS
called by proc sybsystemprocs..sp_metrics