Database | Proc | Application | Created | Links |
sybsystemprocs | sp_jdbc_function_escapes | 31 Aug 14 | Defects Dependencies |
1 /** SECTION END: CLEANUP **/ 2 3 create procedure sp_jdbc_function_escapes 4 as 5 6 if @@trancount = 0 7 begin 8 set chained off 9 end 10 11 set transaction isolation level 1 12 13 /* this will make sure that all rows are sent even if 14 ** the client "set rowcount" is differect 15 */ 16 17 set rowcount 0 18 19 /* 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 20 from master.dbo.jdbc_function_escapes 21 22
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 | 11 |
MRST 2 Result Set Marker | 19 |
MTR1 2 Metrics: Comments Ratio Comments: 26% | 3 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 | 3 |
MTR3 2 Metrics: Query Complexity Complexity: 8 | 3 |
DEPENDENCIES |
PROCS AND TABLES USED reads table master..jdbc_function_escapes (1) |