DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_jar_for_class  14 déc. 14Defects Propagation Dependencies

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


exec sp_procxmode 'sp_jdbc_jar_for_class', 'AnyMode'
go

Grant Execute on sp_jdbc_jar_for_class to public
go
RESULT SETS
sp_jdbc_jar_for_class_rset_001

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 2
 QNAJ 3 Not using ANSI Inner Join 7
 MRST 2 Result Set Marker 5
 MTR1 2 Metrics: Comments Ratio Comments: 0% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 6 2
 PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0 5

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysxtypes  
writes table sybsystemprocs..sp_jdbc_jar_for_class_rset_001 
reads table sybsystemprocs..sysjars