DatabaseProcApplicationCreatedLinks
sybsystemprocssp_sendmsg  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     
4     create or replace procedure sp_sendmsg
5         @ip_address varchar(255), /* IP address to send the message */
6         @port_number int, /* Port number */
7         @message varchar(4096) /* Message to be sent */
8     as
9     
10        declare @returncode int
11    
12        if @@trancount = 0
13        begin
14            set chained off
15            set transaction isolation level 1
16        end
17    
18    
19        /* Do the work */
20        select @returncode = syb_sendmsg(@ip_address, @port_number, @message)
21    
22        if ((@returncode = 0) or (@returncode is null))
23        begin
24            return (0)
25        end
26        else
27        begin
28            return (1)
29        end
30    
31    

DEFECTS
 MUCO 3 Useless Code Useless Brackets 22
 MUCO 3 Useless Code Useless Brackets 24
 MUCO 3 Useless Code Useless Brackets 28
 QISO 3 Set isolation level 15
 MTR1 2 Metrics: Comments Ratio Comments: 16% 4
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 4dec - 3exi + 2 4
 MTR3 2 Metrics: Query Complexity Complexity: 12 4

DEPENDENCIES