DatabaseProcApplicationCreatedLinks
sybsystemprocssp_rjs_retrieve  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G% */
3     
4     /*
5     ** Messages for "sp_rjs_retrieve"
6     **   none
7     */
8     
9     create or replace procedure sp_rjs_retrieve as
10        begin
11    
12            If @@trancount = 0
13                set chained off
14    
15            /* Don't do "Dirty Reads" */
16            set transaction isolation level 1
17    
18            /* Get the js rows in alpha order */
19            select js_server = object_cinfo,
20                host_name = char_value,
21                host_port = int_value
22            from master.dbo.sysattributes
23            where class = 22
24            order by object_cinfo
25    
26            return @@error
27        end
28    


Grant Execute on sp_rjs_retrieve to public
go
RESULT SETS
sp_rjs_retrieve_rset_001

DEFECTS
 MINU 4 Unique Index with nullable columns master..sysattributes master..sysattributes
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 23
 MGTP 3 Grant to public master..sysattributes  
 MGTP 3 Grant to public sybsystemprocs..sp_rjs_retrieve  
 MUCO 3 Useless Code Useless Begin-End Pair 10
 QISO 3 Set isolation level 16
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
23
 MRST 2 Result Set Marker 19
 MTR1 2 Metrics: Comments Ratio Comments: 19% 9
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 9
 MTR3 2 Metrics: Query Complexity Complexity: 9 9

DEPENDENCIES
PROCS AND TABLES USED
reads table master..sysattributes (1)  
writes table sybsystemprocs..sp_rjs_retrieve_rset_001