DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_function_escapes  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_jdbc_function_escapes
3     as
4     
5         if @@trancount = 0
6         begin
7             set chained off
8         end
9     
10        set transaction isolation level 1
11    
12        /* this will make sure that all rows are sent even if
13        ** the client "set rowcount" is differect
14        */
15    
16        set rowcount 0
17    
18        /* Adaptive Server has expanded all '*' elements in the following statement */ select [master].dbo.jdbc_function_escapes.escape_name, [master].dbo.jdbc_function_escapes.map_string
19        from master.dbo.jdbc_function_escapes
20    
21    


exec sp_procxmode 'sp_jdbc_function_escapes', 'AnyMode'
go

Grant Execute on sp_jdbc_function_escapes to public
go
RESULT SETS
sp_jdbc_function_escapes_rset_001

DEFECTS
 TNOI 4 Table with no index master..jdbc_function_escapes master..jdbc_function_escapes
 MGTP 3 Grant to public master..jdbc_function_escapes  
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_function_escapes  
 QISO 3 Set isolation level 10
 MRST 2 Result Set Marker 18
 MTR1 2 Metrics: Comments Ratio Comments: 23% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 8 2

DEPENDENCIES
PROCS AND TABLES USED
reads table master..jdbc_function_escapes (1)  
writes table sybsystemprocs..sp_jdbc_function_escapes_rset_001