DatabaseProcApplicationCreatedLinks
sybsystemprocssp_inform  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     
4     /*
5     ** A Microsoft catalog stored procedure is named sp_server_info, too
6     ** close to the Sybase internal stored proc "sp_serverinfo".  Since
7     ** Sybase's sp_serverinfo has not been documented to customers, this new
8     ** stored procedure simply calls sp_serverinfo.  This new procedure
9     ** should replace sp_serverinfo eventually in Sybase products and could
10    ** be exposed to customers at any time.
11    */
12    
13    create or replace procedure sp_inform
14        @request varchar(30) = NULL,
15        @arg1 varchar(30) = NULL, /* optional arg1 */
16        @arg2 varchar(30) = NULL, /* optional arg2 */
17        @arg3 varchar(30) = NULL, /* optional arg3 */
18        @arg4 varchar(30) = NULL, /* optional arg4 */
19        @arg5 varchar(30) = NULL, /* optional arg5 */
20        @arg6 varchar(30) = NULL, /* optional arg6 */
21        @arg7 varchar(30) = NULL, /* optional arg7 */
22        @arg8 varchar(30) = NULL, /* optional arg8 */
23        @arg9 varchar(30) = NULL /* optional arg9 */
24    as
25    
26        declare @re_request varchar(30)
27        declare @re_arg1 varchar(30)
28        declare @re_arg2 varchar(30)
29        declare @re_arg3 varchar(30)
30        declare @re_arg4 varchar(30)
31        declare @re_arg5 varchar(30)
32        declare @re_arg6 varchar(30)
33        declare @re_arg7 varchar(30)
34        declare @re_arg8 varchar(30)
35        declare @re_arg9 varchar(30)
36        declare @retval int
37    
38        if @@trancount = 0
39        begin
40            set chained off
41        end
42    
43        set transaction isolation level 1
44    
45        set nocount on
46    
47        select @re_request = @request
48        select @re_arg1 = @arg1
49        select @re_arg2 = @arg2
50        select @re_arg3 = @arg3
51        select @re_arg4 = @arg4
52        select @re_arg5 = @arg5
53        select @re_arg6 = @arg6
54        select @re_arg7 = @arg7
55        select @re_arg8 = @arg8
56        select @re_arg9 = @arg9
57        select @retval = 1
58    
59        execute @retval = sp_serverinfo @request = @re_request,
60            @arg1 = @re_arg1, @arg2 = @re_arg2, @arg3 = @re_arg3,
61            @arg4 = @re_arg4, @arg5 = @re_arg5, @arg6 = @re_arg6,
62            @arg7 = @re_arg7, @arg8 = @re_arg8, @arg9 = @re_arg9
63    
64        return @retval
65    


exec sp_procxmode 'sp_inform', 'AnyMode'
go

Grant Execute on sp_inform to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_inform  
 MNER 3 No Error Check should check return value of exec 59
 QISO 3 Set isolation level 43
 MTR1 2 Metrics: Comments Ratio Comments: 28% 13
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 13
 MTR3 2 Metrics: Query Complexity Complexity: 30 13

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_serverinfo  
   reads table master..syscurconfigs (1)  
   writes table sybsystemprocs..sp_serverinfo_rset_004 
   reads table master..syscharsets (1)  
   writes table sybsystemprocs..sp_serverinfo_rset_003 
   calls proc sybsystemprocs..sp_getmessage  
      reads table sybsystemprocs..sysusermessages  
      reads table master..syslanguages (1)  
      calls proc sybsystemprocs..sp_validlang  
         reads table master..syslanguages (1)  
      reads table master..sysmessages (1)  
   writes table sybsystemprocs..sp_serverinfo_rset_002 
   writes table sybsystemprocs..sp_serverinfo_rset_001 
   writes table sybsystemprocs..sp_serverinfo_rset_005