DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_function_escapes  31 Aug 14Defects Dependencies

1     
2     create procedure sp_ijdbc_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        delete #tmp_function_escapes
13    
14        /* Adaptive Server has expanded all '*' elements in the following statement */ insert #tmp_function_escapes
15        select master.dbo.ijdbc_function_escapes.escape_name, master.dbo.ijdbc_function_escapes.map_string
16        from master.dbo.ijdbc_function_escapes
17    
18    


exec sp_procxmode 'sp_ijdbc_function_escapes', 'AnyMode'
go

Grant Execute on sp_ijdbc_function_escapes to public
go
DEFECTS
 TNOI 4 Table with no index master..ijdbc_function_escapes master..ijdbc_function_escapes
 MGTP 3 Grant to public master..ijdbc_function_escapes  
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_function_escapes  
 MNER 3 No Error Check should check @@error after delete 12
 MNER 3 No Error Check should check @@error after insert 14
 QISO 3 Set isolation level 10
 MTR1 2 Metrics: Comments Ratio Comments: 14% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 10 2

DEPENDENCIES
PROCS AND TABLES USED
writes table tempdb..#tmp_function_escapes (1) 
reads table master..ijdbc_function_escapes (1)