Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_function_escapes | 31 Aug 14 | Defects 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) |