DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_classes_in_jar  31 Aug 14Defects Dependencies

1     
2     /*
3     **  sp_ijdbc_classes_in_jar
4     */
5     
6     create procedure sp_ijdbc_classes_in_jar(
7         @jar_name varchar(255))
8     as
9     
10        delete #tmp_classes_in_jar
11    
12        insert #tmp_classes_in_jar
13        select
14            sjc.xtname
15        from
16            sysjars sj, sysxtypes sjc
17        where
18            sj.jid = sjc.xtcontainer and sj.jname = @jar_name
19    


exec sp_procxmode 'sp_ijdbc_classes_in_jar', 'AnyMode'
go

Grant Execute on sp_ijdbc_classes_in_jar 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_ijdbc_classes_in_jar  
 MGTP 3 Grant to public sybsystemprocs..sysjars  
 MGTP 3 Grant to public sybsystemprocs..sysxtypes  
 MNER 3 No Error Check should check @@error after delete 10
 MNER 3 No Error Check should check @@error after insert 12
 MUCO 3 Useless Code Useless Brackets in create proc 6
 QNAJ 3 Not using ANSI Inner Join 15
 MTR1 2 Metrics: Comments Ratio Comments: 6% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 9 6
 PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0 13

DEPENDENCIES
PROCS AND TABLES USED
writes table tempdb..#tmp_classes_in_jar (1) 
reads table sybsystemprocs..sysxtypes  
reads table sybsystemprocs..sysjars