Database	Proc	Application	Created	Links
sybsystemprocs	sp_sendmsg		31 Aug 14	Defects Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     
4     create 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: 2 = 3dec - 3exi + 2	4
MTR3 2 Metrics: Query Complexity Complexity: 12	4