Database	Proc	Application	Created	Links
sybsystemprocs	sp_jdbc_jar_for_class		31 Aug 14	Defects Dependencies

1     /** SECTION END: CLEANUP **/
2     
3     create procedure sp_jdbc_jar_for_class(
4         @class_name varchar(255))
5     as
6         select
7             sj.jbinary
8         from
9             sysjars sj, sysxtypes sjc
10        where
11            sjc.xtname = @class_name and sj.jid = sjc.xtcontainer
12    

exec sp_procxmode 'sp_jdbc_jar_for_class', 'AnyMode'
go

Grant Execute on sp_jdbc_jar_for_class to public
go

DEFECTS
MINU 4 Unique Index with nullable columns sybsystemprocs..sysjars	sybsystemprocs..sysjars
MINU 4 Unique Index with nullable columns sybsystemprocs..sysxtypes	sybsystemprocs..sysxtypes
MGTP 3 Grant to public sybsystemprocs..sp_jdbc_jar_for_class
MGTP 3 Grant to public sybsystemprocs..sysjars
MGTP 3 Grant to public sybsystemprocs..sysxtypes
MUCO 3 Useless Code Useless Brackets in create proc	3
QNAJ 3 Not using ANSI Inner Join	8
MRST 2 Result Set Marker	6
MTR1 2 Metrics: Comments Ratio Comments: 10%	3
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	3
MTR3 2 Metrics: Query Complexity Complexity: 6	3
PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0	6

DEPENDENCIES

PROCS AND TABLES USED reads table sybsystemprocs..sysxtypes   reads table sybsystemprocs..sysjars