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

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)